-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Paul J Stevens schrieb: > Uwe Kiewel wrote: >> Paul J Stevens schrieb: >>> Peter Rabbitson wrote: >>>> Uwe Kiewel wrote: >>>>> My conclusion for this topic after our short discussion is to let >>>>> dbmail-util maintain the content and >>>>> to maintain the db itself by a dba. >>>> Cool :) >>> Agreed. In the past 'OPTIMIZE' *was* used. It was replaced with 'ANALYZE' >>> exactly because of table locking issues and related downtime. >> But: >> ANALYZE TABLE analyzes and stores the key distribution for a table. >> During the analysis, for InnoDB the table is locked with a write lock. >> >> No benefit in my point of view to exchange OPTIMIZE with ANALYZE... > > OPTIMIZE can run a very long time, where ANALYZE is generally very fast. >
So, with ANALYZE, we have a table write lock, but the lock time is much shorter than with OPTIMIZE, isn't it? Is there a way to estimate the running time of OPTIMIZE? Uwe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSKwfE9s3frmum9swAQKaEAf9FLx2CNlpuj0PFyoUN90akcV3bzyuiBFg jORQYWRth+emZUvFVrvves6HZWaxUdzvjaASXfdNJo5y866zWxyARW3CmNTK1Iui 6QIx1YATJITa6XFPqkD+aZXOUBl8r1wdAz5oJ3MaCeyjwQVSK8JLgQNxazATvAQN IkbCD1SvCROiq8eD+TmR14hcamdbqV2VM2nC1UQiPQqR4Zv1qoBeD07i97WBUasC 81oqqE8bcNPoqcoEaScMZxGQ4FtFMAVMvJUnZQ6QX/ELdSsBB7vha6ngVkkqVEtt K9HbHggJabANVtyYMcY0qce0B1Aa0z9qmTeAg1rtcI1vfSqPvK2h5Q== =h61W -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
