mysql数据更新磁盘扇区_MySQL InnoDB磁盘I/O优化

一、影响SQL执行性能因素

影响SQL执行性能的关键就在于磁盘，数据库优化大部分工作都是在做磁盘的优化，比如尽可能把随机读写转换为顺序读写、预读、加大buffer pool、优化SQL尽量无磁盘操作等。

mysql> show global status like 'i%read%';

+---------------------------------------+---------+

| Variable_name | Value |

+---------------------------------------+---------+

| Innodb_buffer_pool_read_ahead_rnd | 0 |

| Innodb_buffer_pool_read_ahead | 0 |

| Innodb_buffer_pool_read_ahead_evicted | 0 |

| Innodb_buffer_pool_read_requests | 27334 |

| Innodb_buffer_pool_reads | 465 |

| Innodb_data_pending_reads | 0 |

| Innodb_data_read | 9687552 |

| Innodb_data_reads | 718 |

| Innodb_pages_read | 464 |

| Innodb_rows_read | 6601 |

+---------------------------------------+---------+

10 rows in set (0.04 sec)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

mysql>showglobalstatuslike'i%read%';

+---------------------------------------+---------+

|Variable_name|Value|

+---------------------------------------+---------+

|Innodb_buffer_pool_read_ahe