# QAN not picking up change to long\_query\_time **URL:** \ **Category:** PMM 1.x\ **Created:** [July 25, 2017, 7:51am UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763 "2017-07-25T07:51:20Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![chrishatcher1138](https://avatars.discourse-cdn.com/v4/letter/c/c77e96/32.png) [@chrishatcher1138](https://forums.percona.com/u/chrishatcher1138)\ **Post date:** [July 25, 2017, 7:51am UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/1 "2017-07-25T07:51:20Z")
I have decreased long\_query\_time from the default of 10 to 1 second. I have confirmed that queries \> 1 second are in the slow log. QAN does not show queries between 1 and 10 seconds, but it will still display queries \> 10 seconds. What do I need to do for QAN to pick up these queries? I am using PMM 1.2.0. The database is MariaDB 10.1.21. Thanks - Chris ---
**Author:** ![kamil-dziedzic](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kamil-dziedzic/32/16873_2.png) [@kamil-dziedzic](https://forums.percona.com/u/kamil-dziedzic)\ **Post date:** [July 25, 2017, 8:28am UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/2 "2017-07-25T08:28:24Z")
Hi Chris, Could you run: ```auto SELECT * FROM information_schema.global_variables WHERE VARIABLE_NAME LIKE "log_slow%" OR VARIABLE_NAME IN( "long_query_time", "log_queries_not_using_indexes", "min_examined_row_limit", "log_throttle_queries_not_using_indexes", "log_timestamps", "slow_query_log", "slow_query_log_file", "log_output", "performance_schema", "performance_schema_digests_size", "performance_schema_max_digest_length" ) ORDER BY VARIABLE_NAME; ``` and ```auto $ sudo pmm-admin list ``` ---
**Author:** ![chrishatcher1138](https://avatars.discourse-cdn.com/v4/letter/c/c77e96/32.png) [@chrishatcher1138](https://forums.percona.com/u/chrishatcher1138)\ **Post date:** [July 25, 2017, 11:53am UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/3 "2017-07-25T11:53:34Z")
[TABLE] [TR] [TD]LOG\_OUTPUT[/TD] [TD]FILE[/TD] [/TR] [TR] [TD]LOG\_QUERIES\_NOT\_USING\_INDEXES[/TD] [TD]OFF[/TD] [/TR] [TR] [TD]LOG\_SLOW\_ADMIN\_STATEMENTS[/TD] [TD]OFF[/TD] [/TR] [TR] [TD]LOG\_SLOW\_FILTER[/TD] [TD]admin,filesort,filesort\_on\_disk,full\_join,full\_scan,query\_cache,query\_cache\_miss,tmp\_table,tmp\_table\_on\_disk[/TD] [/TR] [TR] [TD]LOG\_SLOW\_RATE\_LIMIT[/TD] [TD]1[/TD] [/TR] [TR] [TD]LOG\_SLOW\_SLAVE\_STATEMENTS[/TD] [TD]OFF[/TD] [/TR] [TR] [TD]LOG\_SLOW\_VERBOSITY[/TD] [TD]query\_plan[/TD] [/TR] [TR] [TD]LONG\_QUERY\_TIME[/TD] [TD]1.000000[/TD] [/TR] [TR] [TD]MIN\_EXAMINED\_ROW\_LIMIT[/TD] [TD]0[/TD] [/TR] [TR] [TD]PERFORMANCE\_SCHEMA[/TD] [TD]ON[/TD] [/TR] [TR] [TD]PERFORMANCE\_SCHEMA\_DIGESTS\_SIZE[/TD] [TD]5000[/TD] [/TR] [TR] [TD]PERFORMANCE\_SCHEMA\_MAX\_DIGEST\_LENGTH[/TD] [TD]1024[/TD] [/TR] [TR] [TD]SLOW\_QUERY\_LOG[/TD] [TD]ON[/TD] [/TR] [TR] [TD]SLOW\_QUERY\_LOG\_FILE[/TD] [TD]/var/log/mysql/mariadb-slow.log[/TD] [/TR] [/TABLE] pmm-admin 1.2.0 PMM Server | 172.31.27.92:8081 Client Name | ip-172-31-20-131 Client Address | XX.XX.XX.XX (172.31.20.131) Service Manager | linux-upstart * * * SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS * * * mysql:queries ip-172-31-20-131 - YES pmm:_**@unix(/var/run/mysqld/mysqld.sock) query\_source=slowlog, query\_examples=true linux:metrics ip-172-31-20-131 42000 YES - mysql:metrics ip-172-31-20-131 42002 YES pmm:**_@unix(/var/run/mysqld/mysqld.sock) ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [July 26, 2017, 8:46am UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/4 "2017-07-26T08:46:12Z")
Hi [chrishatcher1138](https://percona.vanillacommunities.com/profile/x/x/40338) can you please also upload full content of file? can you also restart qan-agent, wait for 2 hours and check if new queries shown on query analytics interface? ---
**Author:** ![chrishatcher1138](https://avatars.discourse-cdn.com/v4/letter/c/c77e96/32.png) [@chrishatcher1138](https://forums.percona.com/u/chrishatcher1138)\ **Post date:** [July 26, 2017, 5:27pm UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/5 "2017-07-26T17:27:56Z")
Once I restarted the agent, it seems to be working correctly. Thanks for the help. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [July 27, 2017, 2:15am UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/6 "2017-07-27T02:15:15Z")
Hi [chrishatcher1138](https://percona.vanillacommunities.com/profile/x/x/40338) anyway, can you please also upload full content of /var/log/pmm-mysql-queries-0.log file? maybe we can find root of the issue… ---
**Author:** ![chrishatcher1138](https://avatars.discourse-cdn.com/v4/letter/c/c77e96/32.png) [@chrishatcher1138](https://forums.percona.com/u/chrishatcher1138)\ **Post date:** [July 27, 2017, 3:41pm UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/7 "2017-07-27T15:41:17Z")
Here you go: # Version: percona-qan-agent 1.2.0 # Basedir: /usr/local/percona/qan-agent # PID: 23257 # API: 172.31.27.92:8081/qan-api # UUID: 10380f1923b644516cce462ff3bf75ab 2017/07/25 00:23:25.444672 main.go:163: Starting agent… 2017/07/25 00:23:25.449945 main.go:331: Agent is ready 2017/07/25 00:23:25.458813 main.go:204: API is ready [mysql] 2017/07/25 00:26:34 packets.go:141: write unix @-\>/var/run/mysqld/mysqld.sock: write: broken pipe 2017/07/25 00:32:35.536298 WARNING mrms-monitor Listener not ready 2017/07/25 00:32:35.536406 WARNING mrms-monitor Listener not ready 2017/07/25 00:32:57.032812 ERROR agent Executable file not found in $PATH 2017/07/25 00:32:57.032915 WARNING agent Cmd fail: Reply[Cmd:GetServerSummary Error:‘Executable file not found in $PATH’ Id:9009810f-59$ 2017/07/25 00:32:57.033500 ERROR agent Executable file not found in $PATH 2017/07/25 00:32:57.033577 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘Executable file not found in $PATH’ Id:d29966d1-668$ 2017/07/25 06:56:47.000825 WARNING mrms-monitor Listener not ready 2017/07/25 06:56:47.000964 WARNING mrms-monitor Listener not ready 2017/07/25 12:18:28.167149 WARNING mrms-monitor Listener not ready 2017/07/25 12:18:28.167275 WARNING mrms-monitor Listener not ready 2017/07/25 12:47:38.294859 WARNING mrms-monitor Listener not ready 2017/07/25 12:47:38.295005 WARNING mrms-monitor Listener not ready 2017/07/25 12:49:18.315943 WARNING mrms-monitor Listener not ready 2017/07/25 12:49:18.316062 WARNING mrms-monitor Listener not ready 2017/07/25 12:51:48.336718 WARNING mrms-monitor Listener not ready 2017/07/25 12:51:48.336832 WARNING mrms-monitor Listener not ready 2017/07/25 12:56:15.737130 ERROR agent Executable file not found in $PATH 2017/07/25 12:56:15.737254 WARNING agent Cmd fail: Reply[Cmd:GetServerSummary Error:‘Executable file not found in $PATH’ Id:02cc9e65-eb$ 2017/07/25 12:56:15.807089 ERROR agent Executable file not found in $PATH 2017/07/25 12:56:15.807186 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘Executable file not found in $PATH’ Id:241897eb-c3d$ 2017/07/26 18:01:55.000910 WARNING mrms-monitor Listener not ready 2017/07/26 18:01:55.001039 WARNING mrms-monitor Listener not ready 2017/07/26 22:41:50.435607 main.go:359: Caught interrupt signal, shutting down 2017/07/26 22:41:50.435662 main.go:385: Stopping QAN… 2017/07/26 22:41:50.478587 main.go:392: Waiting 2 seconds to flush agent log to API… 2017/07/26 22:41:52.478873 main.go:167: Agent has stopped # Version: percona-qan-agent 1.2.0 # Basedir: /usr/local/percona/qan-agent # PID: 7354 # API: 172.31.27.92:8081/qan-api # UUID: 10380f1923b644516cce462ff3bf75ab 2017/07/26 22:41:52.634565 main.go:163: Starting agent… 2017/07/26 22:41:52.691738 main.go:331: Agent is ready 2017/07/26 22:41:52.705782 main.go:204: API is ready 2017/07/27 13:48:11.637632 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:48:24.638270 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:48:37.639057 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:49:14.636560 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:49:27.637602 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:49:40.638480 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:50:17.636479 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:50:30.637189 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:50:43.638066 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:51:20.636461 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:51:33.637100 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:51:46.637913 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:52:23.636566 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:52:36.637295 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:52:49.638500 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:53:26.636546 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:53:39.637176 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:53:52.638035 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:54:29.636563 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:54:42.637240 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:54:55.638088 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:55:32.636552 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:55:45.637200 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:55:58.638047 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:56:35.636666 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:56:48.637311 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:57:01.640109 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:57:38.636539 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:57:51.637281 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:58:04.638121 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:58:41.636502 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:58:54.637164 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:59:07.638039 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:59:44.636870 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 13:59:57.637552 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 14:00:10.638381 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 14:00:47.636539 WARNING data-sender Cannot connect to API: websocket.Dial ws://172.31.27.92:8081/qan-api/agents/10380f1923b$ 2017/07/27 14:02:23.719845 WARNING agent ws error: read tcp 172.31.20.131:40717-\>172.31.27.92:8081: read: connection reset by peer 2017/07/27 14:02:23.720057 WARNING agent Lost connection to API, reconnecting ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [August 2, 2017, 2:39am UTC](https://forums.percona.com/t/qan-not-picking-up-change-to-long-query-time/5763/8 "2017-08-02T02:39:31Z")
[chrishatcher1138](https://percona.vanillacommunities.com/profile/x/x/40338) , thank you, I created bug report [url][[PMM-1267] [qan agent] mysql restart accidentally not handled correctly - Percona JIRA](https://jira.percona.com/browse/PMM-1267%5B/url%5D) feel free to add any additional information into it