mysql question
 

hi

whenever I repair or optimiz one of my tables, it waits hours and nothing happens.I have a big forum site with huge database. I'll give you a screenshot of mysql process.

status> copy to tmp table.
time still increasing.

then I never optimize or repair my tables. This is not about post table. user table also like this. for example, if I want to install a add-on, and if thisadd-on creates a new column on user table or post table, it never finishes. just copy to table status.

then what should I do?

Attached Images http://www.vbulletin.com/forum/images/attach/jpg.gif tmp.JPG‎ (6.6 KB)