Looking at [1], our instructions to create a control user will no longer work beginning with MySQL 5.6.7. The MySQL documentation I've seen isn't clear on what this means (i.e. what we should do instead under the new versions), so does anyone have any suggestions?
1 - http://wiki.phpmyadmin.net/wiki/index.php?title=Talk:control_user&curid=...
Isaac Bennetch a écrit :
Looking at [1], our instructions to create a control user will no longer work beginning with MySQL 5.6.7. The MySQL documentation I've seen isn't clear on what this means (i.e. what we should do instead under the new versions), so does anyone have any suggestions?
1 - http://wiki.phpmyadmin.net/wiki/index.php?title=Talk:control_user&curid=...
Thanks Isaac for alerting us about this.
I'll study more about this, but my first reaction is that we might be able to change the doc, to indicate that the control user only has one goal: to connect to the phpMyAdmin configuration storage.
By the way, in [2] we decided to move the user doc away from the wiki.
[2] http://wiki.phpmyadmin.net/pma/DebConf_2013_Team_Meeting#Teams
Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.cl... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi
Dne Fri, 21 Feb 2014 09:36:45 -0500 Isaac Bennetch bennetch@gmail.com napsal(a):
Looking at [1], our instructions to create a control user will no longer work beginning with MySQL 5.6.7. The MySQL documentation I've seen isn't clear on what this means (i.e. what we should do instead under the new versions), so does anyone have any suggestions?
Do we really need those privileges on mysql.* tables? Looking at the code I can't find any obvious use for that.
Michal Čihař a écrit :
Hi
Dne Fri, 21 Feb 2014 09:36:45 -0500 Isaac Bennetch bennetch@gmail.com napsal(a):
Looking at [1], our instructions to create a control user will no longer work beginning with MySQL 5.6.7. The MySQL documentation I've seen isn't clear on what this means (i.e. what we should do instead under the new versions), so does anyone have any suggestions?
Do we really need those privileges on mysql.* tables? Looking at the code I can't find any obvious use for that.
There was/is the issue of supporting servers running with --skip-show-database, and maybe another issue. I have to do some more research about this today.
Le 2014-02-24 08:34, Marc Delisle a écrit :
Michal Čihař a écrit :
Hi
Dne Fri, 21 Feb 2014 09:36:45 -0500 Isaac Bennetch bennetch@gmail.com napsal(a):
Looking at [1], our instructions to create a control user will no longer work beginning with MySQL 5.6.7. The MySQL documentation I've seen isn't clear on what this means (i.e. what we should do instead under the new versions), so does anyone have any suggestions?
Do we really need those privileges on mysql.* tables? Looking at the code I can't find any obvious use for that.
There was/is the issue of supporting servers running with --skip-show-database, and maybe another issue. I have to do some more research about this today.
I could not find any other reason than supporting servers running with --skip-show-database.
Hi
Dne Mon, 24 Feb 2014 15:31:26 -0500 Marc Delisle marc@infomarc.info napsal(a):
I could not find any other reason than supporting servers running with --skip-show-database.
I know this is documented, but do we actually use this? I've just tried to run MySQL with this option and phpMyAdmin works just fine without controluser.
Looking at the code, I've only found it in List_Database.class.php and this code is never executed as the query against information schema works even with --skip-show-database. So I suggest to remove this code:
https://github.com/phpmyadmin/phpmyadmin/pull/963
Also as we no longer use SHOW DATABASE, related section of docs can be IMHO removed:
https://github.com/phpmyadmin/phpmyadmin/pull/964
Le 2014-02-26 03:06, Michal Čihař a écrit :
Hi
Dne Mon, 24 Feb 2014 15:31:26 -0500 Marc Delisle marc@infomarc.info napsal(a):
I could not find any other reason than supporting servers running with --skip-show-database.
I know this is documented, but do we actually use this? I've just tried to run MySQL with this option and phpMyAdmin works just fine without controluser.
Looking at the code, I've only found it in List_Database.class.php and this code is never executed as the query against information schema works even with --skip-show-database. So I suggest to remove this code:
https://github.com/phpmyadmin/phpmyadmin/pull/963
Also as we no longer use SHOW DATABASE, related section of docs can be IMHO removed:
We have at least one bug report active, from a user who has poor performance with a huge number of databases / tables. He suggests to reinstate the SHOW DATABASES logic.
Hi
Dne Wed, 26 Feb 2014 05:37:23 -0500 Marc Delisle marc@infomarc.info napsal(a):
We have at least one bug report active, from a user who has poor performance with a huge number of databases / tables. He suggests to reinstate the SHOW DATABASES logic.
I guess you mean bug #4243 [1]. In this case, I'd rather use the UNION select he suggests than going back to the SHOW DATABASES...
[1]: https://sourceforge.net/p/phpmyadmin/bugs/4243/
Michal Čihař a écrit :
Hi
Dne Wed, 26 Feb 2014 05:37:23 -0500 Marc Delisle marc@infomarc.info napsal(a):
We have at least one bug report active, from a user who has poor performance with a huge number of databases / tables. He suggests to reinstate the SHOW DATABASES logic.
I guess you mean bug #4243 [1]. In this case, I'd rather use the UNION select he suggests than going back to the SHOW DATABASES...
Agreed for this case, so feel free to merge your pull requests.
In the long term, I expect that all performance problems of information_schema will disappear (or at least that SHOW DATABASES is not faster...).
In bug #4243 the user is running MySQL 5.5. The last feedback I got from the admin of db4free.net is that he could not trigger information_schema performance problems, but he was running MySQL 5.6.
Hi
Dne Thu, 27 Feb 2014 08:20:16 -0500 Marc Delisle marc@infomarc.info napsal(a):
Agreed for this case, so feel free to merge your pull requests.
Okay, will do so.
In the long term, I expect that all performance problems of information_schema will disappear (or at least that SHOW DATABASES is not faster...).
Hopefully, but it takes incredibly long.
In bug #4243 the user is running MySQL 5.5. The last feedback I got from the admin of db4free.net is that he could not trigger information_schema performance problems, but he was running MySQL 5.6.
That's good news.
-
Isaac Bennetch -
Marc Delisle -
Michal Čihař