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. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
