[logback-dev] [JIRA] Issue Comment Edited: (LBCLASSIC-169) Customizing table names used by DbAppender

Rü (JIRA) noreply-jira at qos.ch
Thu Feb 25 09:44:16 CET 2010


    [ http://jira.qos.ch/browse/LBCLASSIC-169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=11570#action_11570 ] 

Rü edited comment on LBCLASSIC-169 at 2/25/10 9:43 AM:
-------------------------------------------------------

I actually have written a new database appender normalizing all the entities that are quite static: Level, Logger, and Marker.

I've put the message and the arguments into separate columns, although that is not 100% clean, as I can now only store up to a fixed number of arguments (8 right now), which I currently consider a reasonable compromise.

I additionally normalized a session entity wich consists of the Thread name and the MDC... these don't change for a lot of log messages and it's nicer to have them all together. Some special MDC values (node, slot, version, client, and reference) are stored into separate columns, the rest is stored into a map.

This is not in production use, yet, and I haven't measured the space and performance impact, but I think it could very well use just half the space on disk... which would mean several gigs per day in our environment.

Anyone interested?!?

      was (Author: rd):
    I actually have written a new database appender normalizing all the entities that are quite static: Level, Logger, and Marker.

I've put the message and the arguments into separate columns, although that is not 100% clean, as I can now only store up to a fixed number of arguments (8 right now), which I currently consider a reasonable compromise.

I additionally normalized a session entity wich consists of the Thread name and the MDC... these don't change for a lot of log messages and it's nicer to have them all together. Some special MDC values (node, slot, version, client, and reference) are stored into separate columns, the rest is stored into a map.

Anyone interested?!?
  
> Customizing table names used by DbAppender
> ------------------------------------------
>
>                 Key: LBCLASSIC-169
>                 URL: http://jira.qos.ch/browse/LBCLASSIC-169
>             Project: logback-classic
>          Issue Type: Improvement
>          Components: appender
>    Affects Versions: 0.9.18
>            Reporter: Tomasz Nurkiewicz
>            Assignee: Ceki Gulcu
>            Priority: Minor
>
> ch.qos.logback.classic.db.DBAppender uses hard-coded table names for logging events: logging_event, logging_event_property and logging_event_exception. Allowing to change these default names has two benefits:
> * There are systems where database table names must follow some naming conventions (prefixes, using underscores vs. camel case)
> * One could create several Db appenders, each operating on different set of tables (for performance reasons or more fine grained logging and filtering)
> Each table name would be configured using a property in logback.xml. Default values for table names would be the same as present ones to maintain backward compatibility. If you are interested in this feature let me know, I can implement it and provide a patch.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.qos.ch/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       


More information about the logback-dev mailing list