Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql query timeout

Discussion in 'Database Discussions' started by Masimo, Dec 23, 2015.

  1. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    How can limit mysql query runing time? and what is standard time for shared hosting server?
    Today, i found a hosting account on my server with too much mysql query runing time when server load was normal, but too slow on response.
    When i suspend, server come normal.
     
    #1 Masimo, Dec 23, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,715
    Likes Received:
    1,705
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #2 cPanelMichael, Dec 23, 2015
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Is it possible to timeout a query in MySQL?
     
    #3 Masimo, Jan 13, 2016
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,715
    Likes Received:
    1,705
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You may find this document helpful if your goal is to detect slow queries:

    MySQL :: MySQL 5.6 Reference Manual :: 5.1.4 Server System Variables

    It's likely a good idea to address the databases and tables that are resulting in slow queries if that's an issue you are facing.

    Thank you.
     
    #4 cPanelMichael, Jan 13, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql query timeout
  1. suganthanatwork

    Lost connection to MySQL server during query error

    suganthanatwork, Jan 25, 2018, in forum: Database Discussions
    Replies:
    7
    Views:
    497
    dave321
    Feb 1, 2018
  2. TragedyStruck

    SOLVED "Lost connection to MySQL server during query" with Python App

    TragedyStruck, Aug 11, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    3,398
    cPanelMichael
    Aug 28, 2017
  3. Peter Horvath

    InnoDB crashed, no MySQL service available

    Peter Horvath, Apr 17, 2018 at 6:03 PM, in forum: Database Discussions
    Replies:
    2
    Views:
    39
    Infopro
    Apr 17, 2018 at 8:28 PM
  4. Spuddyboy

    SOLVED Setup Remote MySQL - WHM 68

    Spuddyboy, Apr 16, 2018 at 9:00 AM, in forum: Database Discussions
    Replies:
    3
    Views:
    43
    cPanelMichael
    Apr 17, 2018 at 8:37 AM
  5. sergios

    MySQL Remoto em Produção

    sergios, Apr 11, 2018, in forum: Discussões em Português
    Replies:
    3
    Views:
    67
    cPanelLauren
    Apr 18, 2018 at 7:52 AM

Share This Page