This means that WordPress database is the place posts, pages, users, comments and more, everything is stored in it.
For more information about WordPress database you can have look at this WPBeginner entry, and for depth look at the default tables and their relations you can check out the in the codex..
From all the above we can figure out that the database is important for the well-being of our site, any corruption can result to irreversible loss of data and accumulation of clutter might make queries, and by extension our site, slower.
To help us with these tasks we will be using WP-DBManager plugin which is available for in WordPress plugin repository...
The Backup sub-menu page is straight forward, the plugin checks if everything is OK order to proceed with the backup process and notifies you if any errors occur.
Here you can select to compress your backup using GZIP, you can do that then click the button to proceed with the backup.
To proceed scroll down and click the Optimize button, this process reorganizes the storage of data and associated index data, to reduce storage space and improve I O efficiency when accessing the table.
Should you need to repair any particular tables on your database you can navigate to the Repair DB sub-menu page, select the tables you need to repair and click the Repair button at the bottom of the page.
if you publish post week and do not have many comments submitted, you might be okay with backup schedule.
Next you can set the frequency of the optimization, similarly to the backup, active site with multiple posts and active comments sections might need optimization, rarely updated site would be just fine with bi-monthly or even optimization schedule.
Read more
Related items:
