Slow Database Queries

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

    (@johnbillion)

    WordPress Core Developer

    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)

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

    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.