Re: MySQL Query Timeout program in PHP
| From: | Chris | Date: | Thu, 16 Oct 2008 03:57:02 +0000 |
| Subject: | Re: MySQL Query Timeout program in PHP | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45531@lists.php.net to get a copy of this message | ||
Piyush Kumar wrote:
Hi Chris, As I mentioned in my query I want to Kill only the query ran by web client not all queries running on the server. The perl script kill all queries - which are been running from for last 120(or any threshold set) Issues: How do I get the PID of my last select query ran from the web query interface..?? Any php function..?No, there isn't. show processlist; should give you some info. It won't give you the whole query, only the start of it. -- Postgresql & php tutorials http://www.designmagick.com/