gistfile1.txt

    177 read,my_real_read,my_net_read,do_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      8 pthread_cond_wait@@GLIBC_2.3.2,inline_mysql_cond_wait,optimized,optimized,do_handle_one_connection,handle_one_connection,start_thread,clone
      4 __lll_lock_wait_private,_L_lock_9495,malloc,mem_heap_create_block,mem_heap_create_func,row_sel_store_mysql_rec,row_search_for_mysql,ha_innobase::general_fetch,join_read_next_same,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      3 __lll_lock_wait_private,_L_lock_5189,_int_free,mem_heap_block_free,mem_heap_free_func,row_sel_store_mysql_rec,row_search_for_mysql,ha_innobase::general_fetch,handler::read_multi_range_next,QUICK_RANGE_SELECT::get_next,rr_quick,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      2 __lll_lock_wait_private,_L_lock_5189,_int_free,mem_heap_block_free,mem_heap_free_func,row_sel_store_mysql_rec,row_search_for_mysql,ha_innobase::general_fetch,join_read_next_same,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      2 __lll_lock_wait_private,_L_lock_5189,_int_free,free_root,SQL_SELECT::test_quick_select,get_quick_record_count,optimized,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 ut_rnd_gen_ulint,file_name=0xa4d6f8,file_name=0xa4d6f8,mutex_enter_func,at,at,innobase_commit_low,thd=0xad553dc0),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f94289d90b0),JOIN::join_free,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 str_to_datetime,str_to_datetime,Field_datetime::store,do_field_string,copy_fields,end_write,evaluate_join_record,sub_select,evaluate_join_record,sub_select,evaluate_join_record,sub_select,evaluate_join_record,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 sigwait,signal_hand,start_thread,clone
      1 select,os_thread_sleep,srv_purge_thread,start_thread,clone
      1 select,os_thread_sleep,srv_master_thread,start_thread,clone
      1 select,os_thread_sleep,srv_LRU_dump_restore_thread,start_thread,clone
      1 "",,"",,row_sel_push_cache_row_for_mysql,"",,ha_innobase::general_fetch,join_read_next,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 rec_get_bit_field_1,"\200\003\260-\200\200"),"\200\003\260-\200\200"),btr_cur_add_path_info,level=0,,btr_estimate_n_rows_in_range,ha_innobase::records_in_range,check_quick_keys,check_quick_keys,check_quick_keys,check_quick_keys,check_quick_select,get_key_scans_params,SQL_SELECT::test_quick_select,get_quick_record_count,optimized,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067461),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,innobase_commit_low,thd=0xadb461b0),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f942a7b9310),JOIN::join_free,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067363),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,innobase_commit_low,thd=0xade39fc0),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f942af0f290),JOIN::join_free,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067362),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,row_search_for_mysql,ha_innobase::index_read,handler::index_read_idx_map,join_read_const,join_read_const_table,make_join_statistics,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067302),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,rseg_id=18446744073709551615),rseg_id=18446744073709551615),trx_start_if_not_started,"\377",,ha_innobase::index_read,handler::read_range_first,handler::read_multi_range_first,QUICK_RANGE_SELECT::get_next,rr_quick,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067302),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,rseg_id=18446744073709551615),rseg_id=18446744073709551615),trx_start_if_not_started,"\001\226%\213\001t\340\001",,ha_innobase::index_read,handler::index_read_idx_map,join_read_const,join_read_const_table,make_join_statistics,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067275),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,innobase_commit_low,thd=0xad9d9ac0),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f9429dbf1c0),JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067205),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,rseg_id=18446744073709551615),rseg_id=18446744073709551615),trx_start_if_not_started,"",,ha_innobase::index_read,handler::index_read_idx_map,join_read_const,join_read_const_table,make_join_statistics,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067158),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,line=3919,,lock_table,row_search_for_mysql,ha_innobase::index_read,handler::read_range_first,handler::read_multi_range_first,QUICK_RANGE_SELECT::get_next,rr_quick,mysql_update,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067148),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,row_search_for_mysql,ha_innobase::index_read,join_read_always_key,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067141),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,innobase_commit_low,thd=0xad38d630),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f942878e300),JOIN::join_free,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067133),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,innobase_commit_low,thd=0xad1f2f90),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f9429d02b70),JOIN::join_free,return_zero_rows,at,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 pthread_cond_timedwait@@GLIBC_2.3.2,os_cond_wait_timed,time_in_usec=<value,srv_monitor_thread,start_thread,clone
      1 pthread_cond_timedwait@@GLIBC_2.3.2,os_cond_wait_timed,time_in_usec=<value,srv_lock_timeout_thread,start_thread,clone
      1 pthread_cond_timedwait@@GLIBC_2.3.2,os_cond_wait_timed,time_in_usec=<value,srv_error_monitor_thread,start_thread,clone
      1 pthread_cond_timedwait@@GLIBC_2.3.2,inline_mysql_cond_timedwait,thd=<value,mysql_binlog_send,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 poll,handle_connections_sockets,mysqld_main,__libc_start_main,_start
      1 ??,os_aio_linux_collect,message1=0x7faeb5f17e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943cc95e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943c294e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943b893e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943ae92e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943a491e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f9439a90e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943908fe78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943868ee78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f9437c8de78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943728ce78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f943688be78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f9435e8ae78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 ??,os_aio_linux_collect,message1=0x7f9435489e78,,fil_aio_wait,io_handler_thread,start_thread,clone
      1 optimized,optimized,optimized,optimized,row_search_for_mysql,ha_innobase::general_fetch,join_read_next,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 mtr=0x7faeb50a1770),mtr=0x7faeb50a1770),mtr=0x7faeb50a1770),mtr=0x7faeb50a1770),mtr=0x7faeb50a1770),mtr=0x7faeb50a1770),row_search_for_mysql,ha_innobase::general_fetch,join_read_next,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,my_malloc,QUICK_RANGE_SELECT::QUICK_RANGE_SELECT,get_quick_select,TRP_RANGE::make_quick,SQL_SELECT::test_quick_select,get_quick_record_count,optimized,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,my_malloc,QUICK_RANGE_SELECT::QUICK_RANGE_SELECT,get_quick_select_for_ref,create_sort_index,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,my_malloc,my_string_ptr_sort,write_keys,find_all_keys,optimized,create_sort_index,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,my_malloc,_mi_write_blob_record,mi_write,ha_myisam::write_row,handler::ha_write_row,end_write,evaluate_join_record,sub_select,evaluate_join_record,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,my_malloc,ha_innobase::records_in_range,check_quick_keys,check_quick_keys,check_quick_keys,check_quick_select,get_key_scans_params,SQL_SELECT::test_quick_select,get_quick_record_count,optimized,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,my_malloc,get_lock_data,mysql_unlock_some_tables,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,my_malloc,alloc_root,alloc,thd=<value,JOIN::prepare,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,mem_heap_create_block,mem_heap_create_func,row_sel_store_mysql_rec,row_search_for_mysql,ha_innobase::general_fetch,handler::read_multi_range_next,QUICK_RANGE_SELECT::get_next,rr_quick,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb503f328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94287d9bb8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb4e0e328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94289476d8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb4ded328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f9428bebfb8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb4dab328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942a9dc3b8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb4d48328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942818d758),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb4bf5328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94296348a8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb4a27328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942a201b60),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb46cd328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942a2bb0e8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb41a5328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942ac12620),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb4100328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f9428f64268),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7faeb409d328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942827a2f8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9430b8a328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94296b2d78),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9430893328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94281fdd40),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9430851328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94280b6728),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9430641328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f9429b24ac0),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f94301df328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94296f5398),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f943019d328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94290f0188),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f941bf58328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94291edc70),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f941be92328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942aef6098),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f941b2b6328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942a0c8928),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f941b043328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942831e288),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f941ae96328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f942985d0d8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9419d50328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f9428360b50),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9419828328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f9428ae5c68),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9419762328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f9429411cd8),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f941923a328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f900859b070),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_9495,malloc,MDL_ticket::create,MDL_context::try_acquire_lock_impl,MDL_context::acquire_lock,open_table_get_mdl_lock,open_table,open_and_process_table,start=0x7f9419111328,,open_and_lock_tables,open_and_lock_tables,all_tables=0x7f94286efb20),mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_5189,_int_free,mem_heap_block_free,mem_heap_free_heap_top,at,at,trx_commit_for_mysql,innobase_commit_low,thd=0xad6566c0),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f942a9a8260),JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait_private,_L_lock_5189,_int_free,delete_dynamic,JOIN::destroy,st_select_lex::cleanup,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 __lll_lock_wait,_L_cond_lock_1028,__pthread_mutex_cond_lock,pthread_cond_wait@@GLIBC_2.3.2,os_cond_wait,reset_sig_count=12067275),sync_array_wait_event,mutex_spin_wait,mutex_enter_func,at,at,innobase_commit_low,thd=0xadb4d900),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f94285db600),JOIN::join_free,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 join_tab=0x7f9429c0bcc0,,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 Item::val_bool,Item_cond_and::val_int,evaluate_join_record,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 _int_malloc,malloc,my_malloc,init_dynamic_array2,update_ref_and_keys,tables_arg=0x7f9429f86c00,,JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 index=0x7f94242395f8,,index=0x7f94242395f8,,ha_innobase::change_active_index,ha_innobase::rnd_pos,rr_from_cache,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 block=0x7f95506b5200,,btr_pcur_restore_position_func,sel_restore_position_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,join_read_next_same,sub_select,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 at,parse_sql,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone
      1 at,mutex_spin_wait,mutex_enter_func,at,at,innobase_commit_low,thd=0xada1f750),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f9428ae05f0),JOIN::join_free,do_select,JOIN::exec,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone

innodb-status

----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 63310239, signal count 205060679
--Thread 140388334872320 has waited at trx0trx.c line 796 for 0.0000 seconds the semaphore:
Mutex at 0x2e46518 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 140274438354688 has waited at trx0trx.c line 796 for 0.0000 seconds the semaphore:
Mutex at 0x2e46518 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 140388334159616 has waited at trx0trx.c line 796 for 0.0000 seconds the semaphore:
Mutex at 0x2e46518 '&kernel_mutex', lock var 0
waiters flag 0
Mutex spin waits 554541146, rounds 2887400022, OS waits 55594157
RW-shared spins 57057397, rounds 253772372, OS waits 3185375
RW-excl spins 16123492, rounds 351204755, OS waits 2418338
Spin rounds per wait: 5.21 mutex, 4.45 RW-shared, 21.78 RW-excl

lock-holder

 1 __lll_lock_wait_private,_L_lock_5189,_int_free,mem_heap_block_free,mem_heap_free_heap_top,at,at,trx_commit_for_mysql,innobase_commit_low,thd=0xad6566c0),innobase_commit,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,sql_lock=0x7f942a9a8260),JOIN::optimize,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_handle_one_connection,handle_one_connection,start_thread,clone

my.cnf

[mysqld_safe]
ledir=/usr/local/bin
mysqld=mysqld_wrapper

mysqld_wrapper.sh

#!/bin/sh
LD_PRELOAD="/usr/local/lib/libtcmalloc_minimal.so" exec $numactl --interleave all $mysqld "$@"