<!--业务SQL日志 ,用于排查sql错误--> <RollingRandomAccessFile name="sqlLogFile" immediateFlush="false" filePattern="${fileName}/${hostName}_sql_%d{yyyy-MM-dd}_%i.log"> <PatternLayout pattern="${LOG_PATTERN}"/> <Policies> <TimeBasedTriggeringPolicy modulate="true" interval="1"/> <SizeBasedTriggeringPolicy size="2048MB"/> </Policies> <Filters> <ThresholdFilter level="info" onMatch="DENY" onMismatch="NEUTRAL"/> <ThresholdFilter level="debug" onMatch="ACCEPT" onMismatch="DENY"/> </Filters> <DirectWriteRolloverStrategy maxFiles="100"/> </RollingRandomAccessFile>
<logger name="com.xxx.mes3.pmc.mapper" level="debug" additivity="false"> <AppenderRef ref="sqlLogFile"/> <AppenderRef ref="console"/> </logger> <logger name="com.xxx.mes3.base.mapper" level="debug" additivity="false"> <AppenderRef ref="sqlLogFile"/> <AppenderRef ref="console"/> </logger> <logger name="com.xxx.mes3.emc.mapper" level="debug" additivity="false"> <AppenderRef ref="sqlLogFile"/> <AppenderRef ref="console"/> </logger> <logger name="com.huaxla.mes3.emptyGroupData.mapper" level="debug" additivity="false"> <AppenderRef ref="sqlLogFile"/> <AppenderRef ref="console"/> </logger> <logger name="com.huaxla.log.rabbitmq" level="OFF" additivity="false" /> <logger name="com.huaxla.infrastructure.etcd" level="OFF" additivity="false" /> <logger name="com.huaxla.commons" level="OFF" additivity="false" /> <logger name="io.grpc" level="OFF" additivity="false" />