CODEWITHSUNDEEP
javamysqlperformance
Vilius
Vilius

Reputation: 1189

java mysql server getting slower

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!

Upvotes: 0

Views: 170

Answers (1)

Swaranga Sarma
Swaranga Sarma

Reputation: 13393

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?

Upvotes: 2

Related Questions