{"action":"created","issue":{"url":"https://api.github.com/repos/bonny/WordPress-Simple-History/issues/57","labels_url":"https://api.github.com/repos/bonny/WordPress-Simple-History/issues/57/labels{/name}","comments_url":"https://api.github.com/repos/bonny/WordPress-Simple-History/issues/57/comments","events_url":"https://api.github.com/repos/bonny/WordPress-Simple-History/issues/57/events","html_url":"https://github.com/bonny/WordPress-Simple-History/issues/57","id":58989621,"number":57,"title":"MySQL optimization","user":{"login":"szepeviktor","id":952007,"avatar_url":"https://avatars.githubusercontent.com/u/952007?v=3","gravatar_id":"","url":"https://api.github.com/users/szepeviktor","html_url":"https://github.com/szepeviktor","followers_url":"https://api.github.com/users/szepeviktor/followers","following_url":"https://api.github.com/users/szepeviktor/following{/other_user}","gists_url":"https://api.github.com/users/szepeviktor/gists{/gist_id}","starred_url":"https://api.github.com/users/szepeviktor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/szepeviktor/subscriptions","organizations_url":"https://api.github.com/users/szepeviktor/orgs","repos_url":"https://api.github.com/users/szepeviktor/repos","events_url":"https://api.github.com/users/szepeviktor/events{/privacy}","received_events_url":"https://api.github.com/users/szepeviktor/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-02-25T23:46:03Z","updated_at":"2015-03-01T11:20:44Z","closed_at":"2015-03-01T11:16:22Z","body":"If you are querying the DB by other fields than `id` there should be indexes for those queries.\r\nhttps://github.com/bonny/WordPress-Simple-History/blob/master/inc/SimpleHistory.php#L1003\r\n\r\nA simple way to debug it is to turn on\r\nhttp://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_log_queries_not_using_indexes\r\non your dev box."},"comment":{"url":"https://api.github.com/repos/bonny/WordPress-Simple-History/issues/comments/76592641","html_url":"https://github.com/bonny/WordPress-Simple-History/issues/57#issuecomment-76592641","issue_url":"https://api.github.com/repos/bonny/WordPress-Simple-History/issues/57","id":76592641,"user":{"login":"szepeviktor","id":952007,"avatar_url":"https://avatars.githubusercontent.com/u/952007?v=3","gravatar_id":"","url":"https://api.github.com/users/szepeviktor","html_url":"https://github.com/szepeviktor","followers_url":"https://api.github.com/users/szepeviktor/followers","following_url":"https://api.github.com/users/szepeviktor/following{/other_user}","gists_url":"https://api.github.com/users/szepeviktor/gists{/gist_id}","starred_url":"https://api.github.com/users/szepeviktor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/szepeviktor/subscriptions","organizations_url":"https://api.github.com/users/szepeviktor/orgs","repos_url":"https://api.github.com/users/szepeviktor/repos","events_url":"https://api.github.com/users/szepeviktor/events{/privacy}","received_events_url":"https://api.github.com/users/szepeviktor/received_events","type":"User","site_admin":false},"created_at":"2015-03-01T11:20:44Z","updated_at":"2015-03-01T11:20:44Z","body":"Use `mysqldumpslow` on the query log."}}