How to: Include identifier with a query
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: php-db@xxxxxxxxxxxxx
- Subject: How to: Include identifier with a query
- From: listread <listread@xxxxxxx>
- Date: Mon, 02 Nov 2009 07:16:23 -0600
- User-agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.22) Gecko/20090605 SeaMonkey/1.1.17
Greetings!
We are searching for names that might or might not exist in a 4 million
row db and have to do a lot of fuzzy searches that often don't return
results.
I would like the use to have the option of killing a query process.
Since we are apt to have several queries running KILL QUERY doesn't seem
to work. I would like to use KILL (process id) instead. We can use
SHOW FULL PROCESSLIST to get a complete list of the processes, but we
need for the code to identify which one to kill.
Here's the question: How can I "flag" a particular query so it can be
identified from the array SHOW FULL PROCESSLIST generates?
Thanks!
- Ron
[Index of Archives]
[PHP Home]
[PHP Users]
[Postgresql Discussion]
[Kernel Newbies]
[Postgresql]
[Yosemite News]