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:
    65
    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:
    38,165
    Likes Received:
    1,371
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #2 cPanelMichael, Dec 23, 2015
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    65
    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:
    38,165
    Likes Received:
    1,371
    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. TragedyStruck

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

    TragedyStruck, Aug 11, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    274
    cPanelMichael
    Aug 28, 2017
  2. mlody69

    Very slow mysql queryies

    mlody69, Feb 9, 2016, in forum: Workarounds and Optimization
    Replies:
    5
    Views:
    913
    cPanelMichael
    Feb 23, 2016
  3. dr_lucas

    Cron Job issue: PHP Fatal error: Call to undefined function mysqli_connect()

    dr_lucas, Sep 21, 2017 at 1:09 PM, in forum: General Discussion
    Replies:
    3
    Views:
    44
    cPanelMichael
    Sep 21, 2017 at 2:55 PM
  4. abdelhost77

    mysql_connect & EA4

    abdelhost77, Sep 21, 2017 at 10:33 AM, in forum: EasyApache
    Replies:
    8
    Views:
    40
    abdelhost77
    Sep 21, 2017 at 12:32 PM
  5. mysql4all

    Where are mysql databases located?

    mysql4all, Sep 19, 2017 at 2:47 AM, in forum: Database Discussions
    Replies:
    2
    Views:
    56
    cPanelMichael
    Sep 19, 2017 at 10:41 AM

Share This Page