The MySQL daemon on my CentOS server keeps crashing, i got the logs from /var/logs/mysqld but still i am not sure how to fix this:
121114 16:22:56 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
121114 21:55:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121114 21:55:11 [Note] Plugin 'FEDERATED' is disabled.
121114 21:55:11 InnoDB: The InnoDB memory heap is disabled
121114 21:55:11 InnoDB: Mutexes and rw_locks
use GCC atomic builtins
121114 21:55:11 InnoDB: Compressed tables use zlib 1.2.3
121114 21:55:11 InnoDB: Using Linux native AIO
121114 21:55:11 InnoDB: Initializing buffer pool, size = 128.0M
121114 21:55:11 InnoDB: Completed initialization of buffer pool
121114 21:55:11 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
121114 21:55:11 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
121114 21:55:12 InnoDB: Waiting for the background threads to start
121114 21:55:13 InnoDB: 1.1.6 started; log sequence number 77177262
121114 21:55:13 [Note] Event Scheduler: Loaded 0 events
121114 21:55:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
121115 00:19:44 mysqld_safe Number of processes running now: 0
121115 00:19:44 mysqld_safe mysqld restarted
121115 0:19:47 [Note] Plugin 'FEDERATED' is disabled.
121115 0:19:47 InnoDB: The InnoDB memory heap is disabled
121115 0:19:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121115 0:19:47 InnoDB: Compressed tables use zlib 1.2.3
121115 0:19:47 InnoDB: Using Linux native AIO
121115 0:19:47 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
121115 0:19:47 InnoDB: Completed initialization of buffer pool
121115 0:19:47 InnoDB: Fatal error: cannot allocate memory for the buffer pool
121115 0:19:47 [ERROR] Plugin 'InnoDB' init function returned error.
121115 0:19:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121115 0:19:47 [ERROR] Unknown/unsupported storage engine: InnoDB
121115 0:19:47 [ERROR] Aborting
Edit #1
total used free shared buffers cached
Mem: 496 370 126 0 24 110
-/+ buffers/cache: 234 261
Swap: 1023 9 1014
Edit #2
Also, largest table in my mysql is 20MB, so my the memory used should be pretty moderate.
SELECT CONCAT(table_schema, '.', table_name),
CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx,
CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
ROUND(index_length / data_length, 2) idxfrac
FROM information_schema.TABLES
ORDER BY data_length + index_length DESC
LIMIT 10;
from the looks of it your server cannot allocate enough memory for innodb.
Write
free -mto see how much memory you have to allocate. Have a look in your/etc/my.cnfand have a look at theinnodb_buffer_pool_sizemake changes.If you want, you can start mysql without innodb which some people do to lower the memory footprint.
mysqld --skip-innodb --default-storage-engine=myisam