MySQL索引

B+树

常见命令

• 查看磁盘页大小

mysql> select * from performance_schema.global_status where VARIABLE_NAME = 'Innodb_page_size';
+------------------+----------------+
| VARIABLE_NAME    | VARIABLE_VALUE |
+------------------+----------------+
| Innodb_page_size | 16384          |
+------------------+----------------+

概念