Mysql 5.5 - Prepared Statement instance count runaway (millions)

Erny

New Member
If anyone has experienced this or has any ideas it would be greatly appreciated...I'll get right to the point:The system in question uses java6, tomcat6 and ibatisSince upgrading the database from Mysql5.1 to Mysql5.5 the system has become unstable.Upon looking at jmap histo and analyzing memory dumps with jhat it is clear that the problem has to do with the JDBC side of the app.The system does on average 3,000 selects/inserts/updates per second and it its busiest time of the day the Prepared Statement instance count is between 10 and 30. The highest count we've seen during normal operation is just over 50.Whats weird is that there is no pattern to the crashes, the system has crashed multiple times in the space of an hour and other times days could pass between crashes.The highest instance count observed during the crash was over 5 million.Here is some jhat data for JDBC4PreparedStatement from one of the memory dumpsThis dump was taken as we picked up the start of the crash (only 200k instances at this point)
J9Ryo.gif
 
Back
Top