业务sql日志分日志文件

<!--业务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" />