Fwd: MySQL Query Timeout program in PHP

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

 



---------- Forwarded message ----------
From: Piyush Kumar <piykumar@xxxxxxxxx>
Date: Thu, Oct 16, 2008 at 9:09 AM
Subject: Re:  MySQL Query Timeout program in PHP
To: Chris <dmagick@xxxxxxxxx>


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

Thanks
Piyush

On Thu, Oct 16, 2008 at 7:35 AM, Chris <dmagick@xxxxxxxxx> wrote:
> Piyush Kumar wrote:
>>
>> I'm using http://myclient.polarlava.com/ as web query interface for mysql
>> server
>>
>> Now I want to add "Query Timeout" functionality to it
>>
>> For that I need to get the PID for last ran mysql query and then using
>> kill
>> PID - I can kill the process on MySQL server
>>
>> Please explain how to do that in PHP Thanks!
>>
>> Similar to what described @ http://bytes.com/forum/thread156058.html
>
> Learn some php and convert the perl script?
>
> What area are you having issues with exactly?
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>



--
Thanks & Regards,
-Piyush
Mo.: 091-9910904233
Mail: piykumar@xxxxxxxxx
Web: http://piyush.me/

-In a world without fences, limits, boundaries and walls, Who needs
Windows and Gates?



-- 
Thanks & Regards,
-Piyush
Mo.: 091-9910904233
Mail: piykumar@xxxxxxxxx
Web: http://piyush.me/

-In a world without fences, limits, boundaries and walls, Who needs
Windows and Gates?

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux