Do These Queries Look Abnormal or unusually slow?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jared867
    Member
    • Mar 2009
    • 64

    Do These Queries Look Abnormal or unusually slow?

    Host monster keeps throttling my server.. do these queries look slow or unusual for VB?


    my vbulletin is tcc_vb.. ignore the other wor1... thats just my wordpress.
    20130702-07.log
    ASCII English text, with very long lines

    # Tue Jul 2 07:02:28 2013 # Query_time: 1.060821 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372770148; SET @@sql_mode = '' # Tue Jul 2 07:08:41 2013 # Query_time: 1.471916 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372770521; SET NAMES utf8 # Tue Jul 2 07:08:57 2013 # Query_time: 1.856519 Lock_time: 0.000182 Rows_sent: 0 Rows_examined: 1 use thebassh_wor1; SET timestamp=1372770537; UPDATE `ode_options` SET `option_value` = 'a:15:{i:1372770148;a:1:{s:20:\"jetpack_clean_nonces\";a:1:{s:32:\"40cd750bba9870f18aada24 78b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:360 0;}}}i:1372770202;a:1:{s:14:\"wpsd_cron_hook\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840 a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1 372770809;a:1:{s:20:\"doadexpirations_hook\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\ ";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:137 2770976;a:1:{s:19:\"wp_cache_gc_watcher\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a :3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:137277 1062;a:1:{s:24:\"wp_rp_load_notifications\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\" ;a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1372 771842;a:1:{s:16:\"nxs_hourly_event\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{ s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1372773748 ;a:1:{s:20:\"jetpack_clean_nonces\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s: 8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1372774957;a :1:{s:24:\"akismet_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{ s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372795588 ;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\" schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_upd ate_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\" twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{ s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\" args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1372795590;a:1:{s:19:\"wp_scheduled_delete\";a: 1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"arg s\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372810409;a:2:{s:27:\"awpcp_ad_renewal_email_hook \";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4: \"args\";a:0:{}s:8:\"interval\";i:86400;}}s:35:\"awpcp-clean-up-payment-transactions\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\" daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372819211;a:1:{s:30:\"wp_schedul ed_auto_draft_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\ ";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372827600;a:1:{s:11:\"wp _cache_gc\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"dai ly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372853761;a:1:{s:14:\"yoast_trackin g\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4 :\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron' # Tue Jul 2 07:18:15 2013 # Query_time: 1.307973 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771095; SET NAMES utf8 # Tue Jul 2 07:18:22 2013 # Query_time: 1.859030 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771102; SET NAMES utf8 # Tue Jul 2 07:18:39 2013 # Query_time: 10.154580 Lock_time: 0.000201 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372771119; INSERT IGNORE INTO tcc_vbsession (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken) VALUES ('6be3db047cf72a7a7230a13326a70c44', 0, '124.73.173.223', '149a3b811a329d9c48ce6870df43d569', 1372771108, '/angler-support/index.php', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2', 0, 0, 0, '') # Tue Jul 2 07:18:49 2013 # Query_time: 1.192644 Lock_time: 0.000164 Rows_sent: 0 Rows_examined: 1 use thebassh_tcc_vb; SET timestamp=1372771129; UPDATE tcc_vbsession SET lastactivity = 1372771126, location = '/angler-support/forumdisplay.php?1-Angler-Support', badlocation = 1 WHERE sessionhash = '6be3db047cf72a7a7230a13326a70c44' # Tue Jul 2 07:27:18 2013 # Query_time: 1.163990 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372771638; SET @@sql_mode = '' # Tue Jul 2 07:31:10 2013 # Query_time: 2.053339 Lock_time: 0.000200 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372771870; INSERT IGNORE INTO tcc_vbsession (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken) VALUES ('78578a4e208fd8dcbdbba4afe0c57b2c', 0, '60.168.26.250', '73f5762bdba62eb890e8269f9498afc3', 1372771866, '/angler-support/index.php', 0, 0, 0, 0, 0, 0, 0, 'Opera/9.80 (Windows NT 6.1; MRA 6.0 (build 5970)) Presto/2.12.388 Version/12.11', 0, 0, 0, '') # Tue Jul 2 07:32:26 2013 # Query_time: 1.011264 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771946; SET NAMES utf8 # Tue Jul 2 07:32:39 2013 # Query_time: 1.258403 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771959; SET NAMES utf8 # Tue Jul 2 07:33:15 2013 # Query_time: 1.488204 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771995; SET NAMES utf8 # Tue Jul 2 07:33:19 2013 # Query_time: 1.308690 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771999; SET NAMES utf8 # Tue Jul 2 07:33:26 2013 # Query_time: 1.204700 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772006; SET @@sql_mode = '' # Tue Jul 2 07:33:27 2013 # Query_time: 1.377566 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772007; SELECT option_value FROM ode_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1 # Tue Jul 2 07:33:27 2013 # Query_time: 1.169764 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772007; SELECT option_name, option_value FROM ode_options WHERE autoload = 'yes' # Tue Jul 2 07:33:35 2013 # Query_time: 1.727671 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772015; SET NAMES utf8 # Tue Jul 2 07:33:56 2013 # Query_time: 3.399948 Lock_time: 0.782101 Rows_sent: 1 Rows_examined: 1 use thebassh_wor1; SET timestamp=1372772036; SELECT t.*, tt.* FROM ode_terms AS t INNER JOIN ode_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag' AND t.term_id = 100 LIMIT 1 # Tue Jul 2 07:33:56 2013 # Query_time: 2.557456 Lock_time: 0.053172 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772036; SELECT option_value FROM ode_options WHERE option_name = 'wpseo_internallinks' LIMIT 1 # Tue Jul 2 07:33:58 2013 # Query_time: 1.815862 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772038; SET NAMES utf8 # Tue Jul 2 07:34:14 2013 # Query_time: 1.850586 Lock_time: 0.376711 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772054; SELECT option_value FROM ode_options WHERE option_name = 'widget_pages' LIMIT 1 # Tue Jul 2 07:34:14 2013 # Query_time: 1.569504 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772054; SELECT option_value FROM ode_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1 # Tue Jul 2 07:34:14 2013 # Query_time: 1.510884 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772054; SELECT option_name, option_value FROM ode_options WHERE autoload = 'yes' # Tue Jul 2 07:34:29 2013 # Query_time: 1.135256 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772069; SET @@sql_mode = '' # Tue Jul 2 07:36:52 2013 # Query_time: 1.383504 Lock_time: 0.000185 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772212; REPLACE INTO tcc_vbautosave (contenttypeid, contentid, parentcontentid, userid, pagetext, title, posthash, dateline) VALUES ( 'vBForum_Post', 0, 72, 78, 'Do you have a contour map of the lake? If not, check', '', '888a026c4d18b61a5725c88b243f571c', 1372772209 ) # Tue Jul 2 07:39:34 2013 # Query_time: 1.055567 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772374; SET NAMES utf8 # Tue Jul 2 07:39:34 2013 # Query_time: 1.206944 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772374; SET @@sql_mode = '' # Tue Jul 2 07:39:53 2013 # Query_time: 1.486427 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772393; SET @@sql_mode = '' # Tue Jul 2 07:41:57 2013 # Query_time: 1.166889 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772517; SELECT * FROM tcc_vbstyle WHERE (styleid = 11 AND userselect = 1) OR styleid = 11 ORDER BY styleid ASC LIMIT 1 # Tue Jul 2 07:42:14 2013 # Query_time: 2.418242 Lock_time: 0.032920 Rows_sent: 1 Rows_examined: 1 use thebassh_tcc_vb; SET timestamp=1372772534; SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_global AS phrasegroup_global, language.phrasegroup_threadmanage AS phrasegroup_threadmanage, language.phrasegroup_postbit AS phrasegroup_postbit, language.phrasegroup_posting AS phrasegroup_posting, language.phrasegroup_prefix AS phrasegroup_prefix, language.phrasegroupinfo AS lang_phrasegroupinfo, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM tcc_vbuser AS user LEFT JOIN tcc_vbuserfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN tcc_vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN tcc_vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) WHERE user.userid = 78 LIMIT 1 # Tue Jul 2 07:42:25 2013 # Query_time: 1.351723 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772545; SET @@sql_mode = '' # Tue Jul 2 07:42:29 2013 # Query_time: 3.465823 Lock_time: 0.000081 Rows_sent: 0 Rows_examined: 1 use thebassh_tcc_vb; SET timestamp=1372772549; UPDATE tcc_vbcron SET nextrun = 1372775100 WHERE cronid = 3 AND nextrun = 1372771500 # Tue Jul 2 07:44:00 2013 # Query_time: 2.236409 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772640; SET @@sql_mode = '' # Tue Jul 2 07:44:07 2013 # Query_time: 2.518438 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772647; SET @@sql_mode = '' # Tue Jul 2 07:44:08 2013 # Query_time: 2.830741 Lock_time: 0.050241 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772648; SELECT option_value FROM ode_options WHERE option_name = 'embed_autourls' LIMIT 1 # Tue Jul 2 07:45:28 2013 # Query_time: 1.371133 Lock_time: 0.000310 Rows_sent: 1 Rows_examined: 2 use thebassh_tcc_vb; SET timestamp=1372772728; SELECT cron.* FROM tcc_vbcron AS cron LEFT JOIN tcc_vbproduct AS product ON (cron.product = product.productid) WHERE cron.nextrun <= 1372772725 AND cron.active = 1 AND (product.productid IS NULL OR product.active = 1) ORDER BY cron.nextrun LIMIT 1 # Tue Jul 2 07:46:32 2013 # Query_time: 4.922009 Lock_time: 0.000211 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772792; REPLACE INTO tcc_vbautosave (contenttypeid, contentid, parentcontentid, userid, pagetext, title, posthash, dateline) VALUES ( 'vBForum_Thread', 0, 0, 78, 'http://myfwc.com/fishing', '', 'e6e7e8d30061f7e81a366d7c51633142', 1372772786 ) # Tue Jul 2 07:46:55 2013 # Query_time: 1.549988 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772815; SET @@sql_mode = '' # Tue Jul 2 07:51:27 2013 # Query_time: 1.685799 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372773087; SET @@sql_mode = '' # Tue Jul 2 07:54:02 2013 # Query_time: 1.812589 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372773242; SET @@sql_mode = ''
  • Jared867
    Member
    • Mar 2009
    • 64

    #2
    sorry I cant get the log to paste with line breaks... I have tried 3 times now. any tips?

    Comment

    • snakes1100
      Senior Member
      • Aug 2001
      • 1249

      #3
      Wrap it in the code tags [ code]text [/code]

      I see mostly 0 lock times, but there are a few that are getting a small lock wait, but that doesnt really mean its a issue.

      Code:
      SELECT option_name, option_value FROM ode_options WHERE autoload = 'yes' # Tue Jul 2 07:33:35 2013 # Query_time: 1.727671 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772015; SET NAMES utf8 # Tue Jul 2 07:33:56 2013 # Query_time: 3.399948 Lock_time: 0.782101 Rows_sent: 1 Rows_examined: 1 use thebassh_wor1; SET timestamp=1372772036; SELECT t.*, tt.* FROM ode_terms AS t INNER JOIN ode_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag' AND t.term_id = 100 LIMIT 1
      Is this a dedicated server?
      Gentoo Geek

      Comment

      • Jared867
        Member
        • Mar 2009
        • 64

        #4
        [ code]
        20130702-07.log
        ASCII English text, with very long lines

        # Tue Jul 2 07:02:28 2013 # Query_time: 1.060821 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372770148; SET @@sql_mode = '' # Tue Jul 2 07:08:41 2013 # Query_time: 1.471916 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372770521; SET NAMES utf8 # Tue Jul 2 07:08:57 2013 # Query_time: 1.856519 Lock_time: 0.000182 Rows_sent: 0 Rows_examined: 1 use thebassh_wor1; SET timestamp=1372770537; UPDATE `ode_options` SET `option_value` = 'a:15:{i:1372770148;a:1:{s:20:\"jetpack_clean_nonces\";a:1:{s:32:\"40cd750bba9870f18aada24 78b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:360 0;}}}i:1372770202;a:1:{s:14:\"wpsd_cron_hook\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840 a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1 372770809;a:1:{s:20:\"doadexpirations_hook\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\ ";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:137 2770976;a:1:{s:19:\"wp_cache_gc_watcher\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a :3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:137277 1062;a:1:{s:24:\"wp_rp_load_notifications\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\" ;a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1372 771842;a:1:{s:16:\"nxs_hourly_event\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{ s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1372773748 ;a:1:{s:20:\"jetpack_clean_nonces\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s: 8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1372774957;a :1:{s:24:\"akismet_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{ s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372795588 ;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\" schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_upd ate_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\" twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{ s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\" args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1372795590;a:1:{s:19:\"wp_scheduled_delete\";a: 1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"arg s\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372810409;a:2:{s:27:\"awpcp_ad_renewal_email_hook \";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4: \"args\";a:0:{}s:8:\"interval\";i:86400;}}s:35:\"awpcp-clean-up-payment-transactions\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\" daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372819211;a:1:{s:30:\"wp_schedul ed_auto_draft_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\ ";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372827600;a:1:{s:11:\"wp _cache_gc\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"dai ly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1372853761;a:1:{s:14:\"yoast_trackin g\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4 :\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron' # Tue Jul 2 07:18:15 2013 # Query_time: 1.307973 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771095; SET NAMES utf8 # Tue Jul 2 07:18:22 2013 # Query_time: 1.859030 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771102; SET NAMES utf8 # Tue Jul 2 07:18:39 2013 # Query_time: 10.154580 Lock_time: 0.000201 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372771119; INSERT IGNORE INTO tcc_vbsession (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken) VALUES ('6be3db047cf72a7a7230a13326a70c44', 0, '124.73.173.223', '149a3b811a329d9c48ce6870df43d569', 1372771108, '/angler-support/index.php', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2', 0, 0, 0, '') # Tue Jul 2 07:18:49 2013 # Query_time: 1.192644 Lock_time: 0.000164 Rows_sent: 0 Rows_examined: 1 use thebassh_tcc_vb; SET timestamp=1372771129; UPDATE tcc_vbsession SET lastactivity = 1372771126, location = '/angler-support/forumdisplay.php?1-Angler-Support', badlocation = 1 WHERE sessionhash = '6be3db047cf72a7a7230a13326a70c44' # Tue Jul 2 07:27:18 2013 # Query_time: 1.163990 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372771638; SET @@sql_mode = '' # Tue Jul 2 07:31:10 2013 # Query_time: 2.053339 Lock_time: 0.000200 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372771870; INSERT IGNORE INTO tcc_vbsession (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken) VALUES ('78578a4e208fd8dcbdbba4afe0c57b2c', 0, '60.168.26.250', '73f5762bdba62eb890e8269f9498afc3', 1372771866, '/angler-support/index.php', 0, 0, 0, 0, 0, 0, 0, 'Opera/9.80 (Windows NT 6.1; MRA 6.0 (build 5970)) Presto/2.12.388 Version/12.11', 0, 0, 0, '') # Tue Jul 2 07:32:26 2013 # Query_time: 1.011264 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771946; SET NAMES utf8 # Tue Jul 2 07:32:39 2013 # Query_time: 1.258403 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771959; SET NAMES utf8 # Tue Jul 2 07:33:15 2013 # Query_time: 1.488204 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771995; SET NAMES utf8 # Tue Jul 2 07:33:19 2013 # Query_time: 1.308690 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372771999; SET NAMES utf8 # Tue Jul 2 07:33:26 2013 # Query_time: 1.204700 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772006; SET @@sql_mode = '' # Tue Jul 2 07:33:27 2013 # Query_time: 1.377566 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772007; SELECT option_value FROM ode_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1 # Tue Jul 2 07:33:27 2013 # Query_time: 1.169764 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772007; SELECT option_name, option_value FROM ode_options WHERE autoload = 'yes' # Tue Jul 2 07:33:35 2013 # Query_time: 1.727671 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772015; SET NAMES utf8 # Tue Jul 2 07:33:56 2013 # Query_time: 3.399948 Lock_time: 0.782101 Rows_sent: 1 Rows_examined: 1 use thebassh_wor1; SET timestamp=1372772036; SELECT t.*, tt.* FROM ode_terms AS t INNER JOIN ode_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'post_tag' AND t.term_id = 100 LIMIT 1 # Tue Jul 2 07:33:56 2013 # Query_time: 2.557456 Lock_time: 0.053172 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772036; SELECT option_value FROM ode_options WHERE option_name = 'wpseo_internallinks' LIMIT 1 # Tue Jul 2 07:33:58 2013 # Query_time: 1.815862 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772038; SET NAMES utf8 # Tue Jul 2 07:34:14 2013 # Query_time: 1.850586 Lock_time: 0.376711 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772054; SELECT option_value FROM ode_options WHERE option_name = 'widget_pages' LIMIT 1 # Tue Jul 2 07:34:14 2013 # Query_time: 1.569504 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772054; SELECT option_value FROM ode_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1 # Tue Jul 2 07:34:14 2013 # Query_time: 1.510884 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772054; SELECT option_name, option_value FROM ode_options WHERE autoload = 'yes' # Tue Jul 2 07:34:29 2013 # Query_time: 1.135256 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772069; SET @@sql_mode = '' # Tue Jul 2 07:36:52 2013 # Query_time: 1.383504 Lock_time: 0.000185 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772212; REPLACE INTO tcc_vbautosave (contenttypeid, contentid, parentcontentid, userid, pagetext, title, posthash, dateline) VALUES ( 'vBForum_Post', 0, 72, 78, 'Do you have a contour map of the lake? If not, check', '', '888a026c4d18b61a5725c88b243f571c', 1372772209 ) # Tue Jul 2 07:39:34 2013 # Query_time: 1.055567 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1372772374; SET NAMES utf8 # Tue Jul 2 07:39:34 2013 # Query_time: 1.206944 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772374; SET @@sql_mode = '' # Tue Jul 2 07:39:53 2013 # Query_time: 1.486427 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772393; SET @@sql_mode = '' # Tue Jul 2 07:41:57 2013 # Query_time: 1.166889 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772517; SELECT * FROM tcc_vbstyle WHERE (styleid = 11 AND userselect = 1) OR styleid = 11 ORDER BY styleid ASC LIMIT 1 # Tue Jul 2 07:42:14 2013 # Query_time: 2.418242 Lock_time: 0.032920 Rows_sent: 1 Rows_examined: 1 use thebassh_tcc_vb; SET timestamp=1372772534; SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_global AS phrasegroup_global, language.phrasegroup_threadmanage AS phrasegroup_threadmanage, language.phrasegroup_postbit AS phrasegroup_postbit, language.phrasegroup_posting AS phrasegroup_posting, language.phrasegroup_prefix AS phrasegroup_prefix, language.phrasegroupinfo AS lang_phrasegroupinfo, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM tcc_vbuser AS user LEFT JOIN tcc_vbuserfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN tcc_vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN tcc_vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) WHERE user.userid = 78 LIMIT 1 # Tue Jul 2 07:42:25 2013 # Query_time: 1.351723 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772545; SET @@sql_mode = '' # Tue Jul 2 07:42:29 2013 # Query_time: 3.465823 Lock_time: 0.000081 Rows_sent: 0 Rows_examined: 1 use thebassh_tcc_vb; SET timestamp=1372772549; UPDATE tcc_vbcron SET nextrun = 1372775100 WHERE cronid = 3 AND nextrun = 1372771500 # Tue Jul 2 07:44:00 2013 # Query_time: 2.236409 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772640; SET @@sql_mode = '' # Tue Jul 2 07:44:07 2013 # Query_time: 2.518438 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772647; SET @@sql_mode = '' # Tue Jul 2 07:44:08 2013 # Query_time: 2.830741 Lock_time: 0.050241 Rows_sent: 0 Rows_examined: 0 use thebassh_wor1; SET timestamp=1372772648; SELECT option_value FROM ode_options WHERE option_name = 'embed_autourls' LIMIT 1 # Tue Jul 2 07:45:28 2013 # Query_time: 1.371133 Lock_time: 0.000310 Rows_sent: 1 Rows_examined: 2 use thebassh_tcc_vb; SET timestamp=1372772728; SELECT cron.* FROM tcc_vbcron AS cron LEFT JOIN tcc_vbproduct AS product ON (cron.product = product.productid) WHERE cron.nextrun <= 1372772725 AND cron.active = 1 AND (product.productid IS NULL OR product.active = 1) ORDER BY cron.nextrun LIMIT 1 # Tue Jul 2 07:46:32 2013 # Query_time: 4.922009 Lock_time: 0.000211 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772792; REPLACE INTO tcc_vbautosave (contenttypeid, contentid, parentcontentid, userid, pagetext, title, posthash, dateline) VALUES ( 'vBForum_Thread', 0, 0, 78, 'http://myfwc.com/fishing', '', 'e6e7e8d30061f7e81a366d7c51633142', 1372772786 ) # Tue Jul 2 07:46:55 2013 # Query_time: 1.549988 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372772815; SET @@sql_mode = '' # Tue Jul 2 07:51:27 2013 # Query_time: 1.685799 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372773087; SET @@sql_mode = '' # Tue Jul 2 07:54:02 2013 # Query_time: 1.812589 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use thebassh_tcc_vb; SET timestamp=1372773242; SET @@sql_mode = ''
        [/code]

        Comment

        • Jared867
          Member
          • Mar 2009
          • 64

          #5
          ugh didnt work... not sure why.. it worked the other day for me. hmm

          Comment

          • Jared867
            Member
            • Mar 2009
            • 64

            #6
            Im shared hosting on HostMonster.. my db is only 25 megs an I only have 122 members and its closed to the public so I am totally blown away why hostmonster is throttling me. I only have two plugins.. a resent post on and a thanks/like one..

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73981

              #7
              The queries don't look unusual but they are unusually slow. You shouldn't be experiencing any lock times on the session table as it should be a Memory table in your version of vBulletin. This means it writes directly to RAM instead of the disk. The most likely cause is your shared server and MySQL being overwhelmed. Did HostMonster contact you about these queries? Should ask them to move you to a less populated server and see if that resolves the issue...

              Other than that, your options are limited on a shared server. You can try updating your tables to INNODB to see if that resolves the lock issues. Your search* tables will need to remain as MyISAM or your search will not work. Though the session and cpsession tables should remain MEMORY tables.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              • snakes1100
                Senior Member
                • Aug 2001
                • 1249

                #8
                Sorry Jared, you have to remove the space i put in the first [ code] before the c..., didnt want it to parse.

                My guess to them answer Wayne's question of moving you to a less populated server is going to be the host telling you to move to a VPS, typical answer.
                Gentoo Geek

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...