MySQL Forums
Forum List  »  InnoDB

Re: Connection lost
Posted by: Rick James
Date: May 07, 2009 09:42AM

According to
innodb_file_per_table = ON
you have more data files. Search in other directories for *.ibd files.

So, it still feels like you have some huge records that are blowing out
innodb_log_file_size = 199229440
innodb_log_files_in_group = 2
Increase the 'size' setting. But it is tricky:
1. cleanly shut down mysql
2. change my.cnf (my.ini)
3. delete the two iblog files -- (the clean shutdown means there is nothing critical in them)
4. restart mysql -- this will rebuild the log files.

Options: ReplyQuote


Subject
Views
Written By
Posted
4675
May 05, 2009 06:37AM
1999
May 06, 2009 10:12PM
2081
May 07, 2009 01:34AM
Re: Connection lost
2049
May 07, 2009 09:42AM
2048
May 12, 2009 01:25AM
2060
May 12, 2009 01:38PM


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.