Forums / Install & configuration / Lost connection to MySQL server during query

Lost connection to MySQL server during query

Previous topic

Install & configuration

Next topic

Author	Message
laurent le cadet	Monday 28 July 2008 7:23:48 am Hi, I have a site which tooks a very very long time to rebuild caches after clearing cache-block and template cache. I have this error message (error.log) : [ Jul 28 2008 16:07:43 ] [86.67.69.64] eZMySQLDB: Connection error: Couldn't connect to database. Please try again later or inform the system administrator. Lost connection to MySQL server during query There is about 500 users connected at the same time. Is there a relation (?) between users request and cache rebuilt ? Any hints ? Best regards. laurent Ps : on the pre-prod site there is no crash
Stéphane Couzinier	Monday 11 August 2008 2:07:30 pm 1) use eztc.php to rebuild your template compile. 2) don't remove all your cb and cache content at the same time. 3) reduce the number of SQL query generate by your tpl. on a small dev mysql server sometime we have this error if there is a lot of query in the page or a lot of user at the same time http://www.kouz-cooking.fr

Author

Message

laurent le cadet

Monday 28 July 2008 7:23:48 am

Hi,

I have a site which tooks a very very long time to rebuild caches after clearing cache-block and template cache.

I have this error message (error.log) :

[ Jul 28 2008 16:07:43 ] [86.67.69.64] eZMySQLDB:
Connection error: Couldn't connect to database. Please try again later or inform the system administrator.
Lost connection to MySQL server during query

There is about 500 users connected at the same time.
Is there a relation (?) between users request and cache rebuilt ?

Any hints ?

Best regards.

laurent

Ps : on the pre-prod site there is no crash

Stéphane Couzinier

Monday 11 August 2008 2:07:30 pm

1) use eztc.php to rebuild your template compile.
2) don't remove all your cb and cache content at the same time.
3) reduce the number of SQL query generate by your tpl.
on a small dev mysql server sometime we have this error if there is a lot of query in the page or a lot of user at the same time

http://www.kouz-cooking.fr