A: 

What is your 'max_connections' setting (show variables like '%max_connections%') and how many connections are currently 'live' on the server (show processlist)?

I'm guessing it's set very low (1 or 2) and between tomcat and your monitor connections you're exceeding the limit.

Raising it would be done via the mysql.ini/mysql.cnf file, wherever it's kept on Windows.

Marc B  2010-03-30 19:28:33
Hi Marc, max_connections is set to 100 and there is only one process running.Its not just tomcat, any mysql client that tries to connect to MySql goes into wait state unless I disconnect the 1st one.I have checked it by starting the MySql service again, disabling the firewall but no luck.
Hussain  2010-03-31 03:42:21
A: 

Are you connecting over the network? or a local file socket? You may be locking on the windows equivalent of mysql.sock - not sure if that behavior changed in Win7. Something like:

mysql -u root -h localhost -p 3306

and make sure that my.ini/my.cnf have networking enabled

jayshao  2010-04-01 00:53:38
Everything is on my laptop i.e. local machine .. can you suggest how can I verify locking ? ... as you see "show processlist" show one connection is sleep state there is no lock state.
Hussain  2010-04-01 03:50:04
Edited with an example - this is using the commandline, though I apologize, I don't have a Windows box in front of me.
jayshao  2010-04-02 02:58:27
I have edited my question with result of the command you specified. Please check and thanks a lot for helping.
Hussain  2010-04-02 06:22:02
A: 

After too many re installation of Windows I guess i have identified the root cause ... On every fresh installation MySql use to work fine but after a while I use to get stuck with this issue.

The cause was my voip messenger "Wizton" after installing it MySql work fine but when i restart my machine ... same Connection issue.

But wizton was working perfectly fine with Vista Business .. don't no what happens in Windows 7.

Hussain  2010-04-12 13:02:28

related questions

Remove Quotes and Commas from a String in MySQL
What's the best way of converting a mysql database to a sqlite one?
How do you manage databases in development, test, and production?
Multiple foreign keys?
Add 1 to a field (MySQL)
Issues using MS Access as a front-end to a MySQL database back-end?
Bigger than a char but smaller than a blob
How do I retrieve my MySQL username and password?
Long-time LAMP Developer moving to VB.NET
How do I Concatenate entire result sets in MySQL?
Full complete MySQL database replication? Ideas? What do people do?
SQL: Distribution of table in time
SQLite vs MySQL
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Multiple Updates in MySQL
MySQL/Apache Error in PHP MySQL query
What all do I need to escape when sending a (My)SQL query?
Auto Generate Database Diagram MySQL
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
Python and MySQL
SQL Server 2005 implementation of MySQL REPLACE INTO?
How to export data from SQL Server 2005 to MySQL
Throw Error In MySQL Trigger
Binary Data in MySQL