Skip to main content
Database Administrators

Return to Answer

Commonmark migration
Source Link
Community Bot
Community Bot
  • 1

#PROBLEM

PROBLEM

mysql.innodb_table_stats is part of the MySQL 5.6 install. mysql_upgrade does not generate them. Why ?

  • When you install MySQL 5.6 from scratch, that file is generated.
  • The file innodb_table_stats.ibd does not exists in the mysql schema in MySQL 5.5
  • MySQL 5.5's mysql_upgrade is not aware of any innodb system tables.
  • In fact, there are five(5) .ibd files in MySQL 5.6 in the mysql schema.

#SOLUTION

SOLUTION

Please look at these posts I wrote last year on how to make them

#Give it a Try !!!

Give it a Try !!!

#PROBLEM

mysql.innodb_table_stats is part of the MySQL 5.6 install. mysql_upgrade does not generate them. Why ?

  • When you install MySQL 5.6 from scratch, that file is generated.
  • The file innodb_table_stats.ibd does not exists in the mysql schema in MySQL 5.5
  • MySQL 5.5's mysql_upgrade is not aware of any innodb system tables.
  • In fact, there are five(5) .ibd files in MySQL 5.6 in the mysql schema.

#SOLUTION

Please look at these posts I wrote last year on how to make them

#Give it a Try !!!

PROBLEM

mysql.innodb_table_stats is part of the MySQL 5.6 install. mysql_upgrade does not generate them. Why ?

  • When you install MySQL 5.6 from scratch, that file is generated.
  • The file innodb_table_stats.ibd does not exists in the mysql schema in MySQL 5.5
  • MySQL 5.5's mysql_upgrade is not aware of any innodb system tables.
  • In fact, there are five(5) .ibd files in MySQL 5.6 in the mysql schema.

SOLUTION

Please look at these posts I wrote last year on how to make them

Give it a Try !!!

replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

#PROBLEM

mysql.innodb_table_stats is part of the MySQL 5.6 install. mysql_upgrade does not generate them. Why ?

  • When you install MySQL 5.6 from scratch, that file is generated.
  • The file innodb_table_stats.ibd does not exists in the mysql schema in MySQL 5.5
  • MySQL 5.5's mysql_upgrade is not aware of any innodb system tables.
  • In fact, there are five(5) .ibd files in MySQL 5.6 in the mysql schema.

#SOLUTION

Please look at these posts I wrote last year on how to make them

#Give it a Try !!!

#PROBLEM

mysql.innodb_table_stats is part of the MySQL 5.6 install. mysql_upgrade does not generate them. Why ?

  • When you install MySQL 5.6 from scratch, that file is generated.
  • The file innodb_table_stats.ibd does not exists in the mysql schema in MySQL 5.5
  • MySQL 5.5's mysql_upgrade is not aware of any innodb system tables.
  • In fact, there are five(5) .ibd files in MySQL 5.6 in the mysql schema.

#SOLUTION

Please look at these posts I wrote last year on how to make them

#Give it a Try !!!

#PROBLEM

mysql.innodb_table_stats is part of the MySQL 5.6 install. mysql_upgrade does not generate them. Why ?

  • When you install MySQL 5.6 from scratch, that file is generated.
  • The file innodb_table_stats.ibd does not exists in the mysql schema in MySQL 5.5
  • MySQL 5.5's mysql_upgrade is not aware of any innodb system tables.
  • In fact, there are five(5) .ibd files in MySQL 5.6 in the mysql schema.

#SOLUTION

Please look at these posts I wrote last year on how to make them

#Give it a Try !!!

Source Link
RolandoMySQLDBA
RolandoMySQLDBA
  • 184.4k
  • 33
  • 323
  • 531

#PROBLEM

mysql.innodb_table_stats is part of the MySQL 5.6 install. mysql_upgrade does not generate them. Why ?

  • When you install MySQL 5.6 from scratch, that file is generated.
  • The file innodb_table_stats.ibd does not exists in the mysql schema in MySQL 5.5
  • MySQL 5.5's mysql_upgrade is not aware of any innodb system tables.
  • In fact, there are five(5) .ibd files in MySQL 5.6 in the mysql schema.

#SOLUTION

Please look at these posts I wrote last year on how to make them

#Give it a Try !!!