Re: Question about performance

Or you can interrupt the query instead, although I've seen it not to work on occasions: KILL QUERY id; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Question about performance

I am working with mysql since many yaers and i have never found e reason to kill braindead connections - what benefit do you think to have from such actions instead looking why there are hanging ones? kill a connection of postfix and some user gets "temorary lookup error", php-scripts are closing

Re: Question about performance

Rafael, You realize that script will kill perfectly well-behaved queries in mid-flight? If you have so many dead connections that it is interfering with operation, you have another problem elsewhere.. - md On Thu, Feb 17, 2011 at 4:16 PM, Rafael Valenzuela wrote: > Hi Michael: > > Yeah , i t

Re: Question about performance

Hi Michael: Yeah , i think that i do a shell script.something like that. require 'mysql' mysql = Mysql.new(ip, user, pass) processlist = mysql.query("show full processlist") killed = 0 processlist.each { | process | mysql.query("KILL #{process[0].to_i}") } puts

Re: Question about performance

from the mysql console: > show processlist this will show you ids of all active connections, even the dead ones then, again form the console > kill On Thu, Feb 17, 2011 at 3:52 PM, Rafael Valenzuela wrote: > Hi all; > I wonder if there is any tool to Performance Tuning querys. In other know i

Question about performance

Hi all; I wonder if there is any tool to Performance Tuning querys. In other know if there is any way to kill connections that take x hours dead (for example 1 hour) -- Mit forever My Blog My Faborite Web

Re: Re:pulling audio out of a blob and playing it. => just a question about performance

Just since the subject was brought up... Im going to relseas Lucas Web Server V2.0 in a few weeks, it stores everything (htmlfiles, images etc) in the DB. To add to the adv/dis list: Advantages --- Content management (for communites and larg corp) Dis -- Content magangment (for ot

Re:pulling audio out of a blob and playing it. => just a question about performance

Hi Just a question. What about performance when storing audio files in a blob. What effect does it have on the database(load, space requirements compared to audio files,...) I will be confronted with this question in the near future where I will have to decide to store on disk or in blob. I you ha