WordPress.org

Ready to get started?Download WordPress

Forums

Caching DB queries? (4 posts)

  1. heddo
    Member
    Posted 8 months ago #

    Hello,

    My host company is complaining about the server consumption made by my website. I'm trying to install a plugin that can cache the DB queries. I'm using WP 3.7.1 but there is no caching plugin tested on this new version of WordPress.
    Can you, please, suggest any pluging that is working with the latest version of WP and that can cache the DB queries? I can also try any other pluging but some of them are not working with Google Adsense (ads are not showing anymore when the plugin is running).
    Thanks for all for the help!

    Regards.

  2. esmi
    Forum Moderator
    Posted 8 months ago #

  3. heddo
    Member
    Posted 8 months ago #

    Thank you for your reply. Actually, this one didn't work. It gave me a blank page and even after ready the troubleshooting section of that plugin, I got all my website down. So I deleted it...
    Is there anything else?

  4. heddo
    Member
    Posted 8 months ago #

    No help?
    My company (informaniak.ch) is still reading some problems in the slowlog file. They are not offering any technical support. They just report the problems. So I don't know what to do... I installed a plugin that caches all my posts so it won't overload the database process... Anyway, it looks like it's not working...
    This is a part of the error they sent to me by e-mail:

    # Time: 131203 13:27:39
    # User@Host: XXXXXXXX[esp09081063] @ XXXXXXXX [XXXXXXXX]
    # Query_time: 8.042020  Lock_time: 0.000162 Rows_sent: 372  Rows_examined: 403
    use XXXXXXXX;
    SET timestamp=1386073659;
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
    # Time: 131203 13:28:09
    # User@Host: XXXXXXXX[XXXXXXXX] @ XXXXXXXX [XXXXXXXX]
    # Query_time: 13.487866  Lock_time: 0.000074 Rows_sent: 23  Rows_examined: 28
    SET timestamp=1386073689;
    SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (131,162,216,1168,1443,1307,1363,4239,1773,1795,1797,3097,2406,2819,2651,2303,2129,3097,1931,3097,2264,196,49,181,169) AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC;
    # Time: 131203 13:29:00
    # User@Host: XXXXXXXX[XXXXXXXX] @ XXXXXXXX [XXXXXXXX]
    # Query_time: 33.185259  Lock_time: 0.000108 Rows_sent: 371  Rows_examined: 402
    use XXXXXXXX;
    SET timestamp=1386073740;
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
    # Time: 131203 13:29:06
    # User@Host: XXXXXXXX[XXXXXXXX] @ XXXXXXXX [XXXXXXXX]
    # Query_time: 57.597342  Lock_time: 0.000152 Rows_sent: 23  Rows_examined: 28
    use XXXXXXXX;
    SET timestamp=1386073746;
    SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (131,162,216,1168,1443,1307,1363,4239,1773,1795,1797,3097,2406,2819,2651,2303,2129,3097,1931,3097,2264,196,49,181,169) AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC;
    # Time: 131203 13:29:07
    # User@Host: XXXXXXXX[XXXXXXXX] @ XXXXXXXX [XXXXXXXX]
    # Query_time: 26.617659  Lock_time: 0.000324 Rows_sent: 371  Rows_examined: 402
    use XXXXXXXX;
    SET timestamp=1386073747;
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';

    Thanks for the help...

Reply

You must log in to post.

About this Topic