Database Optimization

The Database tab provides a complete view of your WordPress database tables.

Table Information

Each table displays:

• Name — table name with prefix
• Engine — storage engine (InnoDB, MyISAM)
• Auto increment — current auto-increment value
• Collation — character set and collation
• Gain — reclaimable overhead space (in KB)

Actions

Optimize Table

Reclaims unused space and defragments data. Click the optimize icon on individual tables, or select multiple tables and use Bulk Actions → Optimize Table.

Reset Auto Increment

Resets the auto-increment counter to the next available value after the highest existing ID. Useful after bulk deletions to keep IDs compact.

Database Size

The total database size is shown in the table footer.