MySQL Lock Management ALTER
[edit] Debug trace for ALTER TABLE
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