Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Looking for innodb_index_stats in the wrong schema in mysql 5.6 #60

Open
GoogleCodeExporter opened this issue Jun 18, 2015 · 4 comments

Comments

@GoogleCodeExporter
Copy link

Which version of common_schema are you using? (specify
revision+distribution)

2.2

Which component is failing? (specify the view, function, etc.)

innodb_index_stats

What is the expected output? What do you see instead?

mysql> select * from common_schema.innodb_index_stats;
ERROR 1109 (42S02): Unknown table 'innodb_index_stats' in information_schema

Can you provide with sample data?
N/A

(As of version 1.1), please provide output of
SELECT * FROM common_schema.status

                       project_name: common_schema
                            version: 2.2
                           revision: 523
                       install_time: 2014-05-21 11:00:47
                    install_success: 1
          base_components_installed: 1
 innodb_plugin_components_installed: 1
percona_server_components_installed: 0
              install_mysql_version: 5.6.16-64.2-56-log
                   install_sql_mode: NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION

Please provide any additional information below.

I recently upgraded from Percona server 5.5 to 5.6, and re-installed 
common_schema.

common_schema is expecting innodb_index_stats to be in information_schema, but 
it appears to have moved to the mysql schema instead.

Original issue reported on code.google.com by [email protected] on 21 May 2014 at 5:25

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant