Re: Memory leak with c3p0 using ConnectionProperties
Achim Abeling <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
Hi Mark, Mark Matthews wrote: > > Achim, > > Adding "profileSQL=true" to your URL causes the driver to log _every_ > query to System.err, or another defined logger, so depending on how your > logging is setup, that could be filling a lot of memory due to how your > logging system buffers things. I am using log4j and the MySQL driver seems to log automatically to the log4j logger "MySQL" in this case. The problem occurs even if I set the loglevel for this logger to ERROR, so nothing is logged. But the fact remains that the number of com.mysql.jdbc.Connection objects in the heap is increasing. It is not the logging system that takes the memory. BTW: I thought the problem would occur with any property setting in the JDBC url but it seems to arise only with "profileSQL". > > "profileSQL" is not designed to be used in a production setting, is > there a reason you're running it in this manner? > No. I will remove it. -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]