Being Throttled for Slow MySQL Slow Queries

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

    Being Throttled for Slow MySQL Slow Queries

    I have about had it with HostMonster.. they keep throttling my brand new install of VB. I only have two plugins installed on it.. BT Recent X Threads and DragonBye Advanced Post Thank/Like (Lite)

    I am getting told this is why I am being throttled:

    # Fri Jun 21 20:30:15 2013
    # Query_time: 1.004790 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    use thebh_tcc_vb;
    SET timestamp=1371868215;
    SET @@sql_mode = ''

    # Fri Jun 21 20:30:16 2013
    # Query_time: 1.209378 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    SET timestamp=1371868216;
    SET @@sql_mode = ''

    # Fri Jun 21 20:30:25 2013
    # Query_time: 1.276717 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    use thebh_vb;
    SET timestamp=1371868225;
    SET @@sql_mode = ''

    # Fri Jun 21 20:30:59 2013
    # Query_time: 1.535640 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    use thebh_vb;
    SET timestamp=1371868259;
    SET @@sql_mode = ''

    # Fri Jun 21 20:30:59 2013
    # Query_time: 1.494128 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    SET timestamp=1371868259;
    SET @@sql_mode = ''

    # Fri Jun 21 20:31:11 2013
    # Query_time: 1.931297 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    use thebh_vb;
    SET timestamp=1371868271;
    SELECT title, template
    FROM tcc_vbtemplate
    WHERE templateid IN (1050,1053,1055,1051,1052,1048,1058,0,1040,75,74,76,77,647,211,212,214,220,219,414,418,404 ,405,407,406,409,411,412,413,416,111,113,115,117,119,468,472,473,474,471,541,392,391,393,3 98,396,565,173,174,340,167,166,169,170,183,181,676,635,637,638,0,0,73,67,66,1019,1023,70,6 9,382,667,328,332,329,330,331,675,0,0,689,630,352,353,355,356,579,659,698,651,660,179,178, 182,5,0,1059,1038,1060)

    # Fri Jun 21 20:31:49 2013
    # Query_time: 1.139604 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    SET timestamp=1371868309;


    Please help me.
    I have no clue what this all means..
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    The Set Timestamp queries are from your server configuration. If they are throttling you for that, you need to find a new hosting provider that can properly configure MySQL.

    The only real query listed is this one:
    Code:
    SELECT title, template
    FROM tcc_vbtemplate
    WHERE templateid IN (1050,1053,1055,1051,1052,1048,1058,0,1040,75,74,76,77,647,211,212,214,220,219,414,418,404 ,405,407,406,409,411,412,413,416,111,113,115,117,119,468,472,473,474,471,541,392,391,393,3 98,396,565,173,174,340,167,166,169,170,183,181,676,635,637,638,0,0,73,67,66,1019,1023,70,6 9,382,667,328,332,329,330,331,675,0,0,689,630,352,353,355,356,579,659,698,651,660,179,178, 182,5,0,1059,1038,1060)
    It is a pretty basic query and shouldn't take almost two seconds to complete. Something else is causing MySQL to use too many resources and the server to get backlogged. Nothing in your post says what it is though.

    Please put your forum into debug mode by adding the following line to your config.php file under the <?:
    Code:
    $config['Misc']['debug'] = true;
    Then go to your site and add the following at the end of the URL. Once done with that, press enter to refresh the page.
    Code:
    &explain=1
    The resulting page should output every query, the time taken to run them and any problems with the queries. We need to see that page.
    Translations provided by Google.

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

    Comment

    • Jared867
      Member
      • Mar 2009
      • 64

      #3
      I found the config.php in my vb/included folder Is that the correct one?

      If so I dont see <?: in it (control f found none) All I see similar is <?php at the very top (line 1)

      Is this where i want to put that line of code?

      then I add as such .../vbforum/forum.php&explain=1

      ?

      if so I get page cannot be displayed.

      I am guessing I am doing something wrong somewhere.

      Comment

      • Jared867
        Member
        • Mar 2009
        • 64

        #4
        ok I got it:


        Click here if your browser does not automatically redirect you. X vBulletin 4.2.1 Debug Information
        Page Generation 1.89870 seconds Memory Usage 9,827KB Queries Executed 15 (?)
        More Information
        Template Usage (17):
        (1)STANDARD_REDIRECT
        (1)ad_footer_end
        (1)ad_footer_start
        (1)ad_global_above_footer
        (1)ad_global_below_navbar
        (1)ad_global_header1
        (1)ad_global_header2
        (1)ad_navbar_below
        (1)footer
        (1)fr_redirect
        (1)gobutton
        (1)header
        (1)headinclude
        (1)headinclude_bottom
        (3)navbar_notifications_menubit
        (1)spacer_close
        (1)spacer_open

        --------------------------------------------------------------------------------

        Phrase Groups Available (1):
        global
        Included Files (26):
        ./login.php
        ./global.php
        ./includes/class_bootstrap.php
        ./includes/init.php
        ./includes/class_core.php
        ./includes/config.php
        ./includes/functions.php
        ./includes/functions_navigation.php
        ./includes/class_hook.php
        ./dbtech/thanks/hooks/init_startup.php
        ./dbtech/thanks/includes/specialtemplates.php
        ./includes/class_bootstrap_framework.php
        ./vb/vb.php
        ./vb/phrase.php
        ./includes/class_friendly_url.php
        ./dbtech/thanks/hooks/global_start.php
        ./dbtech/thanks/includes/class_core.php
        ./dbtech/thanks/includes/class_cache.php
        ./includes/class_bitfield_builder.php
        ./includes/class_xml.php
        ./includes/functions_facebook.php
        ./dbtech/thanks/hooks/process_templates_complete.php
        ./includes/functions_login.php
        ./includes/functions_misc.php
        ./dbtech/thanks/hooks/cache_templates.php
        ./dbtech/thanks/hooks/notifications_list.php

        --------------------------------------------------------------------------------

        Hooks Called (33):
        init_startup
        database_pre_fetch_array
        database_post_fetch_array
        fetch_userinfo_query
        fetch_musername
        fetch_userinfo
        global_bootstrap_init_start
        global_bootstrap_init_complete
        cache_permissions
        load_show_variables
        load_forum_show_variables
        global_state_check
        global_bootstrap_complete
        global_start
        style_fetch
        global_setup_complete
        login_verify_success
        fetch_session_complete
        login_process
        login_redirect
        redirect_generic
        cache_templates
        cache_templates_process
        template_register_var
        template_render_output
        fetch_template_start
        fetch_template_complete
        parse_templates
        friendlyurl_resolve_class
        friendlyurl_clean_fragment
        friendlyurl_geturl
        notifications_list
        process_templates_complete


        Messages: php_sapi_name(): cgi-fcgi

        Comment

        • Hartmut
          Senior Member
          • Nov 2007
          • 2870
          • 4.2.x

          #5
          That looks all quite normal, there is nothing what could harm the server for getting throttled by your webhost.
          No private support, only PM me when I ask for it. Support in the forums only.

          Comment

          • Jared867
            Member
            • Mar 2009
            • 64

            #6
            Can you please give me a bit more info to go back to my host with? Id like to be able to tell them that they hey.. vb lead tech support said this "........... so fix your server and stop throttling my site"

            Comment

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