Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

mysql remote access and long timeout time

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
rgb192
Asked:
rgb192
1 Solution
 
gr8gonzoConsultantCommented:
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
 
rgb192Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now