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 tmp.JPG‎ (6.6 KB) __DEFINE_LIKE_SHARE__