…. That is the port number of the TCP connection that’s to blame for causing…`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist‘ > /root/tcpdumps/`date +%s`-innodbstatus pid=$! sleep 30 kill …! The greater moral of this story is — InnoDB is designed for lots of short, small transactions…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…PROCESSLIST monitoring. This allows you to crack down on users which cause a lot of load which causes a lot of unintentional abusers, but to get MySQL in trouble you do not need a lot of…connect to MySQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…lot of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of…connection, or ACTIVE if transaction is active. Note transaction can be active even if connection is in “Sleep…visible in SHOW PROCESSLIST showed in …
Post: Living with backups
November 6, 2008 By 28 Comments
… or reading a lot of data when copying physical…sleep(1); } What this script does is to check MySQL status every second and in case the number of connected…of course different for every MySQL instance, these are just examples. The cheks can also be more sphisticated or include things like processlist…
Comment: Using MyISAM in production
June 20, 2006 By 35 Comments
… through performance forum on MySQL site It is a great blog with lot of good information. We … nothing resulting in large number of db connections Once MySQL unfreezes, all of threads complete and everything is … show processlist and don’t see any thing happening as most fo processes are SLEEP mode …
