Mysql sleeping threads

Previous topic

Install & configuration

Next topic

Author	Message
laurent le cadet	Monday 10 July 2006 5:32:42 am Hi, I have some problems with mysql sleeping threads on some old eZp sites (3.2-1). Actually, I have no time to upgrade and it cause regulary mysql overload. Is there a patch or someone can give me a hint to avoid that ? Thanks. Laurent.

Author

Message

laurent le cadet

Monday 10 July 2006 5:32:42 am

Hi,

I have some problems with mysql sleeping threads on some old eZp sites (3.2-1).
Actually, I have no time to upgrade and it cause regulary mysql overload.

Is there a patch or someone can give me a hint to avoid that ?

Thanks.

Laurent.

eZ debug

Timing:	Jan 31 2025 05:31:48
Script start
Timing:	Jan 31 2025 05:31:48
Module start 'layout'
Timing:	Jan 31 2025 05:31:48
Module start 'content'
Timing:	Jan 31 2025 05:31:48
Module end 'content'
Timing:	Jan 31 2025 05:31:48
Script end

Main resources:

Total runtime	0.0174 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.0075	588.1328	151.2109
Module start 'layout'	0.0075	0.0030	739.3438	36.6641
Module start 'content'	0.0104	0.0054	776.0078	86.1563
Module end 'content'	0.0158	0.0016	862.1641	29.9922
Script end	0.0174		892.1563

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	14.5799	14	0.0002
Check MTime	0.0011	6.3327	14	0.0001
Mysql Total
Database connection	0.0011	6.2124	1	0.0011
Mysqli_queries	0.0038	21.9205	3	0.0013
Looping result	0.0000	0.0916	1	0.0000
Template Total	0.0012	7.0	1	0.0012
Template load	0.0010	5.4890	1	0.0010
Template processing	0.0002	1.4222	1	0.0002
Override
Cache load	0.0007	3.8139	1	0.0007
General
dbfile	0.0011	6.2685	8	0.0001
String conversion	0.0000	0.0547	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