Description:
The installation fails to create the following mysql schema tables properly:
innodb_index_stats
innodb_table_stats
slave_master_info
slave_relay_log_info
slave_worker_info
Even thought the .frm files exist (were created as InnoDB), and show tables lists them, they fail with the following error when selecting from them.
ERROR 1146 (42S02): Table 'mysql.<table_from_above>' doesn't exist
How to repeat:
Built from the 5.6.6-m9 source with the following option changes:
CMAKE_CXX_FLAGS -m64 -O3
CMAKE_C_FLAGS -O3 -m64
CMAKE_INSTALL_PREFIX /opt/64bit.mysql5_6_6_perf
INSTALL_PLUGINDIR /opt/64bit.mysql5_6_6_perf/lib/plugin
WITH_INNODB_MEMCACHED ON
WITH_SSL system
make
make install
Linked the install to /usr/local/mysql -> /opt/64bit.mysql5_6_6_perf
Configured my /etc/my.cnf from an existing production version and corrected for changes between 5.1 and 5.6.
cd /opt/64bit.mysql5_6_6_perf
# Note: We are testing on a limited system and needed to put the datadir in /home for this instance.
scripts/mysql_install_db --user=mysql --datadir=/home/mysql2
Log into the database and selected from the tables above.
Suggested fix:
Fix the share/mysql_system_tables.sql script to create the tables properly.
