database transactions

Next topic

Author	Message
Brendan Pike	Tuesday 22 March 2005 10:54:17 pm In a development site I enabled InnoDB using the ezconvertmysqltabletype.php script. Interestingly it converted many non-eZ publish tables I was using inside the database also. For some reason a few eZ publish tables were not converted and continue to use MyISAM these are, ezcontentobject_tree, ezimagefile, eztrigger and ezurlalias. Is this intentional? www.dbinformatics.com.au We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.
Frederik Holljen	Wednesday 23 March 2005 12:28:48 am Hi, I've notified the developer who made the script about this message (I unfortunately don't know the answer to your problem). He's left for eastern holidays however, so he won't be able to answer you until next week. Frederik
Brendan Pike	Wednesday 23 March 2005 5:38:53 am Thanks for the heads up Frederik I'll sit tight for now, I also found that trying to move a user to a new user group while editing the user results in a fatal error with a transaction related message. Although moving the user's location from outside the user works fine. Feels like a half implemented thing so I wont submit a bug report yet. www.dbinformatics.com.au We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.
Raymond Bosman	Wednesday 30 March 2005 1:45:07 am Hi Brendan, Thanks for your notification. It was indeed not the intension to convert the non-eZ publish tables, which is fixed in the trunk. However it is not intentional to leave the tables: ezcontentobject_tree, ezimagefile, eztrigger, and ezurlalias unconverted. I discovered that MySQL crashes sometimes while converting a large table. Can you check your mysqld error log, to see whether this is the reason why some tables are skipped? You also found a bug while moving a user to a new user group. Probably the reason why this fatal error pops up is due to an invalid query. Without transactions the error would have been ignored. So can you report this bug, please? Thanks for your contribution, Raymond.

eZ debug

Timing:	Jan 18 2025 22:18:29
Script start
Timing:	Jan 18 2025 22:18:29
Module start 'layout'
Timing:	Jan 18 2025 22:18:29
Module start 'content'
Timing:	Jan 18 2025 22:18:29
Module end 'content'
Timing:	Jan 18 2025 22:18:29
Script end

Main resources:

Total runtime	0.7459 sec
Peak memory usage	4,096.0000 KB
Database Queries	62

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	587.8906	152.6094
Module start 'layout'	0.0056	0.0030	740.5000	39.4141
Module start 'content'	0.0086	0.7356	779.9141	575.5859
Module end 'content'	0.7442	0.0017	1,355.5000	12.1875
Script end	0.7459		1,367.6875

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4186	16	0.0002
Check MTime	0.0012	0.1647	16	0.0001
Mysql Total
Database connection	0.0011	0.1437	1	0.0011
Mysqli_queries	0.6925	92.8429	62	0.0112
Looping result	0.0008	0.1085	60	0.0000
Template Total	0.7110	95.3	2	0.3555
Template load	0.0023	0.3093	2	0.0012
Template processing	0.7087	95.0123	2	0.3544
Template load and register function	0.0003	0.0342	1	0.0003
states
state_id_array	0.0012	0.1645	1	0.0012
state_identifier_array	0.0017	0.2278	2	0.0008
Override
Cache load	0.0019	0.2534	19	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.1231	3	0.0003
Fetch class attribute name	0.0014	0.1855	5	0.0003
XML
Image XML parsing	0.0008	0.1085	3	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0016	5	0.0000
General
dbfile	0.0008	0.1034	16	0.0000
String conversion	0.0000	0.0012	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/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
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.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: 15 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs