Page 1 of 1

Optimize DB

Posted: Mon Aug 22, 2016 2:43 pm
by happydg
Hello,

When i go to maintenance - Optimize DB and click on it, after a while it goes to 504 Gateway Time-out.

Is it possible to optimize db in ssh instead? How to do it?

Thank you.

Re: Optimize DB

Posted: Thu Aug 25, 2016 9:05 am
by admin
Hi !

Yes, you can do

OPTIMIZE TABLE table_name

in mysql (for all tables in your DB)