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 31 2025 01:29:25
Script start
Timing:	Jan 31 2025 01:29:25
Module start 'layout'
Timing:	Jan 31 2025 01:29:25
Module start 'content'
Timing:	Jan 31 2025 01:29:25
Module end 'content'
Timing:	Jan 31 2025 01:29:25
Script end

Main resources:

Total runtime	0.0245 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0048	588.1250	151.2109
Module start 'layout'	0.0048	0.0033	739.3359	220.6875
Module start 'content'	0.0081	0.0144	960.0234	993.6797
Module end 'content'	0.0225	0.0019	1,953.7031	29.9922
Script end	0.0244		1,983.6953

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	11.1279	14	0.0002
Check MTime	0.0011	4.6011	14	0.0001
Mysql Total
Database connection	0.0008	3.2546	1	0.0008
Mysqli_queries	0.0022	8.9753	3	0.0007
Looping result	0.0000	0.0360	1	0.0000
Template Total	0.0013	5.3	1	0.0013
Template load	0.0010	4.1075	1	0.0010
Template processing	0.0003	1.1186	1	0.0003
Override
Cache load	0.0007	2.6627	1	0.0007
General
dbfile	0.0002	0.8723	8	0.0000
String conversion	0.0000	0.0156	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