mysql性能分析工具perf

1、安装mysql性能分析工具

yum install perf

2、收集性能信息

[root@mysql1 ~]# perf record -p  `pidof mysqld` sleep 30 
[ perf record: Woken up 1 times to write data ]
[ perf record: Captured and wrote 0.155 MB perf.data (292 samples) ]

3、分析性能信息

[root@mysql1 ~]# perf report
Samples: 292  of event 'cpu-clock', Event count (approx.): 73000000                                                                                 
Overhead  Command          Shared Object        Symbol                                                                                              
  11.64%  connection       mysqld               [.] row_search_mvcc
   8.56%  connection       mysqld               [.] page_dir_find_owner_slot
   6.16%  connection       mysqld               [.] rec_init_offsets_comp_ordinary
   5.48%  connection       mysqld               [.] btr_pcur_t::move_to_prev
   3.42%  connection       libc-2.17.so         [.] __memmove_ssse3
   3.08%  connection       mysqld               [.] longlong10_to_str
   2.74%  connection       mysqld               [.] ha_innobase::general_fetch
   2.40%  connection       mysqld               [.] THD::send_result_set_row
   2.40%  ib_log_files_g   libpthread-2.17.so   [.] pthread_cond_timedwait@@GLIBC_2.3.2
   2.05%  connection       mysqld               [.] row_prebuilt_t::skip_concurrency_ticket
   2.05%  connection       mysqld               [.] row_sel_store_mysql_field
   1.71%  connection       mysqld               [.] Protocol_classic::store_field
   1.71%  connection       mysqld               [.] Query_expression::ExecuteIteratorQuery
   1.71%  connection       mysqld               [.] net_write_buff
   1.71%  connection       mysqld               [.] rec_get_offsets
   1.71%  connection       mysqld               [.] row_sel_field_store_in_mysql_format_func
   1.71%  connection       mysqld               [.] store_integer
   1.37%  connection       mysqld               [.] Field_longlong::send_to_protocol
   1.37%  ib_log_files_g   [kernel.kallsyms]    [k] finish_task_switch
   1.37%  ib_log_flush     [kernel.kallsyms]    [k] finish_task_switch
   1.03%  connection       [kernel.kallsyms]    [k] mpt_put_msg_frame
   1.03%  connection       mysqld               [.] Query_result_send::send_data
   1.03%  connection       mysqld               [.] rec_init_offsets
   1.03%  connection       mysqld               [.] row_sel_store_mysql_rec
   1.03%  ib_log_files_g   [kernel.kallsyms]    [k] sys_clock_gettime
   1.03%  ib_log_files_g   libstdc++.so.6.0.19  [.] std::_Rb_tree_increment
   0.68%  connection       mysqld               [.] lock_clust_rec_cons_read_sees
   0.68%  connection       mysqld               [.] rec_get_nth_field_offs
   0.68%  connection       mysqld               [.] row_sel_enqueue_cache_row_for_mysql
   0.68%  connection       mysqld               [.] trx_is_interrupted
   0.68%  ib_log_files_g   [kernel.kallsyms]    [k] __audit_syscall_entry
   0.68%  ib_log_files_g   libc-2.17.so         [.] __clock_gettime
   0.68%  ib_log_files_g   mysqld               [.] log_concurrency_margin
   0.68%  ib_log_files_g   mysqld               [.] log_consumer_get_oldest
   0.68%  ib_log_fl_notif  [kernel.kallsyms]    [k] finish_task_switch
   0.68%  ib_log_writer    [kernel.kallsyms]    [k] finish_task_switch
   0.34%  connection       [kernel.kallsyms]    [k] copy_user_generic_unrolled
   0.34%  connection       mysqld               [.] Field_longlong::val_int
   0.34%  connection       mysqld               [.] IndexScanIterator<true>::Read
   0.34%  connection       mysqld               [.] Item_field::send
   0.34%  connection       mysqld               [.] LimitOffsetIterator::Read
   0.34%  connection       mysqld               [.] PolicyMutex<TTASEventMutex<BlockMutexPolicy> >::exit
   0.34%  connection       mysqld               [.] THD::inc_sent_row_count
   0.34%  connection       mysqld               [.] btr_pcur_t::move_backward_from_page

4、反复抓取多次，定位信息。