
锁所不事儿
复制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.