Andreas,
Since you asked, I am talking about a specialized version of DBAppender
which I have *not* published because it uses advanced JDBC features
unavailable on most JDBC drivers. Actually, it is supposed to work only
with the most recent version of the MySQL JDBC connector. (On older JDBC
connectors there were problems.) The idea is to buffer the events and spit
them out in batches. This results in a huge boost in performance. However,
I currently do not have the time to consolidate the code as there are much
more urgent items on my to do list.
At 04:21 AM 6/23/2004, Andreas Guther wrote:
Ceki:
Is this a specific (MySQL) DBAppender you are talking about?
Andreas
Ceki Gülcü wrote:
My tests with DBAppender show that using pooled connections, it takes
about 10 milliseconds to insert an event into a MySQL DB (of type
*INNODB*) running locally. It still takes approx. 10 millis logging to a
PostgreSQL DB running on a relatively old and slow Linux server (with
pooled connections).
DBAppender is completely DB agnostic. It will run on all RDBMMSs. An
optimized version of DBAppender (but which is MySQL-only) logs at 500
*microseconds* per event.
HTH,
--
Ceki Gülcü
For log4j documentation consider "The complete log4j manual"
ISBN: 2970036908 http://www.qos.ch/shop/products/clm_t.jsp
18 messages in org.apache.logging.log4j-userRe: [log4j] FW: Database Logging Perf...
