 | Start a set with this search |
 | Include this search in one of my sets |
 | Exclude this search from one of my sets |
 | Permalink to these results Paste this link in email or IM: |
 | Atom feed for tracking future search results Paste this URL into your reader: |
18 messages in org.apache.logging.log4j-userRe: [log4j] FW: Database Logging Perf...| From | Sent On | Attachments |
|---|---|---|
| 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 | |
| pooja | Jun 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.au | Jun 15, 2004 4:24 pm | |
| mrut...@westpac.com.au | Jun 15, 2004 4:24 pm | |
| pooja | Jun 18, 2004 12:31 am | |
| Andreas Guther | Jun 18, 2004 5:27 am | |
| Thomas Svensen | Jun 18, 2004 5:37 am | |
| Ceki Gülcü | Jun 18, 2004 6:02 am | |
| Nima | Jun 18, 2004 9:50 am | |
| Andreas Guther | Jun 22, 2004 7:21 pm | |
| Ceki Gülcü | Jun 23, 2004 7:41 am | |
| Andreas Guther | Jun 24, 2004 4:32 am |
| Permalink for this message Paste this link in email or IM: |
| Permalink for this thread 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 Numbers | Actions... |
|---|---|---|
| From: | Ceki Gülcü (ce...@qos.ch) | |
| Date: | Jun 18, 2004 6:02:00 am | |
| List: | org.apache.logging.log4j-user | |
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,
At 02:27 PM 6/18/2004, you wrote:
I am also interested in that kind of information. I also started recently looking into logging into tables and would be interested in some performance results and experience reports in high volume environments.
Andreas
pooja wrote:
Hi All I haven't received a response on this issue. Can someone at Log4j answer it for me? Thanx --- Pooja.
-----Original Message----- From: pooja [mailto:poo...@induslogic.com] Sent: Monday, June 14, 2004 6:50 PM To: 'Log4J Users List' Subject: Database Logging Performance Numbers
Hello I am looking for some performance numbers for Database Logging. I want to be able to analyze/query my log records at a later date in multiple of ways. Hence Logging into database seems to be the perfect choice. But the system is a transactional system and it will be handling more than a million transactions a day. Hence making it necessary, that I first prove that Logging into Database will not hamper performance. Can someone provide some published numbers?
I will be fine with test cases as well; I'll run them against the current file logging system and get comparative figures. Currently, I am writing some crude test cases of my own. At the same time, if neone knows of some application (which handles so many transactions) already writing logs into database & functioning, this reference will suffice my job. Thanx --- Pooja.
-- Ceki Gülcü
For log4j documentation consider "The complete log4j manual" ISBN: 2970036908 http://www.qos.ch/shop/products/clm_t.jsp