Forums / Install & configuration / Mysql sleeping threads

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 20 2025 05:55:11

Script start

Timing:

Jan 20 2025 05:55:11

Module start 'content'

Timing:

Jan 20 2025 05:55:11

Module end 'content'

Timing:

Jan 20 2025 05:55:11

Script end

Main resources:

Total runtime

0.1363 sec

Peak memory usage

2,048.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	590.1016	180.8359
Module start 'content'	0.0058	0.0073	770.9375	89.8828
Module end 'content'	0.0131	0.1231	860.8203	518.0313
Script end	0.1362		1,378.8516

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0058

590.1016

180.8359

Module start 'content'

0.0058

0.0073

770.9375

89.8828

Module end 'content'

0.0131

0.1231

860.8203

518.0313

Script end

0.1362

1,378.8516

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	2.7041	20	0.0002
Check MTime	0.0014	1.0528	20	0.0001
Mysql Total
Database connection	0.0008	0.5973	1	0.0008
Mysqli_queries	0.0875	64.2383	141	0.0006
Looping result	0.0011	0.8383	139	0.0000
Template Total	0.1227	90.0	1	0.1227
Template load	0.0009	0.6626	1	0.0009
Template processing	0.1217	89.3429	1	0.1217
Override
Cache load	0.0006	0.4462	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0007	0.5429	1	0.0007
XML
Image XML parsing	0.0002	0.1645	1	0.0002
General
dbfile	0.0093	6.8606	20	0.0005
String conversion	0.0000	0.0044	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0037

2.7041

0.0002

Check MTime

0.0014

1.0528

0.0001

Mysql Total

Database connection

0.0008

0.5973

0.0008

Mysqli_queries

0.0875

64.2383

141

0.0006

Looping result

0.0011

0.8383

139

0.0000

Template Total

0.1227

90.0

0.1227

Template load

0.0009

0.6626

0.0009

Template processing

0.1217

89.3429

0.1217

Override

Cache load

0.0006

0.4462

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0007

0.5429

0.0007

XML

Image XML parsing

0.0002

0.1645

0.0002

General

dbfile

0.0093

6.8606

0.0005

String conversion

0.0000

0.0044

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

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

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs