22 - 内存 - 内存管理buffer

主要是innodb和myisam表

show variables like "%buffer%";
+-----------------------------------------------------+--------------------+
| Variable_name                                          | Value               |
+-----------------------------------------------------+--------------------+
| bulk_insert_buffer_size                            | 8388608            |
| innodb_buffer_pool_chunk_size                | 33554432          |
| innodb_buffer_pool_dump_at_shutdown   | ON                   |
| innodb_buffer_pool_dump_now                | OFF                  |
| innodb_buffer_pool_dump_pct                 | 25                    |
| innodb_buffer_pool_filename                   | ib_buffer_pool |
| innodb_buffer_pool_instances                  | 1                      |
| innodb_buffer_pool_load_abort                | OFF                  |
| innodb_buffer_pool_load_at_startup        | ON                    |
| innodb_buffer_pool_load_now                  | OFF                  |
| innodb_buffer_pool_size                           | 67108864         |
| innodb_change_buffer_max_size               | 25                    |
| innodb_change_buffering                         | all                     |
| innodb_log_buffer_size                            | 16777216           |
| innodb_sort_buffer_size                           | 1048576            |
| join_buffer_size                                       | 262144              |
| key_buffer_size                                        | 8388608            |
| myisam_sort_buffer_size                          | 8388608            |
| net_buffer_length                                    | 16384               |
| preload_buffer_size                                 | 32768                |
| read_buffer_size                                      | 131072              |
| read_rnd_buffer_size                               | 262144              |
| sort_buffer_size                                       | 262144              |
| sql_buffer_result                                      | OFF                  |
+-----------------------------------------------------+---------------------+