Mysql5.6以后，说 innode 的 select 性能不输 myisam 了，为什么 ？

Answer 1

I feel like the poster doesn’t have to worry about this issue. InnoDB is the officially designated default engine of MySQL, and the maintenance efforts are all on InnoDB. It’s not surprising that SELECT performance is better. The third-party Percona Server also chose to launch XtraDB based on InnoDB improvements. So it’s still Try to use InnoDB.

After InnoDB uses an independent table space (innodb_file_per_table=1), each table in each database will generate a data space (.ibd file).
show variables like 'innodb_file_per_table'
It can be seen that Percona Server 5.6 turns on "independent table space" by default.
Independent table Space advantages:
1. Each table has its own independent table space.
2. The data and indexes of each table will be stored in its own table space.
3. A single table can be moved in different databases.
4 .Space can be recycled.

InnoDB table (innodb_file_per_table=1):

/png/percona/5.6/data/wordpress/wp_users.frm 表结构
/png/percona/5.6/data/wordpress/wp_users.ibd 数据和索引

Compare MyISAM table:

/png/percona/5.6/data/mysql/users.frm 表结构
/png/percona/5.6/data/mysql/users.MYD 数据
/png/percona/5.6/data/mysql/users.MYI 索引