MyISAM was the default storage engine for the MySQL relational database management system versions prior to 5.5 http://en.wikipedia.org/wiki/MyISAM
Wheezy deprecates the use of MyISAM with MySQL 5.5.
Simply add:
default-storage-engine=myisam
..under the [mysqld]
section in the file /etc/mysql/my.cnf
I recently ran into this when doing an upgrade from Debian Squeeze to Wheezy. After the upgrade MySQL just failed to start.
The symptoms I got were a bit similar to what is posted here:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=682232
However, the proposed solution of
rm /var/lib/mysql/ib*
..did not work for me.
To make things more interesting, there were no errors written to the mysql log files. They were there, but just 0 bytes. Btw, the /var/log/mysql
directory was empty.
wordpress:~# l -dg /var/log/mysql*
drwxr-s--- 2 adm 4.0K Jun 10 2010 /var/log/mysql
-rw-r----- 1 adm 0 Oct 9 15:06 /var/log/mysql.err
-rw-r----- 1 adm 0 Oct 9 15:06 /var/log/mysql.log
I then ran the mysqld
command from the command line. This finally produced some helpful information:
wordpress:~# mysqld
141009 15:39:50 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
141009 15:39:50 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141009 15:39:50 [Note] Plugin 'FEDERATED' is disabled.
141009 15:39:50 InnoDB: The InnoDB memory heap is disabled
141009 15:39:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141009 15:39:50 InnoDB: Compressed tables use zlib 1.2.7
141009 15:39:50 InnoDB: Using Linux native AIO
141009 15:39:50 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(135987200 bytes) failed; errno 12
141009 15:39:50 InnoDB: Completed initialization of buffer pool
141009 15:39:50 InnoDB: Fatal error: cannot allocate memory for the buffer pool
141009 15:39:50 [ERROR] Plugin 'InnoDB' init function returned error.
141009 15:39:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141009 15:39:50 [ERROR] Unknown/unsupported storage engine: InnoDB
141009 15:39:50 [ERROR] Aborting
141009 15:39:50 [Note] mysqld: Shutdown complete
Apparently, InnoDB was not supported. This is fine for me as I have been using MyISAM
in the past on this server.
A quick search for some of these errors pointed to a link (also on ServerFault) with the anser in one of the comments:
Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu
The key is to specify the default storage engine as per Andy Mikhaylenko's answer.
Apparently the answer also speaks of adding skip-innodb
but that wasn't a requirement on my system to make MySQL start up again.
Why don't you take a look at http://www.dev-metal.com/setup-latest-version-php-5-5-debian-wheezy-7-07-1-fix-gpg-key-error/
Then you are using a PHP version from the repositories, which is always a better idea. You can then also install the php-dev package.
Do note the warning about the Apache upgrade.
In short:
Add these lines to your /etc/apt/sources.list
deb http://packages.dotdeb.org wheezy-php55 all
deb-src http://packages.dotdeb.org wheezy-php55 all
To get over the verified sources error:
gpg --keyserver packages.dotdeb.org --recv-key E9C74FEEA2098A6E
gpg -a --export E9C74FEEA2098A6E | sudo apt-key add -
After that:
apt-get update
apt-get install php5 php5-dev
Best Answer
You've booted your system with OVH's custom kernel, which is built to OVH's specifications, and may not be suitable for running software you want to run.
Change your dedicated server configuration to boot from the kernel installed on the hard drive provided by your Linux distribution.