Solved

mysql remote access and long timeout time

Posted on 2013-11-18
2
489 Views
Last Modified: 2013-11-18
I have long queries to run.
I am looking for a remote mysql server that has a long timeout time.
I can not use localhost on my desktop computer because we need remote access.
Currently I am using godaddy hosting which times out after 3 minutes.
0
Comment
Question by:rgb192
2 Comments
 
LVL 34

Accepted Solution

by:
gr8gonzo earned 500 total points
ID: 39656522
As long as each query finishes before the time-out, you should be fine. So if you had:

Query A: Takes 2 minutes to run
Query B: Takes 2 minutes to run
Query C: Takes 2 minutes and 30 seconds to run

...then you should be able to execute each one of them individually and it should work.

The only problem would be if any queries ran longer than the timeout (e.g. Query B took 3 minutes and 30 seconds to run), but you could try setting the session timeout. Just run this query to set it to 300 seconds (5 minutes):

SET @@SESSION.wait_timeout=300;

Typically the timeouts only happen when there's no activity for that period of time, but you can give it a try.
0
 

Author Closing Comment

by:rgb192
ID: 39656665
That would be the correct answer to the question but I think I am looking for 'database hosting'  (if this is a correct search term) because I getting no data returned using a query editor which means i am not ready for php yet.

http://www.experts-exchange.com/Database/MySQL/Q_28297091.html
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.

747 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

14 Experts available now in Live!

Get 1:1 Help Now