Slow Database Queries

  • Resolved meetatthebarre

    (@meetatthebarre)


    11 years ago

    Hello, the admin side of my site has been running slow so I installed your plugin to help. The only thing that was running slow, was wp_load_alloptions()

    SELECT option_name, option_value
    FROM wp_4ncwr0m4x8_options
    WHERE autoload = ‘yes’

    I am very new to this. Could you explain to me how I can fix this or what it is trying to tell me? Thank you in advance.

    My site is running just fine
    http://meetat-thebarre.com

    https://wordpress.org/plugins/query-monitor/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author John Blackbourn

    (@johnbillion)

    WordPress Core Developer

    11 years ago

    This potentially means that your options table (wp_4ncwr0m4x8_options) has gotten populated with so many options that it’s causing a slowdown.

    There’s no single answer to fixing this. It can be caused by plugins which leave lots of data in that table after you’ve uninstalled them, or it could be caused by a plugin which is storing massive amounts of data in transients, which are also stored in the options table by default.

    One thing you could try is running the “Repair and Optimize Database” function in WordPress. Instructions can be found here.

    Another thing you can try is installing and running the P3 Profiler plugin, which can point out plugins which are causing your site to slow down, although off the top of my head I’m not sure if it has a function for testing the admin area.

    Thread Starter meetatthebarre

    (@meetatthebarre)

    11 years ago

    I appreciate it. I tried deactivating my plugins and it doesn’t seem to be helping.

    uday.dahale

    (@udaydahale-1)

    10 years, 5 months ago

    I want optimzie below query…

    SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’

    Please help me….

    regards,
    UD

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

The topic ‘Slow Database Queries’ is closed to new replies.