Forums / Developer / Performance problems, maybe because of table locking
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
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 :)
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&