Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 13 Jun 2009, 05:58
DragonBlade's Avatar
DragonBlade DragonBlade is offline
 
Join Date: May 2006
MySQL Query Timeout?

Sometimes, there's a query that just "hangs" in the mysqld on my server, and because it's in a state of "Sending Data" it's preventing UPDATES and INSERTS to the tables it's selecting from. When this is the thread and/or the post table, it sometimes causes double-posts for some reason. When it's the session table, the forum lags for EVERYONE (of course, because the forum has to send data to the session table for each page load).

Now, I've been searching quite unsuccessfully for a way to set a "Query Timeout" value, that will basically destroy a query based on the condition it's a READING query (i.e., not UPDATE or INSERT or DELETE, etc.--only SELECT), and if it's loading for a long period of time.

I've been thinking about using mkill, but I can't find documentation of any user's experience with it, so I don't know if it's trustworthy or not.

Could someone give advice on mkill there, or if not, direct me to something that can achieve what I want?
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Extended timeout for whois online without changing cookie timeout Jakeman vBulletin 2.x Full Releases 21 30 Nov 2006 03:38



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 06:15.

Layout Options | Width: Wide Color: