Topic: SQL 5.1x to Latest
Hi, I just upgraded to the latest SQL. I am on a CentOS 4.9 VPS with limited memory:
Memory: 90404k/98304k available (4240k kernel code, 7344k reserved, 1330k data, 348k init, 0k highmem)
[root@thecflforum ~]# rpm -qa mysql\*
mysql-5.5.15-1.el4.remi
mysql-server-5.5.15-1.el4.remi
mysqlclient10-3.23.58-9.2.c4
mysqlclient14-4.1.22-1.el4s1.1
mysql-libs-5.5.15-1.el4.remi
I cannot get the SQL server to start after updating from 5.1.x to the latest this morning. Looking at the error log, I think the problem may be the innoDB poolsize.
110816 12:12:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
110816 12:15:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110816 12:15:44 [Note] Plugin 'FEDERATED' is disabled.
110816 12:15:44 InnoDB: The InnoDB memory heap is disabled
110816 12:15:44 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
110816 12:15:44 InnoDB: Compressed tables use zlib 1.2.1.2
110816 12:15:44 InnoDB: Using Linux native AIO
110816 12:15:44 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(136675328 bytes) failed; errno 12
110816 12:15:44 InnoDB: Completed initialization of buffer pool
110816 12:15:44 InnoDB: Fatal error: cannot allocate memory for the buffer pool
110816 12:15:44 [ERROR] Plugin 'InnoDB' init function returned error.
110816 12:15:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110816 12:15:44 [ERROR] Unknown/unsupported storage engine: InnoDB
110816 12:15:44 [ERROR] Aborting
It seems to want 128M, even though I have innodb_buffer_pool_size = 8M in my.cnf
I am not sure if I am barking up the wrong tree here, but no matter what I set the pool size to it seems to go with 128M. Any ideas here, short of going back to 5.1? Thanks!