Overhead filled in wp_optimize but not in Database

  • Resolved heveraert

    (@heveraert)


    3 years, 1 month ago

    Dear Helper,

    1) For some of my websites, I notice that the overhead in wp_optimize Tables is filled while in de phpAdmin it is 0. Is this normal?

    2) For some of my websites the Overhead increases very fast. What can be the cause?

    After I run wp_optimize, everything is fine
    … for a little while.

    Thanks,
    Hilde

Viewing 3 replies - 1 through 3 (of 3 total)

  • @heveraert

    1) For some of my websites, I notice that the overhead in wp_optimize Tables is filled while in de phpAdmin it is 0. Is this normal?
    > This is not normal, WP-Optimize must have detected the The number of allocated but unused bytes for the table.

    2) For some of my websites the Overhead increases very fast. What can be the cause?
    > Retrieving all columns can one of the cause as covering indexes, as well as adding I/O, memory, and overhead.

    Thread Starter heveraert

    (@heveraert)

    @bornforphp

    Thank you for the answers but how do I solve these issues?
    1) What can be the reason & how to solve this?
    2) How can I find out what the reason is?

    @heveraert

    1. Could you please try to re-optimize the tables and check if you see the overhead is now showing to 0
    2. As I said if SELECT queries are retrieving all the columns can be one of the cause for the overhead.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Overhead filled in wp_optimize but not in Database’ is closed to new replies.

Tags