Comments on: Baffling 5.7 global/status variables issues, unclean migration path https://shlomi-noach.github.io/blog/mysql/baffling-5-7-globalstatus-variables-issues-unclean-migration-path Blog by Shlomi Noach Wed, 19 Aug 2015 08:00:11 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: A followup on show_compatibility_56 | MySQL https://shlomi-noach.github.io/blog/mysql/baffling-5-7-globalstatus-variables-issues-unclean-migration-path/comment-page-1#comment-323598 Wed, 19 Aug 2015 00:24:10 +0000 https://shlomi-noach.github.io/blog/?p=7327#comment-323598 […] and Shlomi both blogged on one of the recent changes introduced to MySQL 5.7.8-rc, where the setting show_compatibility_56 […]

]]> By: Todd Farmer https://shlomi-noach.github.io/blog/mysql/baffling-5-7-globalstatus-variables-issues-unclean-migration-path/comment-page-1#comment-322800 Fri, 07 Aug 2015 20:08:37 +0000 https://shlomi-noach.github.io/blog/?p=7327#comment-322800 Hi Shlomi!

Thanks for the feedback! Yes, the privileges required for PERFORMANCE_SCHEMA tables that are now used underneath legacy SHOW commands were incorrect. This was noticed internally and reported, but the fix did not make the 5.7.8 RC2 cutoff. The bug report is waiting proper documentation, but the fix for the following bug report fixes several PERFORMANCE_SCHEMA table privileges, including those affecting global variables:

http://bugs.mysql.com/bug.php?id=77702

I hope that helps!

]]> By: Giuseppe Maxia https://shlomi-noach.github.io/blog/mysql/baffling-5-7-globalstatus-variables-issues-unclean-migration-path/comment-page-1#comment-322783 Fri, 07 Aug 2015 14:24:28 +0000 https://shlomi-noach.github.io/blog/?p=7327#comment-322783 That page is in the wrong place. People who have no issues with the performance schema will not look at it, and since the upgrade page does not mention performance_schema (it is already scary enough as it is now) they would not be encouraged to look for it.

At least a link to the performance_schema migration page should be in the main upgrade doc.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/baffling-5-7-globalstatus-variables-issues-unclean-migration-path/comment-page-1#comment-322782 Fri, 07 Aug 2015 14:15:35 +0000 https://shlomi-noach.github.io/blog/?p=7327#comment-322782 And yet there’s this special section: http://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html

]]> By: Giuseppe Maxia https://shlomi-noach.github.io/blog/mysql/baffling-5-7-globalstatus-variables-issues-unclean-migration-path/comment-page-1#comment-322781 Fri, 07 Aug 2015 14:09:40 +0000 https://shlomi-noach.github.io/blog/?p=7327#comment-322781 Interestingly, the upgrade document does not mention VARIABLES, or STATUS, or performance_schema, or information_schema
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html

]]>