Howdy all, Quick question about Analyze table. I just deleted 3+ million records from a table that gets a lot of insert activity throughout the day. It seems like now would be a good time to run optimize table and/or analyze table. I saw in the docs that analyze table puts a read lock on the table. This will prevent inserts/updates/deletes while the table is being analyzed, correct? For a table with 5 million records (the table has 5 int fields, 1 decimal, 1 timestamp) I would assume that this might take a while. I don't want to tie this table up for a long period of time during the day/evening. Just wanted to see if, in anyone's experience, this is generally a fast or slow thing.
Cheers, Tripp __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
