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:
    64
    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:
    36,343
    Likes Received:
    1,209
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #2 cPanelMichael, Dec 23, 2015
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    64
    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:
    36,343
    Likes Received:
    1,209
    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. mlody69

    Very slow mysql queryies

    mlody69, Feb 9, 2016, in forum: Workarounds and Optimization
    Replies:
    5
    Views:
    835
    cPanelMichael
    Feb 23, 2016
  2. Skhilled44

    Installing mySQL and MariaDB

    Skhilled44, Jul 22, 2017 at 6:53 PM, in forum: Database Discussions
    Replies:
    1
    Views:
    22
    cPanelMichael
    Jul 24, 2017 at 11:00 AM
  3. Droidism20011

    MySQL -> MariaDB security questions

    Droidism20011, Jul 20, 2017 at 2:21 PM, in forum: Security
    Replies:
    3
    Views:
    72
    Droidism20011
    Jul 24, 2017 at 3:16 AM
  4. Ahmed Hany

    Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/

    Ahmed Hany, Jul 11, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    60
    cPanelMichael
    Jul 12, 2017
  5. mark4785

    MySQL DB Download Traces

    mark4785, Jun 30, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    78
    Infopro
    Jun 30, 2017

Share This Page