Performance problems, maybe because of table locking

Next topic

Author	Message
Ivo Lukac	Tuesday 07 July 2009 3:05:56 am ezidentifier datatype locks tables to ensure uniqeness. It locks ezcontentobject_attribute and ezcontentclass_attribute. Normally it sounds ok, but we have now more than 8 million rows in ezcontentobject_attribute and system with lot of inserting and editing. So I see time to time locked queries in mysql preocess list. First question: Why is ezcontentobject_attribute locked? It seems to me that locking ezcontentclass_attribute would be enough... Could be that ezurlalias_ml locking in store function is also making problem so second questions is: Can I disable ezurlaliases? http://www.linkedin.com/in/ivolukac http://www.netgen.hr/eng/blog http://twitter.com/ilukac
André R.	Wednesday 05 August 2009 6:21:09 am As for second: No, but are you using a older version? I think the locking was removed in favor of auto increment there in version 4.0.2 or something. eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Ivo Lukac	Thursday 06 August 2009 3:38:33 am Yes it is 3.10.1 version. In the mean time I hacked kernel to lock only class attribute table and it works fine. But it is nice to hear that when we upgrade it will work better without the hack :) http://www.linkedin.com/in/ivolukac http://www.netgen.hr/eng/blog http://twitter.com/ilukac
André R.	Thursday 06 August 2009 5:51:47 am Btw, the ezidentifier issue has also been resolved: http://issues.ez.no/IssueView.php?Id=15037&activeItem=1& eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom