PDA

View Full Version : table optimize timeout


axix20xx
02-06-2013, 12:48 PM
Hi.
when i use vbulletin repair & optimize, and select all table to optimize, it not working and freezee (image attached) but when only select repair table it working fine. and when select some table vbulletin can optimize & repair this some table

i try this action from phpmyadmin but can not optime and recieve error.
and try from directadmin and recieve time error too

Lynne
02-06-2013, 05:39 PM
Don't repair/optimize all the tables at the same time - do them in batches. But besides that, you should only do this if you are having database problems with a particular table and then you should only repair/optimize that table.

axix20xx
02-07-2013, 07:41 AM
Thanks Lynne for your answer,
now i found new problem, when i want optimize only searchcore table i get this error.
some another table have same problem.
when i select all table and deselect problematic table, i can optimize & repair well.
do you have any idea for this issue?

Lynne
02-07-2013, 05:21 PM
If you are getting a timeout error, then that is a server issue and you should talk to your host about it.