logback 使用mysql 性能差_logback日志写入mysql自定义表(根据日志的级别分别存入不同的数据库中)...

最新推荐文章于 2023-06-16 00:41:52 发布

設計師·Rainbow

最新推荐文章于 2023-06-16 00:41:52 发布

阅读量363

点赞数

文章标签： logback 使用mysql 性能差

本文链接：https://blog.csdn.net/weixin_33417371/article/details/113273764

版权

细节看上一篇

1，先看 DBAppender

package com.liudandan.logbackmysql.controller.config;

import ch.qos.logback.classic.db.names.DBNameResolver;

import ch.qos.logback.classic.db.names.DefaultDBNameResolver;

import ch.qos.logback.classic.spi.*;

import com.liudandan.logbackmysql.controller.MyDBAppenderBase;

import com.liudandan.logbackmysql.controller.buildInsertSQL;

import java.lang.reflect.Method;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.Timestamp;

public class DBAppender extends MyDBAppenderBase {

private String insertSQL;

private static final Method GET_GENERATED_KEYS_METHOD;

private DBNameResolver dbNameResolver;

protected String insertDebugSQL;

protected String insertErrorSQL;

protected String insertInfoSQL;

private static final int TIME_INDEX = 1;

private static final int MESSAGE_INDEX = 2;

private static final int LEVEL_STRING_INDEX = 3;

private static final int LOGGER_NAME_INDEX = 4;

private static final int THREAD_NAME_INDEX = 5;

private static final int CALLER_FILENAME_INDEX = 6;

private static final int CALLER_CLASS_INDEX = 7;

private static final int CALLER_METHOD_INDEX = 8;

private static final int CALLER_LINE_INDEX = 9;

private static final int ORG_ID_INDEX = 10;

private static final StackTraceElement EMPTY_CALLER_DATA = CallerData.naInstance();

static {

// PreparedStatement.getGeneratedKeys() method was added in JDK 1.4

Method getGeneratedKeysMethod;

try {

// the

getGeneratedKeysMethod = PreparedStatement.class.getMethod("getGeneratedKeys", (Class[]) null);

} catch (Exception ex) {

getGeneratedKeysMethod = null;

}

GET_GENERATED_KEYS_METHOD = getGeneratedKeysMethod;

}

// @Override

// public void start() {

// insertSQL = buildInsertSQL();

// super.start();

// }

@Override

public void start() {

if (dbNameResolver == null)

dbNameResolver = new DefaultDBNameResolver();

insertDebugSQL = buildInsertSQL.buildInsertDebugSQL(dbNameResolver);

insertErrorSQL = buildInsertSQL.buildInsertErrorSQL(dbNameResolver);

insertInfoSQL = buildInsertSQL.buildInsertInfoSQL(dbNameResolver);

// insertSQL = buildInsertSQL.buildInsertSQL();

super.start();

}

private static String buildInsertSQL() {

return "INSERT INTO log_record " +

"(time, message, logger_name, level_string, thread_name," +

"caller_filename, caller_class, caller_method, caller_line, org_id)"+

"VALUES (?, ?, ? ,?, ?, ?, ?, ?, ?, ?)";

}

private void bindLoggingEventWithInsertStatement(PreparedStatement stmt, ILoggingEvent event) throws SQLException {

stmt.setTimestamp(TIME_INDEX, new Timestamp(event.getTimeStamp()));

stmt.setString(MESSAGE_INDEX, event.getFormattedMessage());

stmt.setString(LEVEL_STRING_INDEX, event.getLevel().toString());

stmt.setString(LOGGER_NAME_INDEX, event.getLoggerName());

stmt.setString(THREAD_NAME_INDEX, event.getThreadName());

stmt.setString(ORG_ID_INDEX, String.valueOf(12));

}

private void bindCallerDataWithPreparedStatement(PreparedStatement stmt, StackTraceElement[] callerDataArray) throws SQLException {

StackTraceElement caller = extractFirstCaller(callerDataArray);

stmt.setString(CALLER_FILENAME_INDEX, caller.getFileName());

stmt.setString(CALLER_CLASS_INDEX, caller.getClassName());

stmt.setString(CALLER_METHOD_INDEX, caller.getMethodName());

stmt.setString(CALLER_LINE_INDEX, Integer.toString(caller.getLineNumber()));

// stmt.setString(ORG_ID_INDEX, String.valueOf(12));

}

//2

@Override

protected void subAppend(ILoggingEvent event, Connection connection, PreparedStatement insertStatement) throws Throwable {

bindLoggingEventWithInsertStatement(insertStatement, event);

// This is expensive... should we do it every time?

bindCallerDataWithPreparedStatement(insertStatement, event.getCallerData());

int updateCount = insertStatement.executeUpdate();

if (updateCount != 1) {

addWarn("Failed to insert loggingEvent");

}

@Override

protected void secondarySubAppend(ILoggingEvent eventObject, Connection connection, long eventId) throws Throwable {

}

//3

private StackTraceElement extractFirstCaller(StackTraceElement[] callerDataArray) {

StackTraceElement caller = EMPTY_CALLER_DATA;

if (hasAtLeastOneNonNullElement(callerDataArray))

caller = callerDataArray[0];

return caller;

}

private boolean hasAtLeastOneNonNullElement(StackTraceElement[] callerDataArray) {

return callerDataArray != null && callerDataArray.length > 0 && callerDataArray[0] != null;

}

@Override

protected Method getGeneratedKeysMethod() {

return GET_GENERATED_KEYS_METHOD;

}

//第一步

// @Override

// protected String getInsertSQL() {

// return insertDebugSQL;

// }

protected String getInsertErrorSQL() {

return insertErrorSQL;

}

protected String getInsertInfoSQL() {

return insertInfoSQL;

}

protected String getInsertDebugSQL() {

return insertDebugSQL;

}

2，

buildInsertSQL 重写

package com.liudandan.logbackmysql.controller;

import ch.qos.logback.classic.db.names.DBNameResolver;

import com.liudandan.logbackmysql.controller.config.ColumnNames;

import com.liudandan.logbackmysql.controller.config.TableName;

public class buildInsertSQL {

// public static String buildInsertSQL() {

// return "INSERT INTO log_record " +

// "(time, message, level_string, logger_name, thread_name," +

// "caller_filename, caller_class, caller_method, caller_line,org_id)" +

// "VALUES (?, ?, ? ,?, ?, ?, ?, ?, ?, ?)";

// }

public static String buildInsertDebugSQL(DBNameResolver dbNameResolver) {

StringBuilder sqlBuilder = new StringBuilder("INSERT INTO ");

sqlBuilder.append(dbNameResolver.getTableName(TableName.LOG_DEBUG)).append(" (");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.TIME)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.MESSAGE)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.LEVEL_STRING)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.LOGGER_NAME)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.THREAD_NAME)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.CALLER_FILENAME)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.CALLER_CLASS)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.CALLER_METHOD)).append(", ");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.CALLER_LINE)).append(",");

sqlBuilder.append(dbNameResolver.getColumnName(ColumnNames.ORG_ID)).append(") ");

sqlBuilder.append("VALUES (?, ?, ? ,?, ?, ?, ?, ?, ?, ?)");

return sqlBuilder.toString();

}

public static String buildInsertErrorSQL(DBNameResolver dbNameResolver) {

StringBuilder sqlBuilder = new StringBuilder("INSERT INTO ");

sqlBuilder.append(dbNameResolver.getTableName(TableName.LOG_ERROR)).append(" (");