ezsession table size

Next topic

Author	Message
Bruce Morrison	Tuesday 15 July 2003 7:42:10 pm I was moving the data from a live database to the dev server to do some work and noticed that the database size was 75Mb. Further investigation revealed that the ezsession table was the main culprit at 54Mb. The site gets about 30,000 hits per day. The session timeout is the default 3 days. All the entries have expiry times that fit within the 3 days so it looks to be working normally. This site is using version 3.0.2 but has been upgraded from 3.0 RC2. Is it normal for this table to be so large? Does anyone have ezsession tables of a similar size? In a regular site what are the sessions used for? Cheers Bruce designIT My Blog: http://www.stuffandcontent.com/ Follow me on twitter: http://twitter.com/brucemorrison Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish
Bruce Morrison	Tuesday 22 July 2003 12:21:17 am Any one else have large ezsession tables? My Blog: http://www.stuffandcontent.com/ Follow me on twitter: http://twitter.com/brucemorrison Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish
Bård Farstad	Tuesday 22 July 2003 1:25:48 am Bruce, we have some large session tables. This does not cause any problems though, except taking up diskspace. --bård Documentation: http://ez.no/doc
Harry Oosterveen	Monday 19 January 2004 4:50:39 am I'm not sure whether this is related to the size of the table, but I've had it twice in a few months that the ezsession table became corrupted. The fix is easy, if you have another installation from where you can export the table structure (e.g., using phpMyAdmin): drop the corrupted table and create a new one using the exported structure. The problem of a corrupted ezsession table shows when you want to login: with a wrong password, you get the proper error message, but when you log in correctly, you will see the log in screen again, without any error messages.

eZ debug

Timing:	Jan 30 2025 21:47:47
Script start
Timing:	Jan 30 2025 21:47:47
Module start 'layout'
Timing:	Jan 30 2025 21:47:47
Module start 'content'
Timing:	Jan 30 2025 21:47:48
Module end 'content'
Timing:	Jan 30 2025 21:47:48
Script end

Main resources:

Total runtime	1.1204 sec
Peak memory usage	8,192.0000 KB
Database Queries	62

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0050	588.0078	151.1953
Module start 'layout'	0.0050	0.0036	739.2031	220.6719
Module start 'content'	0.0086	1.1110	959.8750	4,501.8438
Module end 'content'	1.1196	0.0008	5,461.7188	11.8750
Script end	1.1204		5,473.5938

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.3177	16	0.0002
Check MTime	0.0013	0.1178	16	0.0001
Mysql Total
Database connection	0.0007	0.0618	1	0.0007
Mysqli_queries	1.0399	92.8154	62	0.0168
Looping result	0.0005	0.0459	60	0.0000
Template Total	1.0685	95.4	2	0.5343
Template load	0.0022	0.1983	2	0.0011
Template processing	1.0663	95.1709	2	0.5332
Template load and register function	0.0009	0.0846	1	0.0009
states
state_id_array	0.0015	0.1358	1	0.0015
state_identifier_array	0.0010	0.0915	2	0.0005
Override
Cache load	0.0019	0.1703	24	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0013	0.1172	3	0.0004
Fetch class attribute name	0.0025	0.2205	7	0.0004
XML
Image XML parsing	0.0026	0.2331	3	0.0009
class_abstraction
Instantiating content class attribute	0.0000	0.0016	8	0.0000
General
dbfile	0.0022	0.1982	28	0.0001
String conversion	0.0000	0.0007	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
4	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	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: 18 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs