WordPress.org

Ready to get started?Download WordPress

Forums

Google XML sitemap problem MySQL (1 post)

  1. pavelevap
    Member
    Posted 5 years ago #

    Hello,
    I use plugin Google XML sitemaps and I get alert from my webhoster that there are many slow queries and database is overloaded.
    Example:

    # Time: 090105 16:49:18
    # User@Host: example_cz[example_cz] @ localhost []
    # Query_time: 14  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    UPDATE wp_options SET option_value =
    'O:28:\"GoogleSitemapGeneratorStatus\":34:{s:10:\"_startTime\";d:1231170530.
    034883975982666015625;s:8:\"_endTime\";i:0;s:11:\"_hasChanged\";b:1;s:12:\"_
    memoryUsage\";i:12845056;s:9:\"_lastPost\";i:98;s:9:\"_lastTime\";d:12311705
    44.2615311145782470703125;s:8:\"_usedXml\";b:1;s:11:\"_xmlSuccess\";b:0;s:8:
    \"_xmlPath\";s:61:\"/var/www/web5/example.cz/example.cz/sitema
    p.xml\";s:7:\"_xmlUrl\";s:40:\"http://www.example.cz/sitemap.xml\";s:
    8:\"_usedZip\";b:1;s:11:\"_zipSuccess\";b:0;s:8:\"_zipPath\";s:64:\"/var/www
    /web5/example.cz/example.cz/sitemap.xml.gz\";s:7:\"_zipUrl\";s
    :43:\"http://www.example.cz/sitemap.xml.gz\";s:11:\"_usedGoogle\";b:0
    ;s:10:\"_googleUrl\";s:0:\"\";s:15:\"_gooogleSuccess\";b:0;s:16:\"_googleSta
    rtTime\";i:0;s:14:\"_googleEndTime\";i:0;s:10:\"_usedYahoo\";b:0;s:9:\"_yaho
    oUrl\";s:0:\"\";s:13:\"_yahooSuccess\";b:0;s:15:\"_yahooStartTime\";i:0;s:13
    :\"_yahooEndTime\";i:0;s:8:\"_usedAsk\";b:0;s:7:\"_askUrl\";s:0:\"\";s:11:\"
    _askSuccess\";b:0;s:13:\"_askStartTime\";i:0;s:11:\"_askEndTime\";i:0;s:8:\"
    _usedMsn\";b:0;s:7:\"_msnUrl\";s:0:\"\";s:11:\"_msnSuccess\";b:0;s:13:\"_msn
    StartTime\";i:0;s:11:\"_msnEndTime\";i:0;}' WHERE option_name = 'sm_status';
    
    # Time: 090105 16:49:22
    # User@Host: example_cz[example_cz] @ localhost []
    # Query_time: 16  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
    SELECT option_id, autoload FROM wp_options WHERE option_name =
    'rewrite_rules';
    
    # Time: 090105 16:49:25
    # User@Host: example_cz[example_cz] @ localhost []
    # Query_time: 14  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    UPDATE wp_options SET option_value =
    'O:28:\"GoogleSitemapGeneratorStatus\":34:{s:10:\"_startTime\";d:1231170529.
    3335840702056884765625;s:8:\"_endTime\";i:0;s:11:\"_hasChanged\";b:1;s:12:\"
    _memoryUsage\";i:12845056;s:9:\"_lastPost\";i:98;s:9:\"_lastTime\";d:1231170
    537.9939110279083251953125;s:8:\"_usedXml\";b:1;s:11:\"_xmlSuccess\";b:1;s:8
    :\"_xmlPath\";s:61:\"/var/www/web5/example.cz/example.cz/sitem
    ap.xml\";s:7:\"_xmlUrl\";s:40:\"http://www.example.cz/sitemap.xml\";s
    :8:\"_usedZip\";b:1;s:11:\"_zipSuccess\";b:1;s:8:\"_zipPath\";s:64:\"/var/ww
    w/web5/example.cz/example.cz/sitemap.xml.gz\";s:7:\"_zipUrl\";
    s:43:\"http://www.example.cz/sitemap.xml.gz\";s:11:\"_usedGoogle\";b:
    1;s:10:\"_googleUrl\";b:1;s:15:\"_gooogleSuccess\";b:1;s:16:\"_googleStartTi
    me\";d:1231170542.824532032012939453125;s:14:\"_googleEndTime\";d:1231170543
    .205461025238037109375;s:10:\"_usedYahoo\";b:0;s:9:\"_yahooUrl\";s:0:\"\";s:
    13:\"_yahooSuccess\";b:0;s:15:\"_yahooStartTime\";i:0;s:13:\"_yahooEndTime\"
    ;i:0;s:8:\"_usedAsk\";b:1;s:7:\"_askUrl\";s:91:\"http://submissions.ask.com/
    ping?sitemap=http%3A%2F%2Fwww.example.cz%2Fsitemap.xml.gz\";s:11:\"_a
    skSuccess\";b:1;s:13:\"_askStartTime\";d:1231170543.6478750705718994140625;s
    :11:\"_askEndTime\";d:1231170551.536878108978271484375;s:8:\"_usedMsn\";b:0;
    s:7:\"_msnUrl\";s:0:\"\";s:11:\"_msnSuccess\";b:0;s:13:\"_msnStartTime\";i:0
    ;s:11:\"_msnEndTime\";i:0;}' WHERE option_name = 'sm_status';
    
    # Time: 090105 16:49:37
    # User@Host: example_cz[example_cz] @ localhost []
    # Query_time: 11  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    UPDATE wp_options SET option_value =
    'O:28:\"GoogleSitemapGeneratorStatus\":34:{s:10:\"_startTime\";d:1231170529.
    3335840702056884765625;s:8:\"_endTime\";d:1231170566.75456905364990234375;s:
    11:\"_hasChanged\";b:1;s:12:\"_memoryUsage\";i:13107200;s:9:\"_lastPost\";i:
    98;s:9:\"_lastTime\";d:1231170537.9939110279083251953125;s:8:\"_usedXml\";b:
    1;s:11:\"_xmlSuccess\";b:1;s:8:\"_xmlPath\";s:61:\"/var/www/web5/example.cz/example.cz/sitemap.xml\";s:7:\"_xmlUrl\";s:40:\"http://www.example.cz/sitemap.xml\";s:8:\"_usedZip\";b:1;s:11:\"_zipSuccess\";b:1;s
    :8:\"_zipPath\";s:64:\"/var/www/web5/example.cz/example.cz/sit
    emap.xml.gz\";s:7:\"_zipUrl\";s:43:\"http://www.example.cz/sitemap.xm
    l.gz\";s:11:\"_usedGoogle\";b:1;s:10:\"_googleUrl\";b:1;s:15:\"_gooogleSucce
    ss\";b:1;s:16:\"_googleStartTime\";d:1231170542.824532032012939453125;s:14:\
    "_googleEndTime\";d:1231170543.205461025238037109375;s:10:\"_usedYahoo\";b:0
    ;s:9:\"_yahooUrl\";s:0:\"\";s:13:\"_yahooSuccess\";b:0;s:15:\"_yahooStartTim
    e\";i:0;s:13:\"_yahooEndTime\";i:0;s:8:\"_usedAsk\";b:1;s:7:\"_askUrl\";s:91
    :\"http://submissions.ask.com/ping?sitemap=http%3A%2F%2Fwww.example.c
    z%2Fsitemap.xml.gz\";s:11:\"_askSuccess\";b:1;s:13:\"_askStartTime\";d:12311
    70543.6478750705718994140625;s:11:\"_askEndTime\";d:1231170551.5368781089782
    71484375;s:8:\"_usedMsn\";b:1;s:7:\"_msnUrl\";s:95:\"http://webmaster.live.c
    om/ping.aspx?siteMap=http%3A%2F%2Fwww.example.cz%2Fsitemap.xml.gz\";s
    :11:\"_msnSuccess\";b:1;s:13:\"_msnStartTime\";d:1231170565.1456420421600341
    796875;s:11:\"_msnEndTime\";d:1231170565.891562938690185546875;}' WHERE
    option_name = 'sm_status';

Topic Closed

This topic has been closed to new replies.

About this Topic