MySQL锁机制 你所不了解的一些事儿

锁所不事儿复制T@8: | query: alter table t1 add column k int   T@8: | >mysql_parse   T@8: | | >mysql_execute_command   T@8: | | | >mysql_alter_table   T@8: | | | | >open_ltable   T@8: | | | | | >open_table   T@8: | | | | | <open_table T@8: | | | | | >mysql_lock_tables   T@8: | | | | | | >get_lock_data   T@8: | | | | | | | >ha_innobase::store_lock   T@8: | | | | | | | <ha_innobase::store_lock T@8: | | | | | | <get_lock_data T@8: | | | | | | >lock_external   T@8: | | | | | | | >ha_innobase::external_lock   T@8: | | | | | | | | enter: lock_type: 1   T@8: | | | | | | | | >trans_register_ha   T@8: | | | | | | | | | enter: stmt   T@8: | | | | | | | | <trans_register_ha T@8: | | | | | | | <ha_innobase::external_lock T@8: | | | | | | <lock_external T@8: | | | | | | >thr_multi_lock   T@8: | | | | | | | >thr_lock   T@8: | | | | | | | <thr_lock T@8: | | | | | | <thr_multi_lock T@8: | | | | | <mysql_lock_tables T@8: | | | | <open_ltable T@8: | | | | >mysql_create_table   T@8: | | | | <mysql_create_table T@8: | | | | >open_temporary_table   T@8: | | | | | >openfrm   T@8: | | | | | | >handler::ha_open   T@8: | | | | | | | enter: name: ./test/#sql-3081_1 db_type: 12 db_stat: 7 mode: 2 lock_test: 2   T@8: | | | | | | | >ha_innobase::open   T@8: | | | | | | | <ha_innobase::open T@8: | | | | | | <handler::ha_open T@8: | | | | | <openfrm T@8: | | | | <open_temporary_table T@8: | | | | >copy_data_between_tables   T@8: | | | | <copy_data_between_tables T@8: | | | | >closefrm   T@8: | | | | <closefrm T@8: | | | | >close_cached_table   T@8: | | | | | enter: table: t1   T@8: | | | | | >wait_while_table_is_used   T@8: | | | | | | >get_lock_data   T@8: | | | | | | <get_lock_data T@8: | | | | | | >thr_abort_locks   T@8: | | | | | | <thr_abort_locks T@8: | | | | | | >remove_table_from_cache   T@8: | | | | | | | enter: Table: test.t1 flags: 2   T@8: | | | | | | <remove_table_from_cache T@8: | | | | | <wait_while_table_is_used T@8: | | | | | >mysql_unlock_tables   T@8: | | | | | | >thr_multi_unlock   T@8: | | | | | | | lock: data: 0x8b7f9b0 count: 1   T@8: | | | | | | | >thr_unlock   T@8: | | | | | | | <thr_unlock T@8: | | | | | | <thr_multi_unlock T@8: | | | | | | >unlock_external   T@8: | | | | | | | >ha_innobase::external_lock   T@8: | | | | | | | <ha_innobase::external_lock T@8: | | | | | | <unlock_external T@8: | | | | | <mysql_unlock_tables T@8: | | | | | >unlink_open_table   T@8: | | | | | | >hash_delete   T@8: | | | | | | | >free_cache_entry   T@8: | | | | | | | | >closefrm   T@8: | | | | | | | | | >ha_innobase::close   T@8: | | | | | | | | | <ha_innobase::close T@8: | | | | | | | | <closefrm T@8: | | | | | | | <free_cache_entry T@8: | | | | | | <hash_delete T@8: | | | | | <unlink_open_table T@8: | | | | <close_cached_table T@8: | | | | >mysql_rename_table   T@8: | | | | | >ha_innobase::rename_table   T@8: | | | | | <ha_innobase::rename_table T@8: | | | | <mysql_rename_table T@8: | | | | >mysql_rename_table   T@8: | | | | | >ha_innobase::rename_table   T@8: | | | | | <ha_innobase::rename_table T@8: | | | | <mysql_rename_table T@8: | | | | >my_delete   T@8: | | | | | my: name ./test/#sql2-3081-1.frm MyFlags 0   T@8: | | | | <my_delete T@8: | | | | >ha_delete_table   T@8: | | | | | >ha_innobase::delete_table   T@8: | | | | | <ha_innobase::delete_table T@8: | | | | <ha_delete_table T@8: | | | | >ha_commit_trans  T@8: | | | | <ha_commit_trans T@8: | | | | >ha_commit_trans  T@8: | | | | <ha_commit_trans T@8: | | | <mysql_alter_table T@8: | | <mysql_execute_command T@8: | <mysql_parse T@8: <dispatch_command 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.

本文地址：http://www.bzuk.cn/html/135a6399801.html