| >mysql_prepare_alter_table
T@4 : | | | | | | <mysql_prepare_alter_table 7368
T@4 : | | | | | | >create_table_impl
T@4 : | | | | | | | enter: db: 'test' table: '#sql-1550_1' tmp: 1
T@4 : | | | | | | | <mysql_prepare_create_table 4295
T@4 : | | | | | | | | enter: db: test, name: #sql-1550_1
T@4 : | | | | | | | | >mysql_create_frm
T@4 : | | | | | | | | | | my: Name: './test/#sql-1550_1.frm' CreateFlags: 0 AccessFlags: 514 MyFlags: 0
T@4 : | | | | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/sql_table.cc:4999
T@4 : | | | | | | | enter: table: 'test'.'#sql-1550_1' path: './test/#sql-1550_1' server_id: 0 pseudo_thread_id: 1
T@4 : | | | | | | | | enter: table: 'test'.'#sql-1550_1'
T@4 : | | | | | | | >open_table_def
T@4 : | | | | | | | | enter: table: 'test'.'#sql-1550_1' path: './test/#sql-1550_1'
T@4 : | | | | | | | | >my_open
T@4 : | | | | | | | | | my: Name: './test/#sql-1550_1.frm' Flags: 0 MyFlags: 0
T@4 : | | | | | | | tmptable: opened table: 'test'.'#sql-1550_1' 0x25d8c50
T@4 : | | | | | | >mysql_inplace_alter_table
T@4 : | | | | | | | >MDL_context::upgrade_shared_lock
T@4 : | | | | | | | <MDL_context::upgrade_shared_lock 2454
T@4 : | | | | | | | >lock_tables
T@4 : | | | | | | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/lock.cc:304
T@4 : | | | | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/sql_table.cc:6547
T@4 : | | | | | | | >prepare_inplace_alter_table
T@4 : | | | | | | | <prepare_inplace_alter_table 3883
T@4 : | | | | | | | >prepare_inplace_alter_table_dict
T@4 : | | | | | | | <prepare_inplace_alter_table_dict 3093
T@4 : | | | | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/sql_table.cc:6601
T@4 : | | | | | | | >inplace_alter_table
T@4 : | | | | | | | | >row_merge_build_indexes
T@4 : | | | | | | | | | >create_temp_file
T@4 : | | | | | | | | | | enter: dir: /tmp, prefix: ib
T@4 : | | | | | | | | | <create_temp_file 176
T@4 : | | | | | | | | | >create_temp_file
T@4 : | | | | | | | | | | enter: dir: /tmp, prefix: ib
T@4 : | | | | | | | | | <create_temp_file 176
T@4 : | | | | | | | <inplace_alter_table 3920
T@4 : | | | | | | | | enter: table: 'rr' share: 0x2456820 db_stat: 39 version: 1
T@4 : | | | | | | | | >MDL_context::upgrade_shared_lock
T@4 : | | | | | | | | <MDL_context::upgrade_shared_lock 2454
T@4 : | | | | | | | <wait_while_table_is_used 2305
T@4 : | | | | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/sql_table.cc:6628
T@4 : | | | | | | | >commit_inplace_alter_table
T@4 : | | | | | | | | <commit_try_rebuild 4985
T@4 : | | | | | | | | >commit_cache_rebuild
T@4 : | | | | | | | | >row_drop_table_for_mysql
T@4 : | | | | | | | | | row_drop_table_for_mysql: table: test/#sql-ib217-293563242
T@4 : | | | | | | | | <row_drop_table_for_mysql 4376
T@4 : | | | | | | | | >alter_stats_rebuild
T@4 : | | | | | | | | | >dict_stats_analyze_index
T@4 : | | | | | | | | | | info: index: GEN_CLUST_INDEX, online status: 0
T@4 : | | | | | | | | | <dict_stats_analyze_index 1977
T@4 : | | | | | | | | <alter_stats_rebuild 5400
T@4 : | | | | | | | <commit_inplace_alter_table 6018
T@4 : | | | | | | | >close_temporary_table
T@4 : | | | | | | | | tmptable: closing table: 'test'.'#sql-1550_1' 0x25d8c50 alias: '#sql-1550_1'
T@4 : | | | | | | | | >close_temporary
T@4 : | | | | | | | | | tmptable: closing table: 'test'.'#sql-1550_1'
T@4 : | | | | | | | | | <closefrm 2477
T@4 : | | | | | | | | | >free_table_share
T@4 : | | | | | | | | | | enter: table: test.#sql-1550_1
T@4 : | | | | | | | | | | >TABLE_SHARE::destroy
T@4 : | | | | | | | | | | | info: db: test table: #sql-1550_1
T@
T@4 : | | | | | | | | | | <TABLE_SHARE::destroy 487
T@4 : | | | | | | | | <close_temporary 2241
T@4 : | | | | | | | <close_temporary_table 2213
T@4 : | | | | | | | >mysql_rename_table
T@4 : | | | | | | | | enter: old: 'test'.'#sql-1550_1' new: 'test'.'rr'
T@4 : | | | | | | | |
T@4 : | | | | | | | | >build_table_filename
T@4 : | | | | | | | | | enter: db: 'test' table_name: '#sql-1550_1' ext: '' flags: 1
T@4 : | | | | | | | | | >tablename_to_filename
T@4 : | | | | | | | | | <tablename_to_filename 512
T@4 : | | | | | | | | | exit: buff: './test/#sql-1550_1'
T@4 : | | | | | | | | <build_table_filename 612
T@4 : | | | | | | | | >build_table_filename
T@4 : | | | | | | | | | enter: db: 'test' table_name: 'rr' ext: '' flags: 0
T@4 : | | | | | | | | | >tablename_to_filename
T@4 : | | | | | | | | | | enter: from 'rr'
T@4 : | | | | | | | | | | >check_if_legal_tablename
T@4 : | | | | | | | | | | <check_if_legal_tablename 155
T@4 : | | | | | | | | | | exit: to 'rr'
T@4 : | | | | | | | | | <tablename_to_filename 512
T@4 : | | | | | | | | | >tablename_to_filename
T@4 : | | | | | | | | | | enter: from 'test'
T@4 : | | | | | | | | | | >check_if_legal_tablename
T@4 : | | | | | | | | | | <check_if_legal_tablename 155
T@4 : | | | | | | | | | | exit: to 'test'
T@4 : | | | | | | | | | <tablename_to_filename 512
T@4 : | | | | | | | | | exit: buff: './test/rr'
T@4 : | | | | | | | | <build_table_filename 612
T@4 : | | | | | | | | >my_rename
T@4 : | | | | | | | | | my: from ./test/#sql-1550_1.frm to ./test/rr.frm MyFlags 16
T@4 : | | | | | | | | <my_rename 82
T@4 : | | | | | | | <mysql_rename_table 5291
T@4 : | | | | | | | | | | | enter: table: 'test'.'rr'
T@4 : | | | | | | | | | | | >build_table_filename
T@4 : | | | | | | | | | | | | enter: db: 'test' table_name: 'rr' ext: '' flags: 0
T@4 : | | | | | | | | | | | | >tablename_to_filename
T@4 : | | | | | | | | | | | | | enter: from 'rr'
T@4 : | | | | | | | | | | | | | >check_if_legal_tablename
T@4 : | | | | | | | | | | | | | <check_if_legal_tablename 155
T@4 : | | | | | | | | | | | | | exit: to 'rr'
T@4 : | | | | | | | | | | | | <tablename_to_filename 512
T@4 : | | | | | | | | | | | | >tablename_to_filename
T@4 : | | | | | | | | | | | | | enter: from 'test'
T@4 : | | | | | | | | | | | | | >check_if_legal_tablename
T@4 : | | | | | | | | | | | | | <check_if_legal_tablename 155
T@4 : | | | | | | | | | | | | | exit: to 'test'
T@4 : | | | | | | | | | | | | <tablename_to_filename 512
T@4 : | | | | | | | | | | | | exit: buff: './test/rr'
T@4 : | | | | | | | | | | | <build_table_filename 612
T@4 : | | | | | | | | | | >open_table_def
T@4 : | | | | | | | | | | | enter: table: 'test'.'rr' path: './test/rr'
T@4 : | | | | | | | | | | | >my_open
T@4 : | | | | | | | | | | | | my: Name: './test/rr.frm' Flags: 0 MyFlags: 0
T@4 : | | | | | | | | | | enter: name: ./test/rr db_type: 12 db_stat: 39 mode: 2 lock_test: 2
T@4 : | | | | | | | | | | info: old m_lock_type: 2 F_UNLCK 2
T@4 : | | | | | | | | | | >ha_innobase::open
T@4 : | | | | | | | | | | | >list_add
T@4 : | | | | | | | | | | | | enter: root: 0x22d5080 element: 0x22d5880
T@4 : | | | | | | | | | | | <list_add 41
T@4 : | | | | | | | | | | | >innobase_build_index_translation
T@4 : | | | | | | | | | | | <innobase_build_index_translation 4547
T@4 : | | | | | | | | | | | >info
T@4 : | | | | | | | | | | | | >ha_innobase::update_thd
T@4 : | | | | | | | | | | | | | ha_innobase::update_thd: user_thd: 0x0 -> 0x22f4980
T@4 : | | | | | | | | | | | | | >innobase_trx_init
T@4 : | | | | | | | | | | | | | <innobase_trx_init 2042
T@4 : | | | | | | | | | | | | <ha_innobase::update_thd 2274
T@4 : | | | | | | | | | | | | >unpack_filename
T@4 : | | | | | | | | | | | | | >dirname_part
T@4 : | | | | | | | | | | | | | | enter: '././test/rr.frm'
T@4 : | | | | | | | | | | | | | | >convert_dirname
T@4 : | | | | | | | | | | | | | | <convert_dirname 153
T@4 : | | | | | | | | | | | | | <dirname_part 71
T@4 : | | | | | | | | | | | | | >unpack_dirname
T@4 : | | | | | | | | | | | | | | >normalize_dirname
T@4 : | | | | | | | | | | | | | | | >dirname_part
T@4 : | | | | | | | | | | | | | | | | enter: '././test/'
T@4 : | | | | | | | | | | | | | | | | >convert_dirname
T@4 : | | | | | | | | | | | | | | | | <convert_dirname 153
T@4 : | | | | | | | | | | | | | | | <dirname_part 71
T@4 : | | | | | | | | | | | | | | | >cleanup_dirname
T@4 : | | | | | | | | | | | | | | | | enter: from: '././test/'
T@4 : | | | | | | | | | | | | | | | | exit: to: './test/'
T@4 : | | | | | | | | | | | | | | | <cleanup_dirname 227
T@4 : | | | | | | | | | | | | | | <normalize_dirname 321
T@4 : | | | | | | | | | | | | | <unpack_dirname 376
T@4 : | | | | | | | | | | | | <unpack_filename 442
T@4 : | | | | | | | | | | | <info 11163
T@4 : | | | | | | | | | | <ha_innobase::open 5064
T@4 : | | | | | | | | | | >innobase_trx_init
T@4 : | | | | | | | | | | <innobase_trx_init 2042
T@4 : | | | | | | | | | | >alloc_root
T@4 : | | | | | | | | | | | enter: root: 0x260e9f0
T@4 : | | | | | | | | | | | exit: ptr: 0x2456ab0
T@4 : | | | | | | | | | | <alloc_root 247
T@4 : | | | | | | | | | <handler::ha_open 2551
T@4 : | | | | | | | | <open_table_from_share 2415
T@4 : | | | | | | | | >Table_triggers_list::check_n_load
T@4 : | | | | | | | | | >build_table_filename
T@4 : | | | | | | | | | | enter: db: 'test' table_name: 'rr' ext: '.TRG' flags: 0
T@4 : | | | | | | | | | | >tablename_to_filename
T@4 : | | | | | | | | | | | enter: from 'rr'
T@4 : | | | | | | | | | | | >check_if_legal_tablename
T@4 : | | | | | | | | | | | <check_if_legal_tablename 155
T@4 : | | | | | | | | | | | exit: to 'rr'
T@4 : | | | | | | | | | | <tablename_to_filename 512
T@4 : | | | | | | | | | | >tablename_to_filename
T@4 : | | | | | | | | | | | enter: from 'test'
T@4 : | | | | | | <mysql_inplace_alter_table 6708
T@4 : | | | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/sql_table.cc:8732
T@4 : | | | | <Sql_cmd_alter_table::execute 315
T@4 : | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/sql_parse.cc:4996
T@4 : | | | | >trans_commit_stmt
T@4 : | | | | | enter: stmt.ha_list: DB_TYPE_INNODB, all.ha_list: <NONE>
T@4 : | | | | | enter: stmt.ha_list: DB_TYPE_INNODB, all.ha_list: <NONE>
T@4 : | | | | | >ha_commit_trans
T@4 : | | | | | | info: all=0 thd->in_sub_stmt=0 ha_info=0x22f5e00 is_real_trans=1
T@4 : | | | | | | debug: Acquire MDL commit lock
T@4 : | | | | | | >ha_commit_low
T@4 : | | | | | | | >innobase_commit
T@4 : | | | | | | | | trans: ending transaction
T@4 : | | | | | | | | >innobase_trx_init
T@4 : | | | | | | | | <innobase_trx_init 2042
T@4 : | | | | | | | | >THD::get_trans_pos
T@4 : | | | | | | | | | return: file: (null), pos: 0
T@4 : | | | | | | | | <THD::get_trans_pos 2979
T@4 : | | | | | | | <innobase_commit 3585
T@4 : | | | | | | | >Ha_trx_info::reset
T@4 : | | | | | | | <Ha_trx_info::reset 1156
T@4 : | | | | | | <ha_commit_low 1535
T@4 : | | | | | | debug: Releasing MDL commit lock
T@4 : | | | | | | >MDL_context::release_lock
T@4 : | | | | | | | enter: db= name=
T@4 : | | | | | | <MDL_context::release_lock 2731
T@4 : | | | | | | >THD::st_transaction::cleanup
T@4 : | | | | | | | >free_root
T@4 : | | | | | | | | enter: root: 0x22f6130 flags: 1
T@4 : | | | | | | | <free_root 396
T@4 : | | | | | | <THD::st_transaction::cleanup 2521
T@4 : | | | | | <ha_commit_trans 1458
T@4 : | | | | | debug: reset_unsafe_rollback_flags
T@4 : | | | | <trans_commit_stmt 446
T@4 : | | | | >st_select_lex_unit::cleanup
T@4 : | | | | | >st_select_lex::cleanup()
T@4 : | | | | | <st_select_lex::cleanup() 1022
T@4 : | | | | <st_select_lex_unit::cleanup 847
T@4 : | | | | THD::enter_stage: /usr/src/mysql-5.6.28/sql/sql_parse.cc:5044
T@4 : | | | | >PROFILING::status_change
T@4 : | | | | <PROFILING::status_change 354
T@4 : | | | | | >mysql_unlock_tables
T@4 : | | | | | | >my_free
T@4 : | | | | | | | my: ptr: 0x22c9230
T@4 : | | | | | | <my_free 141
T@4 : | | | | | <mysql_unlock_tables 391
T@4 : | | | | <close_thread_tables 1469
T@4 : | | | | >stmt_causes_implicit_commit
T@4 : | | | | <stmt_causes_implicit_commit 274
T@4 : | | | | >trans_commit_implicit
T@4 : | | | | | enter: stmt.ha_list: <NONE>, all.ha_list: <NONE>
T@4 : | | | | | debug: stmt.unsafe_rollback_flags:
T@4 : | | | | | debug: all.unsafe_rollback_flags:
T@4 : | | | | | >ha_commit_low
T@4 : | | | | | | >THD::st_transaction::cleanup
T@4 : | | | | | | | >free_root
T@4 : | | | | | | | | enter: root: 0x22f6130 flags: 1
T@4 : | | | | | | | <free_root 396
T@4 : | | | | | | <THD::st_transaction::cleanup 2521
T@4 : | | | | | <ha_commit_low 1535
T@4 : | | | | | debug: reset_unsafe_rollback_flags
T@4 : | | | | <trans_commit_implicit 298
T@4 : | | | | >MDL_context::release_transactional_locks
T@4 : | | | | | >MDL_context::release_locks_stored_before
T@4 : | | | | | | info: found lock to release ticket=0x22e5d90
T@4 : | | | | | | >MDL_context::release_lock
T@4 : | | | | | | | enter: db= name=
T@4 : | | | | | | <MDL_context::release_lock 2731
T@4 : | | | | | <MDL_context::release_locks_stored_before 2779
T@4 : | | | | | >MDL_context::release_locks_stored_before
T@4 : | | | | | | info: found lock to release ticket=0x22c91e0
T@4 : | | | | | | >MDL_context::release_lock
T@4 : | | | | | | | enter: db=test name=rr
T@4 : | | | | | | | >my_hash_delete
T@4 : | | | | | | | <my_hash_delete 604
T@4 : | | | | | | <MDL_context::release_lock 2731
T@4 : | | | | | | info: found lock to release ticket=0x22eb6d0
T@4 : | | | | | | >MDL_context::release_lock
T@4 : | | | | | | | enter: db=test name=
T@4 : | | | | | | | >my_hash_delete
T@4 : | | | | | | | <my_hash_delete 604
T@4 : | | | | | | <MDL_context::release_lock 2731
T@4 : | | | | | <MDL_context::release_locks_stored_before 2779
T@4 : | | | | <MDL_context::release_transactional_locks 2926
T@4 : | | | <mysql_execute_command 5092
T@4 : | | | opt: steps: ending struct
T@4 : | | | opt: (null): ending struct
T@4 : | | | >~opt_trace_start
T@4 : | | | | >my_malloc
T@4 : | | | | | my: size: 8 my_flags: 16
T@4 : | | | | | exit: ptr: 0x22b3b50
T@4 : | | | | <my_malloc 66
Complete optimizer trace: