Title: Optimize the table
Last modified: November 5, 2022

---

# Optimize the table

 *  Resolved [kenneth0426](https://wordpress.org/support/users/kenneth0426/)
 * (@kenneth0426)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/optimize-the-table/)
 * When I used the “optimize” function of the Advanced DB Cleaner plugin to optimize
   the indexed table. I found that the number of rows increased. Is it normal? Do
   I need to use your plugin to index or add High Performance keys again after the“
   optimize”? Thanks!

Viewing 1 replies (of 1 total)

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/optimize-the-table/#post-16172990)
 * Yes, this is normal. It’s no cause for alarm. It is a little confusing though.
   Here’s the situation.
 * The Dashboard panel of this plugin shows the number of rows in each table. But
   the numbers it shows are _approximate_, as they come from table metadata. I retrieved
   them that way because it takes a long time to actually COUNT() the rows with 
   SQL. The numbers I show come from some table metadata deep in MySQL.
 * When you OPTIMIZE TABLE, MySQL updates that metadata. So it’s not surprising 
   that the approximate number of rows changed when you used Advanced DB Cleaner
   to run the OPTIMIZE TABLE. The actual number of rows doesn’t change when you 
   optimize the table.

Viewing 1 replies (of 1 total)

The topic ‘Optimize the table’ is closed to new replies.

 * ![](https://ps.w.org/index-wp-mysql-for-speed/assets/icon-128x128.png?rev=2652667)
 * [Index WP MySQL For Speed](https://wordpress.org/plugins/index-wp-mysql-for-speed/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/index-wp-mysql-for-speed/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/)
 * [Active Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/reviews/)

## Tags

 * [question](https://wordpress.org/support/topic-tag/question/)

 * 1 reply
 * 2 participants
 * Last reply from: [OllieJones](https://wordpress.org/support/users/olliejones/)
 * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/optimize-the-table/#post-16172990)
 * Status: resolved