7fc52806d700 InnoDB: Error: Fetch of persistent statistics requested for table "xxx"."xxx" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. |
将5.5的文件 upgrade成5.6版本(in place upgrade) 1、crash后的实例不应该直接做升级,应该先做crash recovery,然后再做升级 2、之前的percona-server 数据页不是16K的也不建议做升级 3、如果5.5版本中innodb_fast_checksum开启,则无法使用in place upgrade |
1、安装percona5.6版本的server、client、shared 2、使用--skip-grant-tables 启动 3、使用mysql_upgrade升级 4、重启实例(不加--skip-grant-tables,正常启动) If it can’t find the pid file, kill the server and start it normally: $ killall /usr/sbin/mysqld $ /sbin/service mysql start |
mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Running 'mysql_fix_privilege_tables'... ERROR 1010 (HY000) at line 150: Error dropping database (can't rmdir './performance_schema/', errno: 17) ERROR 1007 (HY000) at line 155: Can't create database 'performance_schema'; database exists FATAL ERROR: Upgrade failed |
mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Running 'mysql_fix_privilege_tables'... Running 'mysqlcheck' with connection arguments: '--socket=/data/mysql3307/data/mysqld3307.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Error during call to mysql_check for fixing the db/tables names on all db(s) except mysql |
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。