MySQL Forums :: InnoDB :: Connection lost

Advanced Search

Connection lost
Posted by: Gharieb Abdel-Mawla ()
Date: May 05, 2009 06:37AM


I have a problem with MySQL
the system was running fine but suddenly the connection lost and the service of MySQL had been stopped.when I opened the error log file I found the following errors:
InnoDB: which exceeds the log group capacity 358609306.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
NOTE: I have only one data file (ibdata1)with size 34,607,104 KB

So,I started the service again and every thing was fine but I don't know.. will this problem happening again??
Or how can I handle this problem to avoid it in the future?
and how can I expand the MySQL data file size or to be more than one file or if the file has exceeded the max size how can I make the MySQL create another one automatically?

Thanks in advance.

Options: ReplyQuote

Subject Views Written By Posted
Connection lost 3384 Gharieb Abdel-Mawla 05/05/2009 06:37AM
Re: Connection lost 1821 Rick James 05/06/2009 10:12PM
Re: Connection lost 1850 Gharieb Abdel-Mawla 05/07/2009 01:34AM
Re: Connection lost 1820 Rick James 05/07/2009 09:42AM
Re: Connection lost 1823 Gharieb Abdel-Mawla 05/12/2009 01:25AM
Re: Connection lost 1763 Rick James 05/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.