-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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... Uwe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSKwZNts3frmum9swAQL7vAf/f7HFx83ZRZttgVDz00uO7T7RWa+KZCN0 qFdi9UXMkA0p/nA7vv8/iXV0D431Abf3wNaGdmIhSICcEOsgxqj3s7EmMZQz+3rN k/GucXcRQ+1LwCphHukKRMeW/k6AwEUUcAROxyIeRSSR5/SLkSOa6OxT1E1C6BsW BLHnaVzuV5GMV3tKNy2j71fIQc+g0PgylTmFiqubC2VNNeLkCyNWW2F22aJuFPO8 /HpKNjKSkOWxyfoscJ9/ezo1yU8C3afXrn/aeBWJx+KKvdQ46bBEB4ht3JBmdNia 5mz8CoMwTIxaUBlUBlueyqtvn05vHVK5OP4Xh5zOzKk+g8ZR1l8tzA== =0rQR -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
