mysql query timeout

Masimo

• December 23, 2015 06:58

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.

• 

  cPanelMichael

  • December 23, 2015 16:20

  Hello :) The following thread is a good place to start if you want to optimize your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0
• 

  Masimo

  • January 13, 2016 08:39

  Is it possible to timeout a query in MySQL?

  0
• 

  cPanelMichael

  • January 13, 2016 18:27

  Is it possible to timeout a query in MySQL?

  
  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.

  0

Please sign in to leave a comment.