A guess -- MEM is issuing that on a timed basis, but the query is running longer than the
time period. Can you slow MEM down?
Meanwhile, file a bug report. You paid too much money for this kind of junior 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 | executing
| SHOW /*!50000 GLOBAL */ STATUS | 0 | 0 |
1 |
| 101214 | monitor | localhost:42608 | NULL | Query | 4029 | executing
| 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 typo in the
hostname.
On Thu, Oct 25, 2012 at 1:56 PM, Rick James
<rjames@stripped<mailto:rjames@stripped>> 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<mailto:sabika.makhdoom@stripped>]
> Sent: Thursday, October 25, 2012 11:44 AM
> To: mysql@stripped<mailto: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!
