Fwd: [PHP-DB] MySQL Query Timeout program in PHP

---------- Forwarded message ---------- From: Piyush Kumar <piykumar@gmail.com> Date: Thu, Oct 16, 2008 at 9:09 AM Subject: Re: [PHP-DB] MySQL Query Timeout program in PHP To: Chris <dmagick@gmail.com> 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@gmail.com> 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@gmail.com 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@gmail.com Web: http://piyush.me/ -In a world without fences, limits, boundaries and walls, Who needs Windows and Gates?