Database-cleanup

Next topic

Author	Message
Atle Enersen	Thursday 04 December 2003 3:45:30 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

Thursday 04 December 2003 3:45:30 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 18 2025 16:11:15
Script start
Timing:	Jan 18 2025 16:11:15
Module start 'layout'
Timing:	Jan 18 2025 16:11:15
Module start 'content'
Timing:	Jan 18 2025 16:11:16
Module end 'content'
Timing:	Jan 18 2025 16:11:16
Script end

Main resources:

Total runtime	0.6896 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0075	589.2188	152.6094
Module start 'layout'	0.0075	0.0026	741.8281	39.4063
Module start 'content'	0.0101	0.6767	781.2344	399.8672
Module end 'content'	0.6868	0.0028	1,181.1016	8.1953
Script end	0.6896		1,189.2969

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.4707	16	0.0002
Check MTime	0.0013	0.1913	16	0.0001
Mysql Total
Database connection	0.0013	0.1887	1	0.0013
Mysqli_queries	0.6393	92.6992	46	0.0139
Looping result	0.0005	0.0771	44	0.0000
Template Total	0.6456	93.6	2	0.3228
Template load	0.0025	0.3570	2	0.0012
Template processing	0.6431	93.2552	2	0.3215
Template load and register function	0.0002	0.0231	1	0.0002
states
state_id_array	0.0008	0.1162	1	0.0008
state_identifier_array	0.0013	0.1886	2	0.0007
Override
Cache load	0.0018	0.2568	9	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0931	1	0.0006
Fetch class attribute name	0.0012	0.1676	1	0.0012
XML
Image XML parsing	0.0001	0.0159	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0010	1	0.0000
General
dbfile	0.0006	0.0857	10	0.0001
String conversion	0.0000	0.0013	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs