• Resolved Mrs. Johnson

    (@tmstclaire)


    Hi! I do not know what I’m looking at or how to use this but I’ve got to learn this stuff to fix my slow website.

    Is everything listed in red bad? For instance on almost every page I click on I see this at the bottom: query_cache_size 0 (Help)

    I’ve been doing some research and I’m not sure if this should be zero or not so should it? Why is it red?

    Also on almost every page I have this in red: 10 wcpgsk_load_wcsession_helper()
    Error: Function wcpgsk_load_wcsession_helper() does not exist

    This is something to do with Poor Mans Swiss knife plugin but I don’t know how to get rid of it or if it is even an issue.

    Lastly, at the very bottom left I see this:
    WordPress
    version 4.2.2
    WP_DEBUG false
    WP_DEBUG_DISPLAY true
    WP_DEBUG_LOG false
    SCRIPT_DEBUG false
    WP_CACHE true
    CONCATENATE_SCRIPTS undefined
    COMPRESS_SCRIPTS undefined
    COMPRESS_CSS undefined
    WP_LOCAL_DEV undefined

    I know this may seem like a dumb question but because it is saying that certain things are undefined, does that mean the plugin I’m using to compress css and minify and all that jazz whatever in the hell it means, is not working?

    Thank you in advance. 🙂

    Traci

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

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

    (@johnbillion)

    WordPress Core Developer

    Hi Traci,

    Most of the time, something that QM highlights in red is something that you’ll want to address.

    query_cache_size is a MySQL configuration setting. If your server has it configured to 0 then it means it can’t cache any queries, which will slow down your site. If you click the ‘Help’ link it’ll take you to Google search results with more information.

    The “Error: Function wcpgsk_load_wcsession_helper() does not exist” error sounds like a bug in the corresponding plugin (it’s adding an action to a hook but the action callback function doesn’t actually exist). You should report this to the plugin author.

    The “undefined” messages at the bottom can be a little misleading. Most plugins that provide minification/concatenation/compression for CSS and JS don’t use these constants. They’re used by WordPress to provide that functionality in the admin area, but not on the front end of your site.

    John

    Thread Starter Mrs. Johnson

    (@tmstclaire)

    Hi John,

    Thank you so much for responding! I wish I weren’t so ignorant! Can you recommend a good book to read that might help me understand what I’m seeing?

    My site is painfully slow but not all the time and it seems that everytime it is slow it this that gets that is the first line in red, everytime: SELECT option_name, option_value
    FROM wp_options
    WHERE autoload = ‘yes’ wp_load_alloptions()+ Core 581 0.1357

    This morning, it took over 4 min. for the page to load and I kept hitting the refresh button. 🙁

    I will continue to research how to change the query_cache_size appropriately since you said this will help but not sure how to fix the core issue or if it is even related.

    Thanks again,

    Traci

    Plugin Author John Blackbourn

    (@johnbillion)

    WordPress Core Developer

    A query which takes 0.1 seconds shouldn’t slow your site down to such an extent. I suspect something else is slowing it down.

    What’s the total database query time and total query count?

    What shows up in the “HTTP Requests” section of QM when the page loads slowly? It could be that a plugin is connecting to another server and slowing things down.

    Another plugin you could try is P3 Profiler which helps you to determine which plugin on your site is slowing things down, by means of deactivating them one by one and running performance profiling.

    Thread Starter Mrs. Johnson

    (@tmstclaire)

    Hi John,

    When I copied and pasted that query, it wasn’t acting up at the time but it did this morning.

    SELECT option_name, option_value
    FROM wp_options
    WHERE autoload = ‘yes’ wp_load_alloptions()+ Core 581 13.8563

    The total query count is 134 and nothing shows up in the “HTTP Requests” section when it loads slowly.

    I have the P3 Profiler but I need to read up on it so I can understand it better. Running it straight up is always woocommerce that is the slowest.

    Thanks again for all your help! Maybe I could just pay you to fix these things? 🙂

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

The topic ‘Red stuff’ is closed to new replies.