Count nsec Lock Caller ------------------------------------------------------------------------------- 45 85202629 mysqld`LOCK_open mysqld`__1cKopen_table6FpnDTHD_pnKTABLE_LIST_pnLst_mem_root_pnWenum_open_table_action_I_b_+0x430 15 218494585 mysqld`LOCK_open mysqld`__1cbAmysql_create_table_no_lock6FpnDTHD_pkc3pnYst_ha_create_information_pnKAlter_info_bI_b_+0x65c 42 52243359 mysqld`LOCK_open mysqld`__1cRclose_open_tables6FpnDTHD__v_+0x18 7707 236582 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 6887 198023 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 9156 140705 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 6653 151630 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 1367 213248 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 1787 74346 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 966 136251 mysqld`LOCK_mdl mysqld`__1cRmdl_release_locks6FpnLMDL_CONTEXT__v_+0x20 1000 127324 mysqld`LOCK_mdl mysqld`__1cXmdl_acquire_shared_lock6FpnLMDL_CONTEXT_pnNMDL_LOCK_DATA_pb_b_+0x4c 3527 35269 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 1459 73143 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 3287 31184 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 582 165293 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 304 219582 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 359 114253 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 542 49411 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 180 139512 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 140 136471 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 333 55408 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 105 147739 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 123 124039 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 118 117817 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 99 115025 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 463 19054 mysqld`LOCK_mdl mysqld`__1cXmdl_acquire_shared_lock6FpnLMDL_CONTEXT_pnNMDL_LOCK_DATA_pb_b_+0x4c 354 21393 mysqld`LOCK_mdl mysqld`__1cRmdl_release_locks6FpnLMDL_CONTEXT__v_+0x20 127 57909 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 27 262388 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 30 189195 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 133 34767 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 32 137191 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 16 238638 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 25 128705 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 11 252042 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 43 57857 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 48 51441 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 11 203684 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 11 201867 mysqld`LOCK_thread_count mysqld`__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0x78 56 37652 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 42 47320 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 33 46204 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 10 135218 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 40 32832 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 14 93054 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 6 211305 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 30 42257 0x101c21000 mysqld`__1cFMute mysqld`__1cFMutexElock6M_v_+0x4 10 103454 mysqld`$XAhc3nBMN5XJWfX.memoryManager+0xf8 mysqld`__1cFMutexElock6M_v_+0x4 15 66655 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 9 110018 mysqld`$XAhc3nBh24XJWaT.LOCK_alarm mysqld`thr_end_alarm+0x30 11 88237 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 3 281764 mysqld`LOCK_thread_count mysqld`__1cKunlink_thd6FpnDTHD__v_+0x58 3 270451 mysqld`LOCK_plugin mysqld`__1cVplugin_thdvar_cleanup6FpnDTHD__v_+0x14 3 252915 mysqld`LOCK_open mysqld`__1cYtable_share_release_hook6Fpv_v_+0x10 6 114466 mysqld`$XAhc3nBh24XJWaT.LOCK_alarm mysqld`thr_alarm+0x44 10 59179 0x101ca05d0 libc.so.1`cond_timedwait+0x14 7 83365 mysqld`$XAhc3nBMN5XJWfX.recordManager+0xf8 mysqld`__1cFMutexElock6M_v_+0x4 5 108320 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 4 122768 mysqld`query_cache+0x68 mysqld`__1cLQdDuery_cacheQinvalidate_table6MpnDTHD_pCI_v_+0x8 7 62245 0x101ca06e0 libc.so.1`cond_timedwait+0x14 2 193036 mysqld`LOCK_thread_count mysqld`__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0x11c8 2 182931 0x101c21000 mysqld`__1cFMutexElock6M_v_+0x4 14 24501 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 6 50853 0x101ca04c0 libc.so.1`cond_timedwait+0x14 10 26909 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 2 128947 mysqld`LOCK_global_read_lock mysqld`__1cYwait_if_global_read_lock6FpnDTHD_bb_b_+0x24 6 41481 mysqld`$XAhc3nBh24XJWaT.LOCK_alarm mysqld`thr_end_alarm+0x30 5 49667 0x101ca02a0 libc.so.1`cond_timedwait+0x14 3 77837 0x101c9e918 mysqld`__1cFMutexElock6M_v_+0x4 4 57114 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 3 65974 mysqld`LOCK_plugin mysqld`__1cSplugin_unlock_list6FpnDTHD_ppnNst_plugin_int_I_v_+0x1c 15 12938 0x101ca03b0 libc.so.1`cond_timedwait+0x14 3 54222 0x101ca03b0 libc.so.1`cond_timedwait+0x14 2 59531 0x1104b7ce0 libc.so.1`cond_timedwait+0x14 7 14937 mysqld`$XAhc3nBh24XJWaT.LOCK_alarm mysqld`thr_alarm+0x44 2 51403 0x1104b7ac0 libc.so.1`cond_timedwait+0x14 2 51348 0x1104b8670 libc.so.1`cond_timedwait+0x14 1 92921 0x1104b8230 libc.so.1`cond_timedwait+0x14 6 14974 mysqld`$XAhc3nBMN5XJWfX.recordManager+0xf8 mysqld`__1cFMutexElock6M_v_+0x4 6 14864 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 1 88088 mysqld`LOCK_thread_count mysqld`__1cQclose_connection6FpnDTHD_Ib_v_+0x1c 1 84573 libc.so.1`_uberdata libc.so.1`_lwp_start 1 83036 mysqld`LOCK_global_read_lock mysqld`__1cbEstart_waiting_global_read_lock6FpnDTHD__v_+0x2c 6 13125 0x101ca04c0 libc.so.1`cond_timedwait+0x14 3 24676 mysqld`query_cache+0x68 mysqld`__1cLQdDuery_cacheQinvalidate_table6MpnDTHD_pCI_v_+0x8 1 70294 0x101ca04c0 mysqld`__1cLSynchronizeEwake6M_v_+0x8 5 13795 mysqld`$XAhc3nBMN5XJWfX.memoryManager+0xf8 mysqld`__1cFMutexElock6M_v_+0x4 1 63155 0x1104b8340 libc.so.1`cond_timedwait+0x14 1 60300 0x1104b7bd0 libc.so.1`cond_timedwait+0x14 1 53161 0x1104b79b0 libc.so.1`cond_timedwait+0x14 1 52721 0x1104b7df0 libc.so.1`cond_timedwait+0x14 1 52611 0x101ca02a0 mysqld`__1cLSynchronizeEwake6M_v_+0x8 3 17427 mysqld`LOCK_thread_count mysqld`__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0x78 1 50524 0x1104b8120 libc.so.1`cond_timedwait+0x14 1 48876 0x101ca04c0 mysqld`__1cLSynchronizeEwake6M_v_+0x8 3 14864 mysqld`LOCK_plugin mysqld`__1cSplugin_unlock_list6FpnDTHD_ppnNst_plugin_int_I_v_+0x1c 2 21692 0x101ca05d0 libc.so.1`cond_timedwait+0x14 1 41189 mysqld`LOCK_global_read_lock mysqld`__1cYwait_if_global_read_lock6FpnDTHD_bb_b_+0x24 1 40749 0x101ca03b0 mysqld`__1cLSynchronizeEwake6M_v_+0x8 3 13436 0x1104b8560 libc.so.1`cond_timedwait+0x14 1 40309 0x1104b8560 libc.so.1`cond_timedwait+0x14 3 13400 0x101ca02a0 libc.so.1`cond_timedwait+0x14 3 13363 mysqld`LOCK_open mysqld`__1cKopen_table6FpnDTHD_pnKTABLE_LIST_pnLst_mem_root_pnWenum_open_table_action_I_b_+0x430 3 13253 mysqld`LOCK_global_read_lock mysqld`__1cYwait_if_global_read_lock6FpnDTHD_bb_b_+0x24 3 13217 0x1104b7ac0 libc.so.1`cond_timedwait+0x14 3 12777 0x1104b78a0 libc.so.1`cond_timedwait+0x14 1 38223 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 1 37783 0x1104b8780 libc.so.1`cond_timedwait+0x14 1 36355 0x1104b7f00 libc.so.1`cond_timedwait+0x14 3 11972 0x1104b7df0 libc.so.1`cond_timedwait+0x14 2 15377 mysqld`LOCK_global_read_lock mysqld`__1cbEstart_waiting_global_read_lock6FpnDTHD__v_+0x2c 2 14333 0x101ca06e0 libc.so.1`cond_timedwait+0x14 2 13949 mysqld`LOCK_thread_count mysqld`__1cQclose_connection6FpnDTHD_Ib_v_+0x1c 2 12466 0x1104b8670 libc.so.1`cond_timedwait+0x14 2 12246 0x1104b7790 libc.so.1`cond_timedwait+0x14 2 11972 mysqld`query_cache+0x68 mysqld`__1cLQdDuery_cacheQinvalidate_table6MpnDTHD_pCI_v_+0x68 1 15816 0x101ca05d0 mysqld`__1cLSynchronizeEwake6M_v_+0x8 1 15597 0x101c1ed70 mysqld`__1cFMutexElock6M_v_+0x4 1 14058 libc.so.1`_uberdata libc.so.1`_lwp_start 1 13290 0x101ca03b0 mysqld`__1cLSynchronizeEwake6M_v_+0x8 1 13180 0x1104b8230 libc.so.1`cond_timedwait+0x14 1 12521 0x1104b8010 libc.so.1`cond_timedwait+0x14 1 12521 mysqld`LOCK_open mysqld`__1cRclose_open_tables6FpnDTHD__v_+0x18 1 12082 0x1104b8780 libc.so.1`cond_timedwait+0x14 1 11863 0x101c95388 mysqld`__1cFMutexElock6M_v_+0x4 1 11753 0x101ca06e0 mysqld`__1cLSynchronizeEwake6M_v_+0x8 1 11642 mysqld`LOCK_thread_count mysqld`__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0x11c8 R/W reader block Count nsec Lock Caller ------------------------------------------------------------------------------- 160000 171886 mysqld`LOCK_grant mysqld`__1cLcheck_grant6FpnDTHD_LpnKTABLE_LIST_bIb_b_+0x6c 160000 95912 mysqld`LOCK_grant mysqld`__1cXcheck_grant_all_columns6FpnDTHD_LpnYField_iterator_table_ref__b_+0x28 68 15414 mysqld`LOCK_grant mysqld`__1cLcheck_grant6FpnDTHD_LpnKTABLE_LIST_bIb_b_+0x6c 51 15740 mysqld`LOCK_system_variables_hash mysqld`__1cMfind_sys_var6FpnDTHD_pkcI_pnHsys_var__+0x2c 17 20203 mysqld`LOCK_system_variables_hash mysqld`__1cRcleanup_variables6FpnDTHD_pnQsystem_variables__v_+0x20 16 20305 mysqld`LOCK_system_variables_hash mysqld`__1cSintern_sys_var_ptr6FpnDTHD_ib_pC_+0x54 16 19234 mysqld`$XAhc3nBKj5XJmdK.LOCK_dboptions mysqld`__1cJget_dbopt6FpkcpnYst_ha_create_information__c_+0x24 17 16578 mysqld`LOCK_system_variables_hash mysqld`__1cRcleanup_variables6FpnDTHD_pnQsystem_variables__v_+0x20 17 16300 mysqld`LOCK_system_variables_hash mysqld`__1cRcleanup_variables6FpnDTHD_pnQsystem_variables__v_+0x20 16 16083 mysqld`LOCK_grant mysqld`__1cLcheck_grant6FpnDTHD_LpnKTABLE_LIST_bIb_b_+0x6c 2 24932 mysqld`LOCK_grant mysqld`__1cLcheck_grant6FpnDTHD_LpnKTABLE_LIST_bIb_b_+0x6c 1 19332 mysqld`LOCK_system_variables_hash mysqld`__1cMfind_sys_var6FpnDTHD_pkcI_pnHsys_var__+0x2c 1 19002 mysqld`LOCK_system_variables_hash mysqld`__1cSintern_sys_var_ptr6FpnDTHD_ib_pC_+0x54 1 16036 mysqld`LOCK_system_variables_hash mysqld`__1cOfill_variables6FpnDTHD_pnKTABLE_LIST_pnEItem__i_+0x70 1 15487 0x10789c958 mysqld`mi_rkey+0x160 R/W writer block Count nsec Lock Caller ------------------------------------------------------------------------------- 1 31742 mysqld`$XAhc3nBKj5XJmdK.LOCK_dboptions mysqld`__1cJdel_dbopt6Fpkc_v_+0x20 1 13729 mysqld`$XAhc3nBKj5XJmdK.LOCK_dboptions mysqld`__1cJput_dbopt6FpkcpnYst_ha_create_information__c_+0x24