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

RE: mysql TIME_WAIT

After a TCP connection has been closed, the state changes to TIME_WAIT. If I recall correctly, this is a way to prevent the same port from being immediately reused, and allow any duplicate packets from the previous connection that might still be floating around the network time to expire. In genera

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: Insert data in one table from Another Problem

Here's one option to "pivot" your results: select record_id ,max(soi) as soi ,max(heading) as heading ,max(description) as description ,max(relloc) as relloc from (select record_id ,if(field_name = 'SOI', field_value, '') as soi ,if(field_name = 'Heading', field_va

Benetl a free ETL tool using MySQL is out in version 3.7

Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.7. You can freely download it at: www.benetl.net This version brings new controls and messages in the GUI. This version brings improvements and a bug correction in GUI. You should update. You can learn more about ETL

Need to remove and reinstall, which files/folders?

I have a customized (i.e.: bugs fixed by a programer) instance of MySQL 5.1 on my Intel Macintosh running OS 10.6.6. MySQL stopped running after upgrading to 10.6 from 10.5. It seems that I should remove 5.1 and re-install 5.5. Is there a complete list of files and folders available to tell me w

Design question.

I maintain a little open source project that deals with IDS alert data. I want to add IP reputation to my event queries and I am stuck on how I should implement it. The user will have the option of bringing in lists from different providers and the limit will not be fixed. These lists will be a si