mysql block_MYSQL：SQL 一个语句引发的思考

mysql> show profile cpu,block io for query 1;

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

| Status | Duration | CPU_user | CPU_system | Block_ops_in | Block_ops_out |

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

| starting | 0.000086 | 0.006999 | 0.001000 | 0 | 0 |

| Waiting for query cache lock | 0.000010 | 0.000000 | 0.000000 | 0 | 0 |

| checking query cache for query | 0.000116 | 0.000000 | 0.000000 | 0 | 0 |

| checking permissions | 0.000022 | 0.000000 | 0.000000 | 0 | 0 |

| Opening tables | 0.000050 | 0.000000 | 0.000000 | 0 | 0 |

| System lock | 0.000018 | 0.000000 | 0.000000 | 0 | 0 |

| Waiting for query cache lock | 0.000046 | 0.000000 | 0.000000 | 0 | 0 |

| init | 0.000079 | 0.000000 | 0.000000 | 0 | 0 |

| optimizing | 0.000031 | 0.000000 | 0.000000 | 0 | 0 |

| statistics | 0.000278 | 0.000000 | 0.000000 | 0 | 0 |

| preparing | 0.000053 | 0.000000 | 0.000000 | 0 | 0 |

| executing | 0.000009 | 0.000000 | 0.000000 | 0 | 0 |

| Sorting result | 0.000010 | 0.000000 | 0.000000 | 0 | 0 |

| Sending data | 1.004451 | 8.090770 | 0.018997 | 0 | 0 |

| end | 0.000035 | 0.000000 | 0.000000 | 0 | 0 |

| query end | 0.000008 | 0.000000 | 0.000000 | 0 | 0 |

| closing tables | 0.000010 | 0.000000 | 0.000000 | 0 | 0 |

| freeing items | 0.000063 | 0.000000 | 0.000000 | 0 | 0 |

| logging slow query | 0.000006 | 0.000000 | 0.000000 | 0 | 0 |

| cleaning up | 0.000006 | 0.000000 | 0.000000 | 0 | 0 |

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

20 rows in set (0.00 sec)