????????????????????????????????????????????????????????????sql????????????????????????????·??
????1.??????????????′ο?????д?????????????
???????show [session|global] status like '%Com_%'????????????????session??????????global????????????????????????д??session
????| Com_select     | 2     |
????| Com_insert     | 0     |
????| Com_update   | 0     |
????| Com_delete    | 0     |
????????????????д????????е?洢???涼??????????
????show [session|global] status like '%Innodb_rows_%'
????+----------------------+-------+
????| Variable_name | Value |
????+----------------------+-------+
????| Innodb_rows_deleted | 0 |
????| Innodb_rows_inserted | 7 |
????| Innodb_rows_read | 6 |
????| Innodb_rows_updated | 0 |
????+----------------------+-------+
?????????????innodb??????
???????????????????????????????????????д?????????2?????commit??rollback?????????1
????Com_commit??Com_rollback?У????????????????????????
????2.??????????λЧ????sql??????????????????????У?
??????1???????????????5.6????slow_query_log_file?в??????????????????????????????????????????????Ч??????????????????????????????????е???仹?д?????
??????2??????????????????? show processlist?????MySQL???е??????????????????????????????SQL?????????????Щ??????????????
????3.???explain????Ч????μ? sql??м????
???????????????????Ч??????sql???????explain????desc???????Ч????μ?sql????м??
????4.????????ó?????????Ч?????????
???????????????????ó??????????????????????裬????????????????????????Ч??