How to fix very large WordPress database
Solved by optimizing the tables in phpMyAdmin
- First we open our database in phpMyAdmin. On the top level we sort the contained tables by their size and identify the biggest space wasters:
- Identify storage-hungry tables in the WordPress database
Attention: At the next step we can easily click wrong options and thus possibly delete whole tables. As a precaution I recommend to make a backup first.
- Now we mark the largest tables of our WordPress database with a check mark in the selection box and now click on the drop-down menu next to the “Select All” button at the bottom of the screen.
- Here we select the entry “optimized table”.
phpMyAdmin now optimizes the table, or recreates it cleanly, if direct optimization is impossible. In my case the table shrunk from 602 MB to a reasonable 1.5 MB.