{"action":"created","issue":{"url":"https://api.github.com/repos/sjmudd/ps-top/issues/4","labels_url":"https://api.github.com/repos/sjmudd/ps-top/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/sjmudd/ps-top/issues/4/comments","events_url":"https://api.github.com/repos/sjmudd/ps-top/issues/4/events","html_url":"https://github.com/sjmudd/ps-top/issues/4","id":112032362,"number":4,"title":"Unknown column 'SUM_TIMER_WAIT' in 'field list'","user":{"login":"scorredoira","id":1644405,"avatar_url":"https://avatars.githubusercontent.com/u/1644405?v=3","gravatar_id":"","url":"https://api.github.com/users/scorredoira","html_url":"https://github.com/scorredoira","followers_url":"https://api.github.com/users/scorredoira/followers","following_url":"https://api.github.com/users/scorredoira/following{/other_user}","gists_url":"https://api.github.com/users/scorredoira/gists{/gist_id}","starred_url":"https://api.github.com/users/scorredoira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scorredoira/subscriptions","organizations_url":"https://api.github.com/users/scorredoira/orgs","repos_url":"https://api.github.com/users/scorredoira/repos","events_url":"https://api.github.com/users/scorredoira/events{/privacy}","received_events_url":"https://api.github.com/users/scorredoira/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-10-18T17:53:23Z","updated_at":"2015-11-27T16:52:37Z","closed_at":"2015-11-26T22:29:16Z","body":"Hi Simon,\r\n\r\nI am trying to run the tool but I get the error:\r\n\r\n     2015/10/18 19:45:19 Error 1054: Unknown column 'SUM_TIMER_WAIT' in 'field list'\r\n\r\nand the program exits.\r\n\r\nI am using mysql 5.5 with performance enabled and accessing as root\r\n\r\n\t+-------------------------+-----------------------------+\r\n\t| Variable_name           | Value                       |\r\n\t+-------------------------+-----------------------------+\r\n\t| innodb_version          | 5.5.44                      |\r\n\t| protocol_version        | 10                          |\r\n\t| slave_type_conversions  |                             |\r\n\t| version                 | 5.5.44-0ubuntu0.14.04.1-log |\r\n\t| version_comment         | (Ubuntu)                    |\r\n\t| version_compile_machine | x86_64                      |\r\n\t| version_compile_os      | debian-linux-gnu            |\r\n\t+-------------------------+-----------------------------+\r\n\r\n\tmysql> SHOW VARIABLES LIKE 'performance_schema';\r\n\t+--------------------+-------+\r\n\t| Variable_name      | Value |\r\n\t+--------------------+-------+\r\n\t| performance_schema | ON    |\r\n\t+--------------------+-------+\r\n\r\nI have even checked and the column is there:\r\n\r\n\tmysql> describe performance_schema.events_waits_summary_global_by_event_name;\r\n\t+----------------+---------------------+------+-----+---------+-------+\r\n\t| Field          | Type                | Null | Key | Default | Extra |\r\n\t+----------------+---------------------+------+-----+---------+-------+\r\n\t| EVENT_NAME     | varchar(128)        | NO   |     | NULL    |       |\r\n\t| COUNT_STAR     | bigint(20) unsigned | NO   |     | NULL    |       |\r\n\t| SUM_TIMER_WAIT | bigint(20) unsigned | NO   |     | NULL    |       |\r\n\t| MIN_TIMER_WAIT | bigint(20) unsigned | NO   |     | NULL    |       |\r\n\t| AVG_TIMER_WAIT | bigint(20) unsigned | NO   |     | NULL    |       |\r\n\t| MAX_TIMER_WAIT | bigint(20) unsigned | NO   |     | NULL    |       |\r\n\t+----------------+---------------------+------+-----+---------+-------+\r\n\r\nAny idea of what can be wrong?\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sjmudd/ps-top/issues/comments/160174320","html_url":"https://github.com/sjmudd/ps-top/issues/4#issuecomment-160174320","issue_url":"https://api.github.com/repos/sjmudd/ps-top/issues/4","id":160174320,"user":{"login":"scorredoira","id":1644405,"avatar_url":"https://avatars.githubusercontent.com/u/1644405?v=3","gravatar_id":"","url":"https://api.github.com/users/scorredoira","html_url":"https://github.com/scorredoira","followers_url":"https://api.github.com/users/scorredoira/followers","following_url":"https://api.github.com/users/scorredoira/following{/other_user}","gists_url":"https://api.github.com/users/scorredoira/gists{/gist_id}","starred_url":"https://api.github.com/users/scorredoira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scorredoira/subscriptions","organizations_url":"https://api.github.com/users/scorredoira/orgs","repos_url":"https://api.github.com/users/scorredoira/repos","events_url":"https://api.github.com/users/scorredoira/events{/privacy}","received_events_url":"https://api.github.com/users/scorredoira/received_events","type":"User","site_admin":false},"created_at":"2015-11-27T16:52:37Z","updated_at":"2015-11-27T16:52:37Z","body":"It turns out that they also provide the 5.6 version if you specify it \"apt-get install mysql-server-5.6\". I will be able to try the tool finally :)"}}