Solved

increase query timeout time using mysql workbench

Posted on 2013-11-17
4
2,449 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mysql Crashing Intermittently 16 106
RDBMS and No sql database 4 58
mysql disables rename 4 79
mysql to shows result of all other id in another colunm if id select in table 3 30
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

825 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