Fwd: [PHP-DB] MySQL Query Timeout program in PHP
-- Forwarded message -- From: Piyush Kumar <[EMAIL PROTECTED]> Date: Thu, Oct 16, 2008 at 9:09 AM Subject: Re: [PHP-DB] MySQL Query Timeout program in PHP To: Chris <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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
Re: [PHP-DB] MySQL Query Timeout program in PHP
Man- when the query is fired through the web interface- it rans on mysql server max_execution_time - wont' help evn I stop apache itself... The query runs on mysql server - so I have to kill the PID on server itself... Thanks Piyush On Thu, Oct 16, 2008 at 7:57 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > Just put the time out in your PHP.INI file > > max_execution_time = 30 ; Maximum execution time of each script, in > seconds > > 2008/10/16 Piyush Kumar <[EMAIL PROTECTED]> >> >> 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 >> >> >> -- >> Thanks & Regards, >> -Piyush >> Mo.: 091-9910904233 >> Mail: [EMAIL PROTECTED] >> 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 >> > > > > -- > J.A. van Zanen > -- Thanks & Regards, -Piyush Mo.: 091-9910904233 Mail: [EMAIL PROTECTED] 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
[PHP-DB] MySQL Query Timeout program in PHP
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 -- Thanks & Regards, -Piyush Mo.: 091-9910904233 Mail: [EMAIL PROTECTED] 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