I looked into this years ago for something I was doing, but don't remember 
looking for a solution in MySQL.

Just wanted to share that.. um.. I think it was with MS SQL Server.. there 
was a way to put a tag in your DSN connection string that would show up 
on the process list.  I don't know if that helps, but just to add to the 
list of "how *some* people do it".

Good luck!

-TG

----- Original Message -----
From: listread <listr...@cze.com>
To: php-db@lists.php.net
Date: Mon, 02 Nov 2009 07:16:23 -0600
Subject: [PHP-DB] How to: Include identifier with a query

> 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
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to