MySQL 5.5 on Ubuntu 12.04 – Job Failed to Start

  1. mysql-hires_655x250

I migrated a web site from one host to another and as such upgraded to MySQL 5.5 running on Ubuntu 12.04.  Everything was moving along nicely until MySQL started to randomly crash.
[code]
Jul 23 07:06:38 domU-12-31-39-02-76-EA kernel: [236645.626405] init: mysql main process (21515) terminated with status 1
Jul 23 07:06:38 domU-12-31-39-02-76-EA kernel: [236645.626453] init: mysql main process ended, respawning
Jul 23 07:06:39 domU-12-31-39-02-76-EA kernel: [236646.617559] init: mysql post-start process (21516) terminated with status 1
[/code]

Trying to start the process using the service command yields this message:
[code]
Job failed to start
[/code]

I found several sites recommending that I uninstall and re-install mysqld – which I did to no avail.

I finally tried to run mysqld manually from command line and found a bit more of a clue:

[code]
120723 7:40:29 [Note] Plugin 'FEDERATED' is disabled.
120723 7:40:29 InnoDB: The InnoDB memory heap is disabled
120723 7:40:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120723 7:40:29 InnoDB: Compressed tables use zlib 1.2.3.4
120723 7:40:29 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
120723 7:40:29 InnoDB: Completed initialization of buffer pool
120723 7:40:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120723 7:40:29 [ERROR] Plugin 'InnoDB' init function returned error.
120723 7:40:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120723 7:40:29 [ERROR] Unknown/unsupported storage engine: InnoDB
120723 7:40:29 [ERROR] Aborting
120723 7:40:29 [Note] /usr/sbin/mysqld: Shutdown complete
[/code]

Aha!  Looks like something with the configuration of Innodb.

Checking some of these messages revealed that the default configuration for innodb_buffer_pool_size is 128M… for my small server this was simply too large.

From here, I simply modified /etc/mysql/my.cnf to include the following statement
[code]
innodb_buffer_pool_size = 16M
[/code]

A much more reasonable number considering the size of my server memory. Now simply start your mysql server and you should be good to go!

Posted in:
About the Author

mike

Michael solves problems related to technology and business. Also, he types things into computers.

Leave a Reply

Your email address will not be published. Required fields are marked *