MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Types and Reasons of Crash that cause auto-restart for mysql server and Starting crash recovery
Posted by: mahmood tuweiq
Date: January 05, 2009 04:19AM

i note that
i have huge numbers of databases that have about 60 innodb tables for each
so the metadata of these databases need more memory to hold all information for that huge number of tables , see this valuse
innodb_additional_mem_pool_size = 128M
this size is not enough to fit all innodb tables and when it become full the new query that need metadata not in this memory the innodb crash and stop mysql automatically and run recover crsh process

so i increase this value to become
innodb_additional_mem_pool_size = 1024M
note : that same of datadictionary in oracle

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Types and Reasons of Crash that cause auto-restart for mysql server and Starting crash recovery
3419
mahmood tuweiq
December 01, 2008 05:44AM
Re: Types and Reasons of Crash that cause auto-restart for mysql server and Starting crash recovery
1736
mahmood tuweiq
December 02, 2008 01:33AM
Re: Types and Reasons of Crash that cause auto-restart for mysql server and Starting crash recovery
2393
mahmood tuweiq
January 05, 2009 04:19AM


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.