How to estimate filesystem size used by a subtree ?

«

Previous topic

|

|

Next topic

»

Author	Message
H-Works Agency	Saturday 16 July 2011 6:05:56 am Hey, I have a rather unusual question about mysql and ezpublish : I need to be able to tell how much space on the filesystem a certain subtree is using. I know how to do that with /var but how to estimate database amount of data for a certain subtree ? Thanx in advance for any help. Cheers ! EZP is Great
Ivo Lukac	Sunday 17 July 2011 6:52:51 am How about: get the table size and number of rows in ezcontentobject_attribute table calculate the average row size from the data above get number of objects for each class in the subtree calculate number of attributes with the data from previous line finally, multiply average attribute row size with number of attributes A very rough estimate, but could do the trick. http://www.linkedin.com/in/ivolukac http://www.netgen.hr/eng/blog http://twitter.com/ilukac
H-Works Agency	Sunday 17 July 2011 9:11:14 am Thats sounds like a good procedure, thank you for that Ivo. I'll explore that way - maybe thru a shell script - and will post the results back here ! EZP is Great
Romeo Antony	Sunday 17 July 2011 3:56:18 pm Very usefull post. Thanks Ivo .

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 29 2025 23:52:12
Script start
Timing:	Jan 29 2025 23:52:12
Module start 'layout'
Timing:	Jan 29 2025 23:52:12
Module start 'content'
Timing:	Jan 29 2025 23:52:12
Module end 'content'
Timing:	Jan 29 2025 23:52:12
Script end

Main resources:

Total runtime	0.0134 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0044	588.2656	151.2266
Module start 'layout'	0.0044	0.0018	739.4922	36.7031
Module start 'content'	0.0063	0.0058	776.1953	94.2969
Module end 'content'	0.0120	0.0013	870.4922	33.9766
Script end	0.0134		904.4688

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	16.2053	14	0.0002
Check MTime	0.0010	7.1647	14	0.0001
Mysql Total
Database connection	0.0006	4.6334	1	0.0006
Mysqli_queries	0.0017	12.4715	3	0.0006
Looping result	0.0000	0.0677	1	0.0000
Template Total	0.0010	7.5	1	0.0010
Template load	0.0008	5.7824	1	0.0008
Template processing	0.0002	1.6888	1	0.0002
Override
Cache load	0.0005	4.0046	1	0.0005
General
dbfile	0.0016	12.1384	8	0.0002
String conversion	0.0000	0.0463	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