Forums / Install & configuration / Databasecleanup

Databasecleanup

Next topic

Author	Message
Atle Enersen	Saturday 06 December 2003 12:31:41 am I suspect my database are growing quite huge, of corse due to much content, but also because it has not been cleaned since v3 came out. This sometimes makes the whole system freeze with at load up to 9000% (yes, 9000%). I was about to try the databasecleanup provided via the "Contributions", but that link does not work, the server does not respond. Any1 who has that file (cldb.zip) for v3.2-3 (3.2-2)? If please mail it to atle@klanen.no. ...or if there exist som other tools to clean the DB (mySQL)... Rgds, Atle

Author

Message

Saturday 06 December 2003 12:31:41 am

I suspect my database are growing quite huge, of corse due to much content, but also because it has not been cleaned since v3 came out. This sometimes makes the whole system freeze with at load up to 9000% (yes, 9000%).

I was about to try the databasecleanup provided via the "Contributions", but that link does not work, the server does not respond.

Any1 who has that file (cldb.zip) for v3.2-3 (3.2-2)? If please mail it to atle@klanen.no.

...or if there exist som other tools to clean the DB (mySQL)...

Rgds,
Atle

eZ debug

Timing:

Jan 30 2025 22:26:35

Script start

Timing:

Jan 30 2025 22:26:35

Module start 'content'

Timing:

Jan 30 2025 22:26:35

Module end 'content'

Timing:

Jan 30 2025 22:26:35

Script end

Main resources:

Total runtime

0.3435 sec

Peak memory usage

8,192.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0075	587.9219	370.3047
Module start 'content'	0.0075	0.0147	958.2266	997.4063
Module end 'content'	0.0222	0.3212	1,955.6328	3,886.1406
Script end	0.3434		5,841.7734

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0075

587.9219

370.3047

Module start 'content'

0.0075

0.0147

958.2266

997.4063

Module end 'content'

0.0222

0.3212

1,955.6328

3,886.1406

Script end

0.3434

5,841.7734

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0045	1.2964	20	0.0002
Check MTime	0.0014	0.3961	20	0.0001
Mysql Total
Database connection	0.0010	0.2988	1	0.0010
Mysqli_queries	0.2354	68.5388	141	0.0017
Looping result	0.0016	0.4597	139	0.0000
Template Total	0.3208	93.4	1	0.3208
Template load	0.0007	0.2160	1	0.0007
Template processing	0.3201	93.1882	1	0.3201
Override
Cache load	0.0005	0.1526	1	0.0005
Sytem overhead
Fetch class attribute can translate value	0.0021	0.5980	1	0.0021
XML
Image XML parsing	0.0003	0.0894	1	0.0003
General
dbfile	0.0107	3.1277	20	0.0005
String conversion	0.0000	0.0015	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.0045

1.2964

0.0002

Check MTime

0.0014

0.3961

0.0001

Mysql Total

Database connection

0.0010

0.2988

0.0010

Mysqli_queries

0.2354

68.5388

141

0.0017

Looping result

0.0016

0.4597

139

0.0000

Template Total

0.3208

93.4

0.3208

Template load

0.0007

0.2160

0.0007

Template processing

0.3201

93.1882

0.3201

Override

Cache load

0.0005

0.1526

0.0005

Sytem overhead

Fetch class attribute can translate value

0.0021

0.5980

0.0021

XML

Image XML parsing

0.0003

0.0894

0.0003

General

dbfile

0.0107

3.1277

0.0005

String conversion

0.0000

0.0015

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