{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12129","repository_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12129/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12129/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12129/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12129","id":143625042,"number":12129,"title":"Slow database list on 4.6","user":{"login":"JFDionne","id":1706002,"avatar_url":"https://avatars.githubusercontent.com/u/1706002?v=3","gravatar_id":"","url":"https://api.github.com/users/JFDionne","html_url":"https://github.com/JFDionne","followers_url":"https://api.github.com/users/JFDionne/followers","following_url":"https://api.github.com/users/JFDionne/following{/other_user}","gists_url":"https://api.github.com/users/JFDionne/gists{/gist_id}","starred_url":"https://api.github.com/users/JFDionne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JFDionne/subscriptions","organizations_url":"https://api.github.com/users/JFDionne/orgs","repos_url":"https://api.github.com/users/JFDionne/repos","events_url":"https://api.github.com/users/JFDionne/events{/privacy}","received_events_url":"https://api.github.com/users/JFDionne/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-25T23:20:40Z","updated_at":"2016-04-06T07:28:31Z","closed_at":null,"body":"Hi, when I click on database at the left panel, it take like 10-12 second to load if I have \"SkipLockedTables\" to true, when I set it to false it take like 2-3 second to load\r\n\r\n### Server configuration\r\n**Operating system**:\r\n\r\n**Web server:**\r\n    Apache/2.2.15 (Scientific Linux)\r\n    Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $\r\n    PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation\r\n    PHP version: 5.6.19\r\n"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/206180342","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12129#issuecomment-206180342","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12129","id":206180342,"user":{"login":"nijel","id":212189,"avatar_url":"https://avatars.githubusercontent.com/u/212189?v=3","gravatar_id":"","url":"https://api.github.com/users/nijel","html_url":"https://github.com/nijel","followers_url":"https://api.github.com/users/nijel/followers","following_url":"https://api.github.com/users/nijel/following{/other_user}","gists_url":"https://api.github.com/users/nijel/gists{/gist_id}","starred_url":"https://api.github.com/users/nijel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nijel/subscriptions","organizations_url":"https://api.github.com/users/nijel/orgs","repos_url":"https://api.github.com/users/nijel/repos","events_url":"https://api.github.com/users/nijel/events{/privacy}","received_events_url":"https://api.github.com/users/nijel/received_events","type":"User","site_admin":false},"created_at":"2016-04-06T07:28:30Z","updated_at":"2016-04-06T07:28:30Z","body":"SkipLockedTables needs additional SQL query for every database, so it indeed slows down things. Not sure if there is way to improve it..."}}