• Registered: 2011-08-16
  • Posts: 1

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!

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,839

Re: SQL 5.1x to Latest

I can't reproduce

# grep pool /etc/my.cnf
innodb_buffer_pool_size=8M 

# grep pool /var/log/mysqld.log
110816 19:06:53 InnoDB: Initializing buffer pool, size = 8.0M
110816 19:06:53 InnoDB: Completed initialization of buffer pool

Is the innodb_buffer_pool_size in the [mysqld] section of the my.cnf ?

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-08-16
  • Posts: 1

Re: SQL 5.1x to Latest

Hmmm.it was in that section and my grep got a return of 8M, like yours and like it should.  However, your response got me thinking more along the lines of I am doing something wrong. 

I went back to the default my.cnf.rpmnew (or whatever it was) and remembered to bind the ip this time.  I think I forgot to do that when I switched over from my tweaked my.cnf to the default one this morning.  There must be something in my tweaked my.cnf that the 5.5x doesn't like.  I'll play around and figure out which line is causing me my troubles!

Sorry for wasting your time.  I usually can find my answer by searching, but wasn't able to this time and was afraid it was something with my old CentOS or something roll!