Re: [ZODB-Dev] Relstorage: Slow packing with Mysql when GC is turned on

2008-05-26 Thread Shane Hathaway
Anton Stonor wrote: 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

[ZODB-Dev] Relstorage: Slow packing with Mysql when GC is turned on

2008-05-25 Thread Anton Stonor
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 expe