Solved

increase query timeout time using mysql workbench

Posted on 2013-11-17
4
2,417 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
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Technodweeb
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:
Technodweeb 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Index not getting used in mysql query 2 41
how to change the query from oracle to  mysql. 3 57
Error connecting to mysql on localhost 3 49
php image upload 3 37
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
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 …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

919 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now