Optimize DB

Post Reply
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Optimize DB

Post 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.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Optimize DB

Post by admin »

Hi !

Yes, you can do

OPTIMIZE TABLE table_name

in mysql (for all tables in your DB)
Don't forget to run script update
Post Reply