Re: optimize table on live database

2005-11-03 Thread Paul DuBois
phiLLip Paul DuBois <[EMAIL PROTECTED]> 11/03/2005 12:11 AM To [EMAIL PROTECTED], mysql@lists.mysql.com cc Subject Re: optimize table on live database At 14:08 -0500 11/2/05, [EMAIL PROTECTED] wrote: Hello, I've been looking for information related to best practice on how t

Re: optimize table on live database

2005-11-03 Thread phillip
e? I don't remember the particular tablesize at that time, but it could easily get to be around 1 gig or more. Any suggestions? Your friendly neighborhood SA, phiLLip Paul DuBois <[EMAIL PROTECTED]> 11/03/2005 12:11 AM To [EMAIL PROTECTED], mysql@lists.mysql.com cc Subject Re: o

Re: optimize table on live database

2005-11-02 Thread Paul DuBois
At 14:08 -0500 11/2/05, [EMAIL PROTECTED] wrote: Hello, I've been looking for information related to best practice on how to OPTIMIZE TABLE with out taking the database offline. I understand that it is not good to run an optimize while the database is being used. So what is a good way of handli