DragonBlade
06-13-2009, 04:58 AM
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 (http://linux.die.net/man/1/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?
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 (http://linux.die.net/man/1/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?