Share » Forums » General » Clustering with class edition = big...

Clustering with class edition = big performance problem

Clustering with class edition = big performance problem

Wednesday 07 May 2008 6:20:14 am - 4 replies

Author Message

André R.

Wednesday 07 May 2008 6:29:32 am

How many objects do you have on these classes?
You should not change classes with lots of objects (even if you don't use cluser version).
Look in the contribution area, there are some cli scripts there that will change the class definition for you in a safe manner.

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

Marc-Aurèle Brothier

Wednesday 07 May 2008 6:54:12 am

You will be surprise .... none, 0 ! For the class I tried to edit.

What I've seen on the modification of class with existing content, is that it creates new revision or edit the actual revision with the extra default value for each item. But since i don't have any content... I don't really get it

And to give more info about the problem. After my white page, if I look at the class object (view only) I can't see my new attributs. But if I go and edit the class, the edit page shows me my new attributs. If I create a content, I don't have my new attributs.

In ezcontentobject_name we have more than 24'000 rows and in "ezdbfile" more than 40'000 rows.

I'll look into the scripts, thank for your advice. It can be another work around, but I hope to find another solution for our client's webmasters.

André R.

Wednesday 07 May 2008 1:44:28 pm

Checked up a bit more and when you edit a class(doesn't matter witch one), content cache clear is performed.
So yes, you will benefit from the cluster in 3.10 / 4.0 since one of the changes is that cache isn't removed physically but instead just marked as expired.

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

Carlos Revillo

Wednesday 09 July 2008 4:47:40 pm

my problem here is similar but not the same. i'm using ez40 and ezflow for my homepage. there some images involved in the main site, let's say about 20 images.
when the cache of this front page is cleared and regenerated again, site becomes inservible.

looking at show processlist there are several insert into ezdbfile queries that takes a lot of seconds, event minutes to end.
there are question like

INSERT INTO ezdbfile (datatype, name, name_hash, scope, size, mtime,
expired) VALUES ('image/jpeg',
'var/ezflow_site/storage/images/xxxxx/2102465-2-esl-ES/xxxx.jpg',
'40ad5fee3e4d66b8444f24c2a18b8766', 'image', 11253, 1215644597, 0)
    -> ON DUPLICATE KEY UPDATE datatype=VALUES(datatype),
scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime),
expired=VALUES(expired) |

so, it seems like every time that my homepage is modified all this images need to be added again to the database...

when there are no publishing work, the site works perfectly...

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu