MySQL Forums
Forum List  »  InnoDB

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

Hi,

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
3519
May 05, 2009 06:37AM
1835
May 06, 2009 10:12PM
1863
May 07, 2009 01:34AM
1838
May 07, 2009 09:42AM
1835
May 12, 2009 01:25AM
1782
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.