配置mysql日志打印

# 配置sql打印日志
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
logging:
  level:
    root: info
com.***.telemarket.mapper: trace

引入jar包并配置resources下的logback-spring.xml文件如下


<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<!--获取podIp-->
<conversionRule conversionWord="ip" converterClass="com.***.telemarket.commons.convert.IpConvert"/>
    <springProperty scope="context" name="profile" source="spring.profiles.active"/>
    <springProperty scope="context" name="applicationName" source="spring.application.name"/>
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>
    <appender name="KAFKAAPPENDER" class="com.***.vcs.framework.logback.KafkaAppender">
        <encoder class="net.logstash.logback.encoder.LoggingEventCompositeJsonEncoder">
            <providers>
                <timestamp/>
                <pattern>
                    <pattern>
{
                        "severity": "%level",
                        "project":"cms-ccc",
                        "profile":"${profile:-}",
                        "service": "${applicationName:-}",
                        "trace": "%X{X-B3-TraceId:-}",
                        "span": "%X{X-B3-SpanId:-}",
                        "parent": "%X{X-B3-ParentSpanId:-}",
                        "exportable": "%X{X-Span-Export:-}",
                        "pid": "${PID:-}",
                        "thread": "%thread",
                        "class": "%logger{40}",
                        "rest": "%message",
                        "stack_trace": "%exception{10}",
                        "ip": "%ip"
                        }
                    </pattern>
                </pattern>
            </providers>
        </encoder>
        <topic>cms-ccc</topic>
        <producerConfig>acks=0</producerConfig>
        <producerConfig>max.block.ms=0</producerConfig>
        <springProfile name="!prod,!js-prod">
            <producerConfig>bootstrap.servers=kafka-t1.***.com.local:9092,kafka-t2.***.com.local:9092,kafka-t3.***.com.local:9092</producerConfig>
        </springProfile>
        <springProfile name="prod,js-prod">
            <producerConfig>bootstrap.servers=kafkalog-1.***.com.local:9092,kafkalog-2.***.com.local:9092,kafkalog-3.***.com.local:9092,kafkalog-4.***.com.local:9092,kafkalog-5.***.com.local:9092</producerConfig>
        </springProfile>
    </appender>
<!--    <appender name="ASYNC_CONSOLE"-->
<!--              class="ch.qos.logback.classic.AsyncAppender">-->
<!--        <discardingThreshold>0</discardingThreshold> &lt;!&ndash; default 20, means drop lower event when has 20% capacity remaining &ndash;&gt;-->
<!--        <appender-ref ref="STDOUT" />-->
<!--        <queueSize>512</queueSize> &lt;!&ndash; default 256 &ndash;&gt;-->
<!--        <includeCallerData>false</includeCallerData>&lt;!&ndash; default false &ndash;&gt;-->
<!--        <neverBlock>true</neverBlock>&lt;!&ndash; default false, set to true to cause the-->
<!--            Appender not block the application and just drop the messages &ndash;&gt;-->
<!--    </appender>-->
<!--    <appender name="ASYNC_KAFKA"-->
<!--              class="ch.qos.logback.classic.AsyncAppender">-->
<!--        <discardingThreshold>0</discardingThreshold> &lt;!&ndash; default 20, means drop lower event when has 20% capacity remaining &ndash;&gt;-->
<!--        <appender-ref ref="KAFKAAPPENDER" />-->
<!--        <queueSize>512</queueSize> &lt;!&ndash; default 256 &ndash;&gt;-->
<!--        <includeCallerData>false</includeCallerData>&lt;!&ndash; default false &ndash;&gt;-->
<!--        <neverBlock>true</neverBlock>&lt;!&ndash; default false, set to true to cause the-->
<!--            Appender not block the application and just drop the messages &ndash;&gt;-->
<!--    </appender>-->
<springProfile name="dev">
        <root level="INFO">
            <appender-ref ref="STDOUT"/>
        </root>
    </springProfile>
    <springProfile name="sit">
        <root level="INFO">
            <appender-ref ref="STDOUT"/>
        </root>
        <root level="INFO">
            <appender-ref ref="KAFKAAPPENDER"/>
        </root>
    </springProfile>
    <springProfile name="!dev">
<!--        <root level="WARN">-->
<!--            <appender-ref ref="STDOUT"/>-->
<!--        </root>-->
<root level="INFO">
            <appender-ref ref="KAFKAAPPENDER"/>
        </root>
    </springProfile>
</configuration>