i'd post in the java section but that seems to be a pretty dead section.. anyways
i use my own code for JDBC execution so it doesn't exist anywhere else. anyway, after a few hours memory usage for MySQL/JDBC spikes to 100mb+ and slowly rises.. ;-;
I use PreparedStatements, I clear them after I execute them, and I close them, too, including any queries I do with ResultSets..
anything I'm missing? this is the general block of code executed for inserting:
Code:
final PreparedStatement p = con.prepareStatement("INSERT INTO `bans` SET `trigger` = ? -- etc...");
p.setString(1, "lols");
p.executeUpdate();
p.clearParameters();
p.close();
if you want examples of how other things are done, just ask..
also queries are executed very often, so it adds up quite fast.. I will try some things in the next few minutes to get code that rapidly reproduces the leak.