M
muffinresearch
Guest
I'm seeing the following in the mysqld logs and just recently the server has hung twice.
060320 16:42:32 mysqld started
060320 16:42:33 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
060320 16:42:33 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 89774760
InnoDB: Doing recovery: scanned up to log sequence number 0 89774760
060320 16:42:33 InnoDB: Flushing modified pages from the buffer pool...
060320 16:42:33 InnoDB: Started
/usr/libexec/mysqld: ready for connections
This looks like a likely culprit and as Plesk is the only thing that uses InnoDB I reckon I need to increase the memory allocation up from 8MB. My system has 256MB so I was thinking of upping it to 16MB to start. Does this sound like a good plan or is there anything else that could be causing the hangs. Also presumably it is /etc/my.cnf I should change?
060320 16:42:32 mysqld started
060320 16:42:33 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
060320 16:42:33 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 89774760
InnoDB: Doing recovery: scanned up to log sequence number 0 89774760
060320 16:42:33 InnoDB: Flushing modified pages from the buffer pool...
060320 16:42:33 InnoDB: Started
/usr/libexec/mysqld: ready for connections
This looks like a likely culprit and as Plesk is the only thing that uses InnoDB I reckon I need to increase the memory allocation up from 8MB. My system has 256MB so I was thinking of upping it to 16MB to start. Does this sound like a good plan or is there anything else that could be causing the hangs. Also presumably it is /etc/my.cnf I should change?