Optimize the table

  • Resolved kenneth0426

    (@kenneth0426)


    2 years ago

    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

    (@olliejones)

    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.

Tags