18 messages in org.apache.logging.log4j-userRe: [log4j] FW: Database Logging Perf...
FromSent OnAttachments
Vernier, Dominique (DVernier)Jun 14, 2004 5:05 am 
Ceki GülcüJun 14, 2004 5:14 am 
Vernier, Dominique (DVernier)Jun 14, 2004 5:16 am 
Ceki GülcüJun 14, 2004 5:30 am 
poojaJun 14, 2004 6:19 am 
Vernier, Dominique (DVernier)Jun 14, 2004 11:18 am 
Ceki GülcüJun 14, 2004 11:26 am 
Vernier, Dominique (DVernier)Jun 14, 2004 11:52 am 
mrut...@westpac.com.auJun 15, 2004 4:24 pm 
mrut...@westpac.com.auJun 15, 2004 4:24 pm 
poojaJun 18, 2004 12:31 am 
Andreas GutherJun 18, 2004 5:27 am 
Thomas SvensenJun 18, 2004 5:37 am 
Ceki GülcüJun 18, 2004 6:02 am 
NimaJun 18, 2004 9:50 am 
Andreas GutherJun 22, 2004 7:21 pm 
Ceki GülcüJun 23, 2004 7:41 am 
Andreas GutherJun 24, 2004 4:32 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [log4j] FW: Database Logging Performance NumbersActions...
From:Andreas Guther (andr@guther.com)
Date:Jun 22, 2004 7:21:25 pm
List:org.apache.logging.log4j-user

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,

--------------------------------------------------------------------- To unsubscribe, e-mail: log4@logging.apache.org For additional commands, e-mail: log4@logging.apache.org