One for the RelStorage issue tracker.

I've migrated a ~70Mb Data.fs to a Mysql backed RelStorage. Everything seems to work fine.

Packing can be slow, though. With GC turned off, packing took a minute or two. With GC turned on, it took many hours to complete.

While running the pack, the expensive query is this one according to "show processlist":

 UPDATE pack_object SET keep = TRUE WHERE keep = FALSE AND
 zoid IN ( SELECT DISTINCT to_zoid FROM object_ref JOIN temp_pack_visit
 USING (zoid) )

show processlist says: "Copying to tmp table"

This might indicate that the Mysql subselect implementation is slow in this case. And this ticket seem to confirm that:

http://bugs.mysql.com/bug.php?id=28257

I don't have a workaround, but will try to dig deeper.

Observed with RelStorage 1.1b1, Mysql 5.0.51a and 5.0.32


/Anton

_______________________________________________
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev

Reply via email to