Cleanup database?

Previous topic

Developer

Next topic

Author	Message
Siniša Šehović	Monday 20 November 2006 6:51:43 am Hi I have one small problem!:-) Need to clenup database of leftovers. (old unused records in database) How to do that? I am using ez 3.8.6 and mysql with innodb Best regards, Sinisa --- If at first you don't succeed, look in the trash for the instructions.
Ekkehard Dörre	Wednesday 22 November 2006 5:57:59 am Hi Sinisa, under bin/php/ are a lot of helper scripts which you can access via php cli. flatten.php inline comment: $script =& eZScript::instance( array( 'description' => ( "eZ publish database flattening.\n\n" . "Will remove data that is not considered currently in use to minimize the amount of database data it consumes\n" . "\n" . "Possible values for NAME is:\n" . "contentobject, contentclass, workflow, role or all (for all items)\n" . "flatten.php -s admin contentobject"), 'use-session' => false, 'use-modules' => true, 'use-extensions' => true ) ); Some documentation about the scripts: http://ez.no/doc/ez_publish/upgrading/the_system_upgrade_scripts Greetings, ekke http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

Author

Message

Siniša Šehović

Monday 20 November 2006 6:51:43 am

I have one small problem!:-)

Need to clenup database of leftovers. (old unused records in database)

How to do that?

I am using ez 3.8.6 and mysql with innodb

Best regards,
Sinisa

---
If at first you don't succeed, look in the trash for the instructions.

Ekkehard Dörre

Wednesday 22 November 2006 5:57:59 am

Hi Sinisa,

under bin/php/ are a lot of helper scripts which you can access via php cli.

flatten.php inline comment:


$script =& eZScript::instance( array( 'description' => ( "eZ publish database flattening.\n\n" .
                                                         "Will remove data that is not considered currently in use to minimize the amount of database data it consumes\n" .
                                                         "\n" .
                                                         "Possible values for NAME is:\n" .
                                                         "contentobject, contentclass, workflow, role or all (for all items)\n" .
                                                         "flatten.php -s admin contentobject"),
                                      'use-session' => false,
                                      'use-modules' => true,
                                      'use-extensions' => true ) );

Some documentation about the scripts:

http://ez.no/doc/ez_publish/upgrading/the_system_upgrade_scripts

Greetings, ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

eZ debug

Timing:	Jan 31 2025 01:16:07
Script start
Timing:	Jan 31 2025 01:16:07
Module start 'layout'
Timing:	Jan 31 2025 01:16:07
Module start 'content'
Timing:	Jan 31 2025 01:16:07
Module end 'content'
Timing:	Jan 31 2025 01:16:07
Script end

Main resources:

Total runtime	0.0454 sec
Peak memory usage	8,192.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	588.0156	151.1953
Module start 'layout'	0.0057	0.0040	739.2109	220.6563
Module start 'content'	0.0097	0.0340	959.8672	997.8984
Module end 'content'	0.0437	0.0017	1,957.7656	33.9922
Script end	0.0453		1,991.7578

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	6.6048	14	0.0002
Check MTime	0.0012	2.6162	14	0.0001
Mysql Total
Database connection	0.0008	1.7807	1	0.0008
Mysqli_queries	0.0023	4.9938	3	0.0008
Looping result	0.0000	0.0242	1	0.0000
Template Total	0.0013	2.8	1	0.0013
Template load	0.0010	2.2394	1	0.0010
Template processing	0.0002	0.5270	1	0.0002
Override
Cache load	0.0007	1.6283	1	0.0007
General
dbfile	0.0143	31.5612	8	0.0018
String conversion	0.0000	0.0147	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