Count nsec Lock Caller ------------------------------------------------------------------------------- 45 85202629 mysqld`LOCK_open mysqld`bool open_table(THD*,TABLE_LIST*,st_mem_root*,enum_open_table_action*,unsigned)+0x430 15 218494585 mysqld`LOCK_open mysqld`bool mysql_create_table_no_lock(THD*,const char*,const char*,st_ha_create_information*,Alter_info*,bool,unsigned)+0x65c 42 52243359 mysqld`LOCK_open mysqld`void close_open_tables(THD*)+0x18 7707 236582 0x101c1ed70 mysqld`void Mutex::lock()+0x4 6887 198023 0x101c1ed70 mysqld`void Mutex::lock()+0x4 9156 140705 0x101c1ed70 mysqld`void Mutex::lock()+0x4 6653 151630 0x101c1ed70 mysqld`void Mutex::lock()+0x4 1367 213248 0x101c1ed70 mysqld`void Mutex::lock()+0x4 1787 74346 0x101c1ed70 mysqld`void Mutex::lock()+0x4 966 136251 mysqld`LOCK_mdl mysqld`void mdl_release_locks(MDL_CONTEXT*)+0x20 1000 127324 mysqld`LOCK_mdl mysqld`bool mdl_acquire_shared_lock(MDL_CONTEXT*,MDL_LOCK_DATA*,bool*)+0x4c 3527 35269 0x101c1ed70 mysqld`void Mutex::lock()+0x4 1459 73143 0x101c1ed70 mysqld`void Mutex::lock()+0x4 3287 31184 0x101c1ed70 mysqld`void Mutex::lock()+0x4 582 165293 0x101c1ed70 mysqld`void Mutex::lock()+0x4 304 219582 0x101c9e918 mysqld`void Mutex::lock()+0x4 359 114253 0x101c9e918 mysqld`void Mutex::lock()+0x4 542 49411 0x101c1ed70 mysqld`void Mutex::lock()+0x4 180 139512 0x101c9e918 mysqld`void Mutex::lock()+0x4 140 136471 0x101c1ed70 mysqld`void Mutex::lock()+0x4 333 55408 0x101c1ed70 mysqld`void Mutex::lock()+0x4 105 147739 0x101c21000 mysqld`void Mutex::lock()+0x4 123 124039 0x101c21000 mysqld`void Mutex::lock()+0x4 118 117817 0x101c21000 mysqld`void Mutex::lock()+0x4 99 115025 0x101c21000 mysqld`void Mutex::lock()+0x4 463 19054 mysqld`LOCK_mdl mysqld`bool mdl_acquire_shared_lock(MDL_CONTEXT*,MDL_LOCK_DATA*,bool*)+0x4c 354 21393 mysqld`LOCK_mdl mysqld`void mdl_release_locks(MDL_CONTEXT*)+0x20 127 57909 0x101c1ed70 mysqld`void Mutex::lock()+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`void Mutex::lock()+0x4 32 137191 0x101c9e918 mysqld`void Mutex::lock()+0x4 16 238638 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 25 128705 0x101c9e918 mysqld`void Mutex::lock()+0x4 11 252042 0x101c1ed70 mysqld`void Mutex::lock()+0x4 43 57857 0x101c21000 mysqld`void Mutex::lock()+0x4 48 51441 0x101c9e918 mysqld`void Mutex::lock()+0x4 11 203684 0x101c1ed70 mysqld`void Mutex::lock()+0x4 11 201867 mysqld`LOCK_thread_count mysqld`bool dispatch_command(enum_server_command,THD*,char*,unsigned)+0x78 56 37652 0x101c9e918 mysqld`void Mutex::lock()+0x4 42 47320 0x101c21000 mysqld`void Mutex::lock()+0x4 33 46204 0x101c21000 mysqld`void Mutex::lock()+0x4 10 135218 0x101c1ed70 mysqld`void Mutex::lock()+0x4 40 32832 0x101c21000 mysqld`void Mutex::lock()+0x4 14 93054 0x101c9e918 mysqld`void Mutex::lock()+0x4 6 211305 0x101c1ed70 mysqld`void Mutex::lock()+0x4 30 42257 0x101c21000 mysqld`__1cFMute mysqld`void Mutex::lock()+0x4 10 103454 mysqld`$XAhc3nBMN5XJWfX.memoryManager+0xf8 mysqld`void Mutex::lock()+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`void Mutex::lock()+0x4 3 281764 mysqld`LOCK_thread_count mysqld`void unlink_thd(THD*)+0x58 3 270451 mysqld`LOCK_plugin mysqld`void plugin_thdvar_cleanup(THD*)+0x14 3 252915 mysqld`LOCK_open mysqld`void table_share_release_hook(void*)+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`void Mutex::lock()+0x4 5 108320 0x101c9e918 mysqld`void Mutex::lock()+0x4 4 122768 mysqld`query_cache+0x68 mysqld`void Query_cache::invalidate_table(THD*,unsigned char*,unsigned)+0x8 7 62245 0x101ca06e0 libc.so.1`cond_timedwait+0x14 2 193036 mysqld`LOCK_thread_count mysqld`bool dispatch_command(enum_server_command,THD*,char*,unsigned)+0x11c8 2 182931 0x101c21000 mysqld`void Mutex::lock()+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`void Mutex::lock()+0x4 2 128947 mysqld`LOCK_global_read_lock mysqld`bool wait_if_global_read_lock(THD*,bool,bool)+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`void Mutex::lock()+0x4 4 57114 0x101c1ed70 mysqld`void Mutex::lock()+0x4 3 65974 mysqld`LOCK_plugin mysqld`void plugin_unlock_list(THD*,st_plugin_int**,unsigned)+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`void Mutex::lock()+0x4 6 14864 mysqld`THR_LOCK_time mysqld`my_micro_time_and_time+0x24 1 88088 mysqld`LOCK_thread_count mysqld`void close_connection(THD*,unsigned,bool)+0x1c 1 84573 libc.so.1`_uberdata libc.so.1`_lwp_start 1 83036 mysqld`LOCK_global_read_lock mysqld`void start_waiting_global_read_lock(THD*)+0x2c 6 13125 0x101ca04c0 libc.so.1`cond_timedwait+0x14 3 24676 mysqld`query_cache+0x68 mysqld`void Query_cache::invalidate_table(THD*,unsigned char*,unsigned)+0x8 1 70294 0x101ca04c0 mysqld`void Synchronize::wake()+0x8 5 13795 mysqld`$XAhc3nBMN5XJWfX.memoryManager+0xf8 mysqld`void Mutex::lock()+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`void Synchronize::wake()+0x8 3 17427 mysqld`LOCK_thread_count mysqld`bool dispatch_command(enum_server_command,THD*,char*,unsigned)+0x78 1 50524 0x1104b8120 libc.so.1`cond_timedwait+0x14 1 48876 0x101ca04c0 mysqld`void Synchronize::wake()+0x8 3 14864 mysqld`LOCK_plugin mysqld`void plugin_unlock_list(THD*,st_plugin_int**,unsigned)+0x1c 2 21692 0x101ca05d0 libc.so.1`cond_timedwait+0x14 1 41189 mysqld`LOCK_global_read_lock mysqld`bool wait_if_global_read_lock(THD*,bool,bool)+0x24 1 40749 0x101ca03b0 mysqld`void Synchronize::wake()+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`bool open_table(THD*,TABLE_LIST*,st_mem_root*,enum_open_table_action*,unsigned)+0x430 3 13253 mysqld`LOCK_global_read_lock mysqld`bool wait_if_global_read_lock(THD*,bool,bool)+0x24 3 13217 0x1104b7ac0 libc.so.1`cond_timedwait+0x14 3 12777 0x1104b78a0 libc.so.1`cond_timedwait+0x14 1 38223 0x101c1ed70 mysqld`void Mutex::lock()+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`void start_waiting_global_read_lock(THD*)+0x2c 2 14333 0x101ca06e0 libc.so.1`cond_timedwait+0x14 2 13949 mysqld`LOCK_thread_count mysqld`void close_connection(THD*,unsigned,bool)+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`void Query_cache::invalidate_table(THD*,unsigned char*,unsigned)+0x68 1 15816 0x101ca05d0 mysqld`void Synchronize::wake()+0x8 1 15597 0x101c1ed70 mysqld`void Mutex::lock()+0x4 1 14058 libc.so.1`_uberdata libc.so.1`_lwp_start 1 13290 0x101ca03b0 mysqld`void Synchronize::wake()+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`void close_open_tables(THD*)+0x18 1 12082 0x1104b8780 libc.so.1`cond_timedwait+0x14 1 11863 0x101c95388 mysqld`void Mutex::lock()+0x4 1 11753 0x101ca06e0 mysqld`void Synchronize::wake()+0x8 1 11642 mysqld`LOCK_thread_count mysqld`bool dispatch_command(enum_server_command,THD*,char*,unsigned)+0x11c8 R/W reader block Count nsec Lock Caller ------------------------------------------------------------------------------- 160000 171886 mysqld`LOCK_grant mysqld`bool check_grant(THD*,unsigned long,TABLE_LIST*,bool,unsigned,bool)+0x6c 160000 95912 mysqld`LOCK_grant mysqld`bool check_grant_all_columns(THD*,unsigned long,Field_iterator_table_ref*)+0x28 68 15414 mysqld`LOCK_grant mysqld`bool check_grant(THD*,unsigned long,TABLE_LIST*,bool,unsigned,bool)+0x6c 51 15740 mysqld`LOCK_system_variables_hash mysqld`sys_var*find_sys_var(THD*,const char*,unsigned)+0x2c 17 20203 mysqld`LOCK_system_variables_hash mysqld`void cleanup_variables(THD*,system_variables*)+0x20 16 20305 mysqld`LOCK_system_variables_hash mysqld`unsigned char*intern_sys_var_ptr(THD*,int,bool)+0x54 16 19234 mysqld`$XAhc3nBKj5XJmdK.LOCK_dboptions mysqld`char get_dbopt(const char*,st_ha_create_information*)+0x24 17 16578 mysqld`LOCK_system_variables_hash mysqld`void cleanup_variables(THD*,system_variables*)+0x20 17 16300 mysqld`LOCK_system_variables_hash mysqld`void cleanup_variables(THD*,system_variables*)+0x20 16 16083 mysqld`LOCK_grant mysqld`bool check_grant(THD*,unsigned long,TABLE_LIST*,bool,unsigned,bool)+0x6c 2 24932 mysqld`LOCK_grant mysqld`bool check_grant(THD*,unsigned long,TABLE_LIST*,bool,unsigned,bool)+0x6c 1 19332 mysqld`LOCK_system_variables_hash mysqld`sys_var*find_sys_var(THD*,const char*,unsigned)+0x2c 1 19002 mysqld`LOCK_system_variables_hash mysqld`unsigned char*intern_sys_var_ptr(THD*,int,bool)+0x54 1 16036 mysqld`LOCK_system_variables_hash mysqld`int fill_variables(THD*,TABLE_LIST*,Item*)+0x70 1 15487 0x10789c958 mysqld`mi_rkey+0x160 R/W writer block Count nsec Lock Caller ------------------------------------------------------------------------------- 1 31742 mysqld`$XAhc3nBKj5XJmdK.LOCK_dboptions mysqld`void del_dbopt(const char*)+0x20 1 13729 mysqld`$XAhc3nBKj5XJmdK.LOCK_dboptions mysqld`char put_dbopt(const char*,st_ha_create_information*)+0x24