Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:410ae78e852ca9243f4b085f0942aacd

Created May 8, 2017 15:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/410ae78e852ca9243f4b085f0942aacd to your computer and use it in GitHub Desktop.
Save mdcallag/410ae78e852ca9243f4b085f0942aacd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mmemcpy_avg_unaligned
from 5.7.17
0.45% mysqld libc-2.23.so [.] __memcpy_avx_unaligned
|
---__memcpy_avx_unaligned
|
|--0.13%-- my_net_write
| |
| |--0.09%-- Protocol_classic::end_row
| | |
| | |--0.05%-- end_send
| | | JOIN::exec
| | | handle_query
| | | execute_sqlcom_select
| | | mysql_execute_command
| | | Prepared_statement::execute
| | | Prepared_statement::execute_loop
| | | mysqld_stmt_execute
| | | dispatch_command
| | | do_command
| | | handle_connection
| | | pfs_spawn_thread
| | | start_thread
| | |
| | --0.04%-- THD::send_result_metadata
| | Query_result_send::send_result_set_metadata
| | JOIN::exec
| | handle_query
| | execute_sqlcom_select
| | mysql_execute_command
| | Prepared_statement::execute
| | Prepared_statement::execute_loop
| | mysqld_stmt_execute
| | dispatch_command
| | do_command
| | handle_connection
| | pfs_spawn_thread
| | start_thread
| |
| |--0.02%-- Protocol_classic::start_result_metadata
| | THD::send_result_metadata
| | Query_result_send::send_result_set_metadata
| | JOIN::exec
| | handle_query
| | execute_sqlcom_select
| | mysql_execute_command
| | Prepared_statement::execute
| | Prepared_statement::execute_loop
| | mysqld_stmt_execute
| | dispatch_command
| | do_command
| | handle_connection
| | pfs_spawn_thread
| | start_thread
| |
| --0.02%-- net_send_ok
| Protocol_classic::send_eof
| THD::send_statement_status
| dispatch_command
| do_command
| handle_connection
| pfs_spawn_thread
| start_thread
|
|--0.07%-- row_search_mvcc
| ha_innobase::index_read
| handler::ha_index_read_idx_map
| join_read_const_table
| JOIN::extract_func_dependent_tables
| JOIN::make_join_plan
| JOIN::optimize
| st_select_lex::optimize
| handle_query
| execute_sqlcom_select
| mysql_execute_command
| Prepared_statement::execute
| Prepared_statement::execute_loop
| mysqld_stmt_execute
| dispatch_command
| do_command
| handle_connection
| pfs_spawn_thread
| start_thread
|
|--0.07%-- net_after_header_psi
| net_read_packet
| my_net_read
| Protocol_classic::get_command
| do_command
| handle_connection
| pfs_spawn_thread
| start_thread
|
from 8.0.1
0.75% mysqld libc-2.23.so [.] __memcpy_avx_unaligned
|
---__memcpy_avx_unaligned
|
|--0.17%-- pfs_end_statement_v1
| dispatch_command
| do_command
| handle_connection
| pfs_spawn_thread
| start_thread
|
|--0.08%-- my_net_write
| |
| |--0.04%-- end_send
| | JOIN::exec
| | Sql_cmd_dml::execute_inner
| | Sql_cmd_dml::execute
| | mysql_execute_command
| | Prepared_statement::execute
| | Prepared_statement::execute_loop
| | mysqld_stmt_execute
| | dispatch_command
| | do_command
| | handle_connection
| | pfs_spawn_thread
| | start_thread
| |
| |--0.02%-- Protocol_classic::start_result_metadata
| | THD::send_result_metadata
| | Query_result_send::send_result_set_metadata
| | JOIN::exec
| | Sql_cmd_dml::execute_inner
| | Sql_cmd_dml::execute
| | mysql_execute_command
| | Prepared_statement::execute
| | Prepared_statement::execute_loop
| | mysqld_stmt_execute
| | dispatch_command
| | do_command
| | handle_connection
| | pfs_spawn_thread
| | start_thread
| |
| |--0.01%-- THD::send_result_metadata
| | Query_result_send::send_result_set_metadata
| | JOIN::exec
| | Sql_cmd_dml::execute_inner
| | Sql_cmd_dml::execute
| | mysql_execute_command
| | Prepared_statement::execute
| | Prepared_statement::execute_loop
| | mysqld_stmt_execute
| | dispatch_command
| | do_command
| | handle_connection
| | pfs_spawn_thread
| | start_thread
| |
| --0.01%-- net_send_ok
| Protocol_classic::send_eof
| THD::send_statement_status
| dispatch_command
| do_command
| handle_connection
| pfs_spawn_thread
| start_thread
|
|--0.07%-- row_sel_store_mysql_field_func
| row_sel_store_mysql_rec
| row_search_mvcc
| ha_innobase::index_read
| handler::ha_index_read_idx_map
| join_read_const_table
| JOIN::extract_func_dependent_tables
| JOIN::make_join_plan
| JOIN::optimize
| SELECT_LEX::optimize
| Sql_cmd_dml::execute_inner
| Sql_cmd_dml::execute
| mysql_execute_command
| Prepared_statement::execute
| Prepared_statement::execute_loop
| mysqld_stmt_execute
| dispatch_command
| do_command
| handle_connection
| pfs_spawn_thread
| start_thread
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment