From: Rick James Date: October 25 2012 11:27pm Subject: RE: MySQL Monitor and Percona List-Archive: http://lists.mysql.com/mysql/228495 Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1490E79E98@SP2-EX07VS01.ds.corp.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_000_2E7DD7ADE53B044C8C8BCD9C5829E1EB1490E79E98SP2EX07VS01ds_" --_000_2E7DD7ADE53B044C8C8BCD9C5829E1EB1490E79E98SP2EX07VS01ds_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable A guess -- MEM is issuing that on a timed basis, but the query is running l= onger than the time period. Can you slow MEM down? Meanwhile, file a bug report. You paid too much money for this kind of jun= ior mistake. From: Sabika M [mailto:sabika.makhdoom@stripped] Sent: Thursday, October 25, 2012 4:15 PM To: Rick James Cc: mysql@stripped Subject: Re: MySQL Monitor and Percona I don't have the full anymore. It had a few hundred of these. I had issues = a drop database that hung which made me run show processlist. Sadly, I did = not check the processlist beforehand. | 101189 | monitor | localhost:42585 | NULL | Query | 4079 | NULL = | SHOW /*!50000 ENGINE */ INNODB STATUS |= 0 | 0 | 1 | | 101194 | monitor | localhost:42589 | NULL | Query | 4069 | NULL = | SHOW /*!50000 ENGINE */ INNODB STATUS |= 0 | 0 | 1 | | 101204 | monitor | localhost:42599 | NULL | Query | 4049 | executi= ng | SHOW /*!50000 GLOBAL */ STATUS |= 0 | 0 | 1 | | 101214 | monitor | localhost:42608 | NULL | Query | 4029 | executi= ng | SHOW /*!50000 GLOBAL */ STATUS |= 0 | 0 | 1 | wait_timeout | 28800 max_connections | 5000 Since I sent this email, we have checked network connectivity and fixed a t= ypo in the hostname. On Thu, Oct 25, 2012 at 1:56 PM, Rick James > wrote: What does SHOW FULL PROCESSLIST say? What values do you have for max_connections wait_timeout (GLOBAL version) > -----Original Message----- > From: Sabika M [mailto:sabika.makhdoom@stripped] > Sent: Thursday, October 25, 2012 11:44 AM > To: mysql@stripped > Subject: MySQL Monitor and Percona > > We are in the process of switching to percona binaries of MySQL . I am > using Percona 5.5.27 and monitoring the MySQL server with the MySQL > Enterprise monitor. It starts up fine, but after a while I end up with > MySQL monitor connections stacking up until the server becomes pretty > much useless. This happens only on servers running percona. Anyone else > have this issue? Or heard of it? Anything helps! --_000_2E7DD7ADE53B044C8C8BCD9C5829E1EB1490E79E98SP2EX07VS01ds_--