Re: optimize table on live database

2005-11-03 Thread phillip
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: optimize table on live

Re: optimize table on live database

2005-11-03 Thread Paul DuBois
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 to OPTIMIZE TABLE table name

optimize table on live database

2005-11-02 Thread phillip
Hello, I've been looking for information related to best practice on how to OPTIMIZE TABLE table name 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 handling this? In my particular

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 table name 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