{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12180","repository_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12180/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12180/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12180/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12180","id":148052065,"number":12180,"title":"Opening PHPMyAdmin in a new tab takes MINUTES to load first time, then it works normally (in that databse)","user":{"login":"alphestdev","id":32202,"avatar_url":"https://avatars.githubusercontent.com/u/32202?v=3","gravatar_id":"","url":"https://api.github.com/users/alphestdev","html_url":"https://github.com/alphestdev","followers_url":"https://api.github.com/users/alphestdev/followers","following_url":"https://api.github.com/users/alphestdev/following{/other_user}","gists_url":"https://api.github.com/users/alphestdev/gists{/gist_id}","starred_url":"https://api.github.com/users/alphestdev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alphestdev/subscriptions","organizations_url":"https://api.github.com/users/alphestdev/orgs","repos_url":"https://api.github.com/users/alphestdev/repos","events_url":"https://api.github.com/users/alphestdev/events{/privacy}","received_events_url":"https://api.github.com/users/alphestdev/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"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},"milestone":null,"comments":14,"created_at":"2016-04-13T12:55:49Z","updated_at":"2016-05-16T15:00:29Z","closed_at":null,"body":"Accessing PHPMyAdmin, lets say from a hyperlink:\r\n`<a href=\"https://domain.com/phpmyadmin/db_structure.php?db=db_name\" target=\"_blank\">My DB</a>`\r\n\r\nTakes consistently **2-4 minutes** to load the first time, if the login session is valid. If login session is not valid, the login page displays immediately, but it takes 2-4 minutes after you press Log in. After this horribly long loading PHPMyAdmin shows everything fine and loads every following click in milliseconds, but only in that browser tab and the same DB(!). If I close the tab, and follow the link again, the horrible loading repeats.\r\n\r\nNotes:\r\n- Browser patiently displays waiting for server.\r\n- Server contains a few hundred databases and is not on a heavy load. \r\n- Refreshing navigation panel using the icon works immediately.\r\n- This issue also existed in previous versions of PHPMyAdmin.\r\n\r\nMy guess is that phpMyAdmin overloads MySQL with requests, to gather all the details for the navigation panel on the left. Is there a way to load only database names and only a limited number of them, so the queries would work really fast? Or is there a way to load only a single requested database by URL, and **nothing else**, not any of other databases?\r\n\r\n### Server configuration\r\n**Operating system**: W2008R2\r\n**Web server:** IIS (fastcgi)\r\n**Database:** MySQL\r\n**PHP version:** 5.6\r\n**phpMyAdmin version:** 4.6.0\r\n"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/219447803","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12180#issuecomment-219447803","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12180","id":219447803,"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-05-16T15:00:29Z","updated_at":"2016-05-16T15:00:29Z","body":"Okay, this has been reportedly fixed in MySQL 5.7.2, see https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-2.html."}}