java mysql server getting slower

Question

I manage my connections by JDBC connection pool (BoneCP) and I always close the connection, the preparedStatement und the ResultSet.

But, when my programm is running for several days, the mysql-server gets slower and slower (for testing, I let my programm insert an entry every second). After 2 days, there were several seconds between the entries and that is why I think that the mysql server is getting slower and can handle the incomming transaction. Am I right?

The mysql server also uses much more of RAM and does not release the resources. So does anyone know, how I could find the error causing this behaviour? Thanks in advice!

Swaranga Sarma · Accepted Answer · 2011-06-12 11:17:08Z

2

Use the MySQL Workbench to detect open connections. It also gives you a host of options to see performance of your database server.

Also [I might be mistaken about this part of your question], when you say

I use connection pooling

why do you close the connection? Isn't that the opposite of the purpose of connection pooling?

answered Jun 12, 2011 at 11:17

Swaranga Sarma

13.5k19 gold badges64 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vilius Over a year ago

You don't really close the connection, when you use a connection pool - the function close() gets a whole new meaning, where the connection is not physically closed, but just released for further use. Thanks for suggesting to use workbench - I will try to debug with this tool :)

Collectives™ on Stack Overflow

java mysql server getting slower

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related