Optimizing Database

[edgarf76]

My VPS hosting company said my database is very big and it should be optimized. Can anyone point me in the direction on how to optimize a full database?

 

[preditor]

Maiby this can hel u?

Optimizing An SQL Database

Hi does anyone know how to optimize an sql database. Can you point me in the right direction to a tutorial?

www.affiliateguarddog.com

 

[Imre]

It often happens that WP plugins pump the database full of logs that should be purged periodically.
Pending comments, post/page revisions, stored contact form submissions etc can also make your database larger than it should be.
Also if you had plugin in the past that you no longer use, their data might still be in the db even though the plugin itself is no longer on your site. The database can still contain orphan tables etc.

I use 2 plugins to cleanup the bloat:
https://wordpress.org/plugins/wp-sweep/ and https://wordpress.org/plugins/plugins-garbage-collector/ both quite useful.

Before you proceed, make sure you have a full backup.

 

[preditor]

Super Important: BACKUP BEFORE any kind of playing around with databases of any kind! Also, check with your hosting if they have an automatic daily backup or similar.

 

[Frank]

You can do it via cpanel via the server or use a plugin, but like everyone says make a backup as these do have a tendency to fail quite a lot