This is an automated email from the ASF dual-hosted git repository. jackietien pushed a commit to branch ZYBug in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit e3f83126e16f82729a6c7b741b0e5d3487a83afe Author: JackieTien97 <[email protected]> AuthorDate: Tue Oct 27 19:33:54 2020 +0800 add log --- server/src/assembly/resources/conf/logback.xml | 21 +++++++++++++++++++++ .../org/apache/iotdb/db/service/TSServiceImpl.java | 5 +++++ 2 files changed, 26 insertions(+) diff --git a/server/src/assembly/resources/conf/logback.xml b/server/src/assembly/resources/conf/logback.xml index f7aa291..b542374 100644 --- a/server/src/assembly/resources/conf/logback.xml +++ b/server/src/assembly/resources/conf/logback.xml @@ -186,6 +186,24 @@ <level>INFO</level> </filter> </appender> + <appender class="ch.qos.logback.core.rolling.RollingFileAppender" name="SLOW_SQL"> + <file>${IOTDB_HOME}/logs/log_slow_sql.log</file> + <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> + <fileNamePattern>${IOTDB_HOME}/logs/log-slow-sql-%d{yyyy-MM-dd}.%i.log</fileNamePattern> + <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP"> + <maxFileSize>50MB</maxFileSize> + <maxBackupIndex>50</maxBackupIndex> + </timeBasedFileNamingAndTriggeringPolicy> + </rollingPolicy> + <append>true</append> + <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder"> + <pattern>%d [%t] %-5p %C:%L - %m %n</pattern> + <charset>utf-8</charset> + </encoder> + <filter class="ch.qos.logback.classic.filter.ThresholdFilter"> + <level>INFO</level> + </filter> + </appender> <root level="info"> <appender-ref ref="FILEDEBUG"/> <appender-ref ref="FILEWARN"/> @@ -203,4 +221,7 @@ <logger level="info" name="ZY-DEBUG"> <appender-ref ref="ZY"/> </logger> + <logger level="info" name="SLOW-SQL"> + <appender-ref ref="SLOW_SQL"/> + </logger> </configuration> diff --git a/server/src/main/java/org/apache/iotdb/db/service/TSServiceImpl.java b/server/src/main/java/org/apache/iotdb/db/service/TSServiceImpl.java index 9986b4c..4e0c8f9 100644 --- a/server/src/main/java/org/apache/iotdb/db/service/TSServiceImpl.java +++ b/server/src/main/java/org/apache/iotdb/db/service/TSServiceImpl.java @@ -130,6 +130,7 @@ import org.slf4j.LoggerFactory; public class TSServiceImpl implements TSIService.Iface, ServerContext { private static final Logger logger = LoggerFactory.getLogger(TSServiceImpl.class); + private static final Logger SLOW_SQL_LOGGER = LoggerFactory.getLogger("SLOW-SQL"); private static final String INFO_NOT_LOGIN = "{}: Not login."; private static final int MAX_SIZE = IoTDBDescriptor.getInstance().getConfig().getQueryCacheSizeInMetric(); @@ -613,6 +614,10 @@ public class TSServiceImpl implements TSIService.Iface, ServerContext { return RpcUtils.getTSExecuteStatementResp(TSStatusCode.INTERNAL_SERVER_ERROR, e.getMessage()); } finally { Measurement.INSTANCE.addOperationLatency(Operation.EXECUTE_QUERY, startTime); + long costTime = System.currentTimeMillis() - startTime; + if (costTime >= 5000) { + SLOW_SQL_LOGGER.info("Cost " + costTime + " ms, sql is " + statement); + } } }
