Re: MySQL Monitor and Percona

2012-10-26 Thread Laurynas Biveinis
2012/10/25 Sabika M : > 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 beco

RE: MySQL Monitor and Percona

2012-10-25 Thread Rick James
, 2012 4:15 PM To: Rick James Cc: mysql@lists.mysql.com 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. | 1

Re: MySQL Monitor and Percona

2012-10-25 Thread Sabika M
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 |

RE: MySQL Monitor and Percona

2012-10-25 Thread Rick James
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.makhd...@gmail.com] > Sent: Thursday, October 25, 2012 11:44 AM > To: mysql@lists.mysql.com > Subject: MySQL Monitor and Perc