mysql out of memory & table crash
Posted by: O Ishtiaq
Date: October 27, 2005 11:54PM

Hi there

I have been administrating mysql server on Fedora core 3 and experienced strange type of problem in mysql. One of the DB is 106 MB in size and it has crashed 3-4 times now. Website which uses is quite busy. Repairing a crash table takes 3 hours :(

I have traced the log (mysqld.log) and find out:

051028 03:38:45 mysqld started
051028 3:38:45 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.
051028 3:38:45 InnoDB: Started
051028 3:34:32 read_const: Got error 126 when reading table ./user/table

Can anybody please tell me the solution of the problem?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
mysql out of memory & table crash
October 27, 2005 11:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.