MySQL

Change MySQL Query Timeout Period

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2002

Posts: 175

Reputation: AlPhA is an unknown quantity at this point

Solved Threads: 1

AlPhA

Offline

Junior Poster

Change MySQL Query Timeout Period

Nov 16th, 2006

Hey,

Does anyone know where the settings for MySQL's Query timeout is located?

I think it should be in one of the ini files, but i don't know where i can find this.

Thanks!
AlPhA

Last edited by AlPhA; Nov 16th, 2006 at 3:09 pm.

One day, we will die, when it comes...... i dunno, i'm not psychic!

•

Join Date: Nov 2006

Posts: 10

Reputation: redsa is an unknown quantity at this point

Solved Threads: 0

redsa

Offline

Newbie Poster

Re: Change MySQL Query Timeout Period

Dec 11th, 2006

Are you sure that your query get a timeout?
I often execute sql-queries that take more than 10minutes
maybe you have a timeout in your PHP page if so: take a look at the function: set_time_limit here: http://it2.php.net/set_time_limit

8Lights - Social Net Ratings
Websites statistics, reviews, ratings, thumbnail, related news and more!