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

eZ debug

Timing:	Jan 19 2025 00:30:34
Script start
Timing:	Jan 19 2025 00:30:34
Module start 'layout'
Timing:	Jan 19 2025 00:30:34
Module start 'content'
Timing:	Jan 19 2025 00:30:34
Module end 'content'
Timing:	Jan 19 2025 00:30:34
Script end

Main resources:

Total runtime	0.0164 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0062	588.1641	152.6563
Module start 'layout'	0.0062	0.0028	740.8203	39.5078
Module start 'content'	0.0090	0.0054	780.3281	89.5234
Module end 'content'	0.0144	0.0019	869.8516	30.3047
Script end	0.0163		900.1563

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	16.2597	14	0.0002
Check MTime	0.0012	7.5383	14	0.0001
Mysql Total
Database connection	0.0009	5.2128	1	0.0009
Mysqli_queries	0.0030	18.3611	3	0.0010
Looping result	0.0000	0.0859	1	0.0000
Template Total	0.0016	9.8	1	0.0016
Template load	0.0009	5.2069	1	0.0009
Template processing	0.0007	4.5171	1	0.0007
Override
Cache load	0.0006	3.5407	1	0.0006
General
dbfile	0.0003	1.9093	8	0.0000
String conversion	0.0000	0.0582	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs