Is there a way to monitor the number connections to a
table from a user? Occassionally what happens is that the
mysql db won't let me connect cos it thinks i have too
connections open which i don't (well, i don't think so
atleast).
One way described by Dawn Lockhart:
the only easy way i know of is to set up query logging on
the mysql server. the query log will contain all
connections/disconnections as well as all queries. it can
tell you a lot about what is going on but it may slow down
the server a bit. good for testing but not for production.
I haven't tried it yet, but it sounds like alot of log trawling. Are
there any other ways?
2 messages in com.mysql.lists.javaIs there a way to monitor the connect...