How to: Include identifier with a query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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]

  Powered by Linux