Tables tab

Overview

The Tables tab gives you a full overview of your WordPress database tables. From here you can optimize, repair, convert, or delete tables that are no longer needed.

Database cleaner 100 doc02

How to Optimize a Table

  • Open DB Cleaner from the WordPress sidebar and click Tables.
  • Use the checkboxes to select one or more tables.
  • Press the Optimize button. WordPress will reclaim unused space and defragment the selected tables.

How to Repair a Table

  • Check the table you need to repair.
  • Press Repair. MySQL will attempt to fix any corruption in the table structure.

How to Convert a Table to InnoDB

  • Find and check the table you want to convert.
  • Press the Convert to InnoDB button. InnoDB offers better performance, crash recovery, and foreign key support compared to MyISAM.

How to Delete a Table

  • The plugin highlights tables that are no longer associated with any active plugin or theme.
  • Check the table and press Delete. Confirm the action when prompted.

Important tips

  • Optimization is safe to run at any time and does not delete any data.
  • Repairing a table should only be necessary if WordPress reports an error or a plugin is not functioning correctly.