Solved

increase query timeout time using mysql workbench

Posted on 2013-11-17
4
2,569 Views
Last Modified: 2013-11-24
my long queries timeout after 3 minutes

I am using godaddy mysql hosting, could it be on their end (which will never get fixed)

or is there a timeout option on windows mysql workbench query editor
0
Comment
Question by:rgb192
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39655366
The timeout is controlled on the server side. This is done to prevent bad code from doing bad things, as you probably already knew. GoDaddy might be able to adjust the timeout for your user account specifically but I do not know their policy on that. It is an option that can be modified.
0
 

Author Comment

by:rgb192
ID: 39665497
Yes, it may be godaddy, but do you know if
 timeout option available on mysql workbench or any mysql query tool.
0
 
LVL 11

Accepted Solution

by:
Gregory Miller earned 500 total points
ID: 39669005
I do not believe so.
The MySQL manual has this system variable:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_interactive_timeout

Unless you can modify the mysql.conf file on the server itself, this probably is not an option for you.

Having said that, I do know there are hosts out there that allow for the account holder to modify a local file which they will allow certain changes to the mysql.conf file as a privileged user, however, this setting can cause a malformed query to send the mysqld process to 100% utilization, thus stifling all user accounts connecting to the server.

The only way to know what your options are is to contact the ISP support. GoDaddy has pretty good support and they should be able to tell you yea or nay with details.
0
 

Author Closing Comment

by:rgb192
ID: 39673571
okay a .conf file

thanks
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question