5.7だと↓だったのが、
mysql57> SELECT table_name, engine FROM information_schema.tables WHERE table_schema = 'mysql' ORDER BY table_name; +---------------------------+--------+ | table_name | engine | +---------------------------+--------+ | columns_priv | MyISAM | | db | MyISAM | | engine_cost | InnoDB | | event | MyISAM | | func | MyISAM | | general_log | CSV | | gtid_executed | InnoDB | | help_category | InnoDB | | help_keyword | InnoDB | | help_relation | InnoDB | | help_topic | InnoDB | | innodb_index_stats | InnoDB | | innodb_table_stats | InnoDB | | ndb_binlog_index | MyISAM | | plugin | InnoDB | | proc | MyISAM | | procs_priv | MyISAM | | proxies_priv | MyISAM | | servers | InnoDB | | server_cost | InnoDB | | slave_master_info | InnoDB | | slave_relay_log_info | InnoDB | | slave_worker_info | InnoDB | | slow_log | CSV | | tables_priv | MyISAM | | time_zone | InnoDB | | time_zone_leap_second | InnoDB | | time_zone_name | InnoDB | | time_zone_transition | InnoDB | | time_zone_transition_type | InnoDB | | user | MyISAM | +---------------------------+--------+ 31 rows in set (0.01 sec)
↓が8.0.0
mysql80> SELECT table_name, engine FROM information_schema.tables WHERE table_schema = 'mysql' ORDER BY table_name; +---------------------------+--------+ | TABLE_NAME | ENGINE | +---------------------------+--------+ | column_stats | InnoDB | | columns_priv | InnoDB | | component | InnoDB | | db | InnoDB | | default_roles | InnoDB | | engine_cost | InnoDB | | func | InnoDB | | general_log | CSV | | gtid_executed | InnoDB | | help_category | InnoDB | | help_keyword | InnoDB | | help_relation | InnoDB | | help_topic | InnoDB | | innodb_index_stats | InnoDB | | innodb_table_stats | InnoDB | | plugin | InnoDB | | procs_priv | InnoDB | | proxies_priv | InnoDB | | role_edges | InnoDB | | server_cost | InnoDB | | servers | InnoDB | | slave_master_info | InnoDB | | slave_relay_log_info | InnoDB | | slave_worker_info | InnoDB | | slow_log | CSV | | tables_priv | InnoDB | | time_zone | InnoDB | | time_zone_leap_second | InnoDB | | time_zone_name | InnoDB | | time_zone_transition | InnoDB | | time_zone_transition_type | InnoDB | | user | InnoDB | +---------------------------+--------+ 32 rows in set (0.02 sec)
general_log, slow_logは相変わらずとして、それ以外はInnoDBになった。
column_stats, component, default_roles, role_edgesが新設テーブル、ndb_binlog_index, event, procがなくなってる。ndb_binlog_indexはコンパイル方法が違うのかとも思うけど取り敢えず置いておく。
あと、mysqld --initializeした中でも、 **InnoDB: Creating foreign key constraint system tables.** って書いてあるので、おおおって感じがした。
$ bin/mysqld --no-defaults --initialize-insecure --basedir=./ --datadir=./data 2016-09-05T01:17:12.549926Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2016-09-05T01:17:12.550002Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2016-09-05T01:17:12.550282Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-09-05T01:17:12.842536Z 1 [Warning] InnoDB: New log files created, LSN=49311 2016-09-05T01:17:12.890633Z 1 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-09-05T01:17:14.176756Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7a644122-7306-11e6-bba7-02018582356a. 2016-09-05T01:17:14.185156Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-09-05T01:17:14.185650Z 3 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
0 件のコメント :
コメントを投稿