# "MySQL General" -\> "Process States" show "No datapoints" **URL:** \ **Category:** PMM 1.x\ **Created:** [March 19, 2017, 6:46am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496 "2017-03-19T06:46:36Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [March 19, 2017, 6:46am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/1 "2017-03-19T06:46:36Z")
1. “MySQL General” → “Process States” show “No datapoints” for bad server, for other servers there is data. ---
**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:** [March 20, 2017, 2:13am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/2 "2017-03-20T02:13:41Z")
1. can you check share output of following commands: ```auto curl https://BAD-SERVER-IP:42002/metrics-mr --insecure | grep mysql_info_schema_threads mysql -e "SELECT COALESCE(command,''),COALESCE(state,''),count(*),sum(time) FROM information_schema.processlist WHERE ID != connection_id() GROUP BY command,state ORDER BY null;" ``` ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [March 20, 2017, 2:47am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/3 "2017-03-20T02:47:21Z")
2. can you check share output of following commands: aleksey@aleksey-filippov:~$ curl [https://bad\_server:42002/metrics-mr](https://bad_server:42002/metrics-mr) --insecure | grep mysql\_info\_schema\_threads ```auto % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 117k 0 1058 0 0 349 0 0:05:43 0:00:03 0:05:40 349# HELP mysql_info_schema_threads The number of threads (connections) split by current state. # TYPE mysql_info_schema_threads gauge mysql_info_schema_threads{state="after create"} 0 mysql_info_schema_threads{state="altering table"} 0 mysql_info_schema_threads{state="analyzing"} 0 mysql_info_schema_threads{state="checking permissions"} 0 mysql_info_schema_threads{state="checking table"} 0 mysql_info_schema_threads{state="cleaning up"} 0 mysql_info_schema_threads{state="closing tables"} 0 mysql_info_schema_threads{state="converting heap to myisam"} 0 mysql_info_schema_threads{state="copying to tmp table"} 0 mysql_info_schema_threads{state="creating sort index"} 0 mysql_info_schema_threads{state="creating table"} 0 mysql_info_schema_threads{state="creating tmp table"} 0 mysql_info_schema_threads{state="deleting"} 0 mysql_info_schema_threads{state="end"} 0 mysql_info_schema_threads{state="executing"} 0 mysql_info_schema_threads{state="execution of init_command"} 0 mysql_info_schema_threads{state="flushing tables"} 0 mysql_info_schema_threads{state="freeing items"} 0 mysql_info_schema_threads{state="fulltext initialization"} 0 mysql_info_schema_threads{state="idle"} 62 mysql_info_schema_threads{state="init"} 0 mysql_info_schema_threads{state="killed"} 0 mysql_info_schema_threads{state="logging slow query"} 0 mysql_info_schema_threads{state="login"} 0 mysql_info_schema_threads{state="manage keys"} 0 mysql_info_schema_threads{state="opening tables"} 0 mysql_info_schema_threads{state="optimizing"} 0 mysql_info_schema_threads{state="other"} 0 mysql_info_schema_threads{state="preparing"} 0 mysql_info_schema_threads{state="reading from net"} 0 mysql_info_schema_threads{state="removing duplicates"} 0 mysql_info_schema_threads{state="removing tmp table"} 0 mysql_info_schema_threads{state="reopen tables"} 0 mysql_info_schema_threads{state="repair by sorting"} 0 mysql_info_schema_threads{state="repair done"} 0 mysql_info_schema_threads{state="repair with keycache"} 0 mysql_info_schema_threads{state="replication master"} 0 mysql_info_schema_threads{state="rolling back"} 0 mysql_info_schema_threads{state="searching rows for update"} 0 mysql_info_schema_threads{state="sending data"} 1 mysql_info_schema_threads{state="sorting for group"} 0 mysql_info_schema_threads{state="sorting for order"} 0 mysql_info_schema_threads{state="sorting index"} 0 mysql_info_schema_threads{state="sorting result"} 0 mysql_info_schema_threads{state="statistics"} 0 mysql_info_schema_threads{state="updating"} 1 mysql_info_schema_threads{state="waiting for lock"} 0 mysql_info_schema_threads{state="waiting for table flush"} 0 mysql_info_schema_threads{state="waiting for tables"} 0 mysql_info_schema_threads{state="waiting on cond"} 0 mysql_info_schema_threads{state="writing to net"} 0 # HELP mysql_info_schema_threads_seconds The number of seconds threads (connections) have used split by current state. # TYPE mysql_info_schema_threads_seconds gauge mysql_info_schema_threads_seconds{state="after create"} 0 mysql_info_schema_threads_seconds{state="altering table"} 0 mysql_info_schema_threads_seconds{state="analyzing"} 0 mysql_info_schema_threads_seconds{state="checking permissions"} 0 mysql_info_schema_threads_seconds{state="checking table"} 0 mysql_info_schema_threads_seconds{state="cleaning up"} 0 mysql_info_schema_threads_seconds{state="closing tables"} 0 mysql_info_schema_threads_seconds{state="converting heap to myisam"} 0 mysql_info_schema_threads_seconds{state="copying to tmp table"} 0 mysql_info_schema_threads_seconds{state="creating sort index"} 0 mysql_info_schema_threads_seconds{state="creating table"} 0 mysql_info_schema_threads_seconds{state="creating tmp table"} 0 mysql_info_schema_threads_seconds{state="deleting"} 0 mysql_info_schema_threads_seconds{state="end"} 0 mysql_info_schema_threads_seconds{state="executing"} 0 mysql_info_schema_threads_seconds{state="execution of init_command"} 0 mysql_info_schema_threads_seconds{state="flushing tables"} 0 mysql_info_schema_threads_seconds{state="freeing items"} 0 mysql_info_schema_threads_seconds{state="fulltext initialization"} 0 mysql_info_schema_threads_seconds{state="idle"} 4067 mysql_info_schema_threads_seconds{state="init"} 0 mysql_info_schema_threads_seconds{state="killed"} 0 mysql_info_schema_threads_seconds{state="logging slow query"} 0 mysql_info_schema_threads_seconds{state="login"} 0 mysql_info_schema_threads_seconds{state="manage keys"} 0 mysql_info_schema_threads_seconds{state="opening tables"} 0 mysql_info_schema_threads_seconds{state="optimizing"} 0 mysql_info_schema_threads_seconds{state="other"} 0 mysql_info_schema_threads_seconds{state="preparing"} 0 mysql_info_schema_threads_seconds{state="reading from net"} 0 mysql_info_schema_threads_seconds{state="removing duplicates"} 0 mysql_info_schema_threads_seconds{state="removing tmp table"} 0 mysql_info_schema_threads_seconds{state="reopen tables"} 0 mysql_info_schema_threads_seconds{state="repair by sorting"} 0 mysql_info_schema_threads_seconds{state="repair done"} 0 mysql_info_schema_threads_seconds{state="repair with keycache"} 0 mysql_info_schema_threads_seconds{state="replication master"} 0 mysql_info_schema_threads_seconds{state="rolling back"} 0 mysql_info_schema_threads_seconds{state="searching rows for update"} 0 mysql_info_schema_threads_seconds{state="sending data"} 1 mysql_info_schema_threads_seconds{state="sorting for group"} 0 mysql_info_schema_threads_seconds{state="sorting for order"} 0 mysql_info_schema_threads_seconds{state="sorting index"} 0 mysql_info_schema_threads_seconds{state="sorting result"} 0 mysql_info_schema_threads_seconds{state="statistics"} 0 mysql_info_schema_threads_seconds{state="updating"} 1 mysql_info_schema_threads_seconds{state="waiting for lock"} 0 mysql_info_schema_threads_seconds{state="waiting for table flush"} 0 mysql_info_schema_threads_seconds{state="waiting for tables"} 0 mysql_info_schema_threads_seconds{state="waiting on cond"} 0 mysql_info_schema_threads_seconds{state="writing to net"} 0 100 117k 100 117k 0 0 38924 0 0:00:03 0:00:03 --:--:-- 38937 ``` BAD\_SERVER: mysql -e "SELECT COALESCE(command,‘’),COALESCE(state,‘’),count(_),s um(time) FROM information\_schema.processlist WHERE ID != connection\_id() GROUP BY command,state ORDER BY null;" ±---------------------±-------------------±---------±----------+ | COALESCE(command,‘’) | COALESCE(state,‘’) | count(_) | sum(time) | ±---------------------±-------------------±---------±----------+ | Sleep | | 65 | 3631 | | Query | Sending data | 1 | 1 | | Query | update | 1 | 0 | ±---------------------±-------------------±---------±----------+ GOOD\_SERVER: mysql -e "SELECT COALESCE(command,‘’),COALESCE(state,‘’),count(_),s um(time) FROM information\_schema.processlist WHERE ID != connection\_id() GROUP BY command,state ORDER BY null;" ±---------------------±-------------------±---------±----------+ | COALESCE(command,‘’) | COALESCE(state,‘’) | count(_) | sum(time) | ±---------------------±-------------------±---------±----------+ | Sleep | | 4 | 3132 | ±---------------------±-------------------±---------±----------+ ---
**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:** [March 21, 2017, 5:14am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/4 "2017-03-21T05:14:40Z")
do you see any issues with [https://bad\_server:42002/metrics-mr](https://bad_server:42002/metrics-mr) on [url][http://pmm-server/prometheus/targets[/url]](http://pmm-server/prometheus/targets%5B/url%5D) page? ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [March 27, 2017, 3:02am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/5 "2017-03-27T03:02:42Z")
[https://bad\_server:42002/metrics-mr:](https://bad_server:42002/metrics-mr) [URL][DepositFiles](http://depositfiles.com/files/gwme6pscz%5B/URL%5D) [URL=“[http://pmm-server/prometheus/targets](http://pmm-server/prometheus/targets)”][http://pmm-server/prometheus/targets:[/URL]](http://pmm-server/prometheus/targets:%5B/URL%5D) ![экрана от 2017-03-27 11-26-42.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/8/8fe00c93de61bb29528759a77ce38aac2355f0c4.png) ---
**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:** [March 27, 2017, 9:22am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/6 "2017-03-27T09:22:01Z")
As I can see /metrics-mr is down. can you share output of the following command? ```auto wget https://bad-server-ip:42002/metrics-mr --no-check-certificate ``` ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [March 27, 2017, 10:18am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/7 "2017-03-27T10:18:01Z")
[url][DepositFiles](http://depositfiles.com/files/y0dq6l4mz%5B/url%5D) ---
**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:** [March 27, 2017, 1:37pm UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/8 "2017-03-27T13:37:07Z")
oh, sorry, I am wondering response time, not content ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [April 13, 2017, 3:58am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/9 "2017-04-13T03:58:43Z")
aleksey@aleksey-filippov:~$ wget [url][https://mysql.db:42002/metrics-mr[/url]](https://mysql.db:42002/metrics-mr%5B/url%5D) --no-check-certificate –2017-04-13 12:27:17-- [url][https://mysql.db:42002/metrics-mr[/url]](https://mysql.db:42002/metrics-mr%5B/url%5D) Распознаётся mysql.db (mysql.db)… 111.111.11.1 Подключение к mysql.db (mysql.db)|111.111.11.1|:42002… соединение установлено. ПРЕДУПРЕЖДЕНИЕ: невозможно проверить сертификат mysql.db, выпущенный «O=PMM Client»: Невозможно локально проверить подлинность запрашивающего. ПРЕДУПРЕЖДЕНИЕ: Общее название сертификата «» не совпадает с именем запрошенного узла «mysql.db». HTTP-запрос отправлен. Ожидание ответа… 200 OK Длина: 119619 (117K) [text/plain] Сохранение в: «metrics-mr» metrics-mr 100%[================================================================================================================\>] 116,82K --.-KB/s in 0,05s 2017-04-13 12:27:18 (2,36 MB/s) - «metrics-mr» сохранён [119619/119619] ---
**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:** [April 18, 2017, 3:38am UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/10 "2017-04-18T03:38:32Z")
should be fixed after changes in another thread [url][https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47839-mysql-query-responce-time-show-no-datapoints?p=48145#post48145[/url]](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47839-mysql-query-responce-time-show-no-datapoints?p=48145#post48145%5B/url%5D) this graph, depends to collector ---
**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\ **Post date:** [April 18, 2017, 11:32pm UTC](https://forums.percona.com/t/mysql-general-process-states-show-no-datapoints/5496/11 "2017-04-18T23:32:06Z")
Problem fixed after [url][https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47839-mysql-query-responce-time-show-no-datapoints?p=48145#post48145[/url]](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47839-mysql-query-responce-time-show-no-datapoints?p=48145#post48145%5B/url%5D)