僵局导致MySQL挂分析(转)

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

  1   pthread_cond_wait os_cond_wait (os0sync.cc: 214), os_event_wait_low (os0sync.cc: 214), sync_array_wait_event (sync0arr.cc: 424), mutex_spin_wait (sync0sync.cc: 580), mutex_enter_func (sync0sync.ic: 218), pfs_mutex_enter_func (sync0sync.ic: 218), srv_export_innodb_status (sync0sync.ic: 218), innodb_export_status (ha_innodb.cc: 12442), show_innodb_vars (ha_innodb.cc: 12442), show_status_array (sql_show.cc: 2597), fill_status (sql_show.cc: 6749), do_fill_table (sql_show.cc: 7416), get_schema_tables_result (sql_show.cc: 7416),加入:prepare_result (sql_select.cc: 823),加入:exec (sql_executor.cc: 116), mysql_execute_select (sql_select.cc: 1100), mysql_select (sql_select.cc: 1100), handle_select (sql_select.cc: 110), execute_sqlcom_select (sql_parse.cc: 5134), mysql_execute_command (sql_parse.cc: 2612), mysql_parse (sql_parse.cc: 6386), dispatch_command (sql_parse.cc: 1340), do_command (sql_parse.cc: 1037), do_handle_one_connection (sql_connect.cc: 982), handle_one_connection (sql_connect.cc: 898), pfs_spawn_thread (pfs.cc: 1860), start_thread (libpthread.so.0),克隆(libc.so.6)   

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

     

  

  1   pthread_cond_wait os_cond_wait (os0sync.cc: 214), os_event_wait_low (os0sync.cc: 214), sync_array_wait_event (sync0arr.cc: 424), mutex_spin_wait (sync0sync.cc: 580), mutex_enter_func (sync0sync.ic: 218), pfs_mutex_enter_func (sync0sync.ic: 218), log_reserve_and_write_fast (sync0sync.ic: 218), mtr_log_reserve_and_write (sync0sync.ic: 218), mtr_commit (sync0sync.ic: 218), trx_undo_report_row_operation (trx0rec.cc: 1353), btr_cur_upd_lock_and_undo (btr0cur.cc: 1706), btr_cur_update_in_place (btr0cur.cc: 1706), btr_cur_optimistic_update (btr0cur.cc: 2166), row_upd_clust_rec (row0upd.cc: 2132), row_upd_clust_step (row0upd.cc: 2435), row_upd (row0upd.cc: 2521), row_upd_step (row0upd.cc: 2521), row_update_for_mysql (row0mysql.cc: 1779), ha_innobase: update_row (ha_innodb.cc: 7091),处理程序::ha_update_row (handler.cc: 7305), Rpl_info_table: do_flush_info (rpl_info_table.cc: 207), flush_info (rpl_info_handler.h: 92), Master_info: flush_info (rpl_info_handler.h: 92), flush_master_info (rpl_slave.cc: 871), handle_slave_io (rpl_slave.cc: 4818), pfs_spawn_thread (pfs.cc: 1860), start_thread (libpthread.so.0),克隆(libc.so.6)   

  

     

  

     

  

     

  

     

  

     

  

     

  

     

僵局导致MySQL挂分析(转)