Question

0

Mysql not starting - innodb not found

rated 0 times [ 0] [ 0] / answers: 1 / hits: 3143 / 2 Years ago, fri, november 4, 2022, 9:16:00

I have a fresh install of ubuntu 12.04 server edition and mysql server is not starting properly.

I did a simple apt-get install

apt-get install mysql-server

But, it's failing with this error message

root@test:~# mysqld

120618 20:57:32 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.

120618 20:57:32 [Note] Plugin 'FEDERATED' is disabled.

120618 20:57:32 InnoDB: The InnoDB memory heap is disabled

120618 20:57:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins

120618 20:57:32 InnoDB: Compressed tables use zlib 1.2.3.4

120618 20:57:32 InnoDB: Unrecognized value fdatasync for innodb_flush_method

120618 20:57:32 [ERROR] Plugin 'InnoDB' init function returned error.

120618 20:57:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

120618 20:57:32 [ERROR] Unknown/unsupported storage engine: InnoDB

120618 20:57:32 [ERROR] Aborting

I can start the server with the "--skip-innodb --default-storage-engine=myisam" flags, but would like to use innodb.

Does anyone know what the issue here is?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

ickump

Add To Favorites

Follow

Total Points: 234

Total Questions: 124

Total Answers: 111

Location: Jordan

Member since Fri, Apr 8, 2022

2 Years ago

ickump questions

1 What is the Super key?

Mon, Aug 16, 21, 08:46, 3 Years ago

1 Encrypted disk not available in boot process after distro upgrade

Thu, Mar 3, 22, 06:29, 2 Years ago

1 Iptables that only allow incoming traffic to OpenSSH and block all other traffic

Mon, Feb 14, 22, 03:53, 2 Years ago

1 identify M.2 SSD from BASH Script

Mon, Aug 22, 22, 02:44, 2 Years ago

1 Correct way to execute a script on resume from suspend

Sun, Oct 2, 22, 07:13, 2 Years ago

View All

answered 2 Years ago cocal · Accepted Answer

It was a configuration file issue. We are creating chef scripts to do deploys, and had used OpCode's mysql package, which did some very odd things that messed up Mysql on the machine that we had no expected, setting some configuration values to things that just didn't work.

If using chef, I advise to use the package available though apt-get

package "mysql-server" do

  action :install

end

package "mysql-client" do

  action :install

end

Then change the password through the code provided by OpCode, or changing it after the server install.

This was on Rackspace with Ubuntu 12.04 Server.