-- build cat docs/INFO_SRC commit: e360e57bce944b6f4bb5230eb6bf9f7aad87ee71 date: 2020-09-07 11:49:57 +0200 build-date: 2020-09-23 12:00:25 +0000 short: e360e57bce9 branch: mysql-5.7.32-release MySQL source 5.7.32 -- rm -rf data/ bin/mysqld --defaults-file=./my.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data --log-error-verbosity=3 bin/mysqld --defaults-file=./my.cnf --basedir=$PWD --datadir=$PWD/data --core-file --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve 2>&1 & -- bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.32-log MySQL Community Server (GPL) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.01 sec) mysql> use test Database changed mysql> create user 'ushastry'@'localhost' identified by 'mysql123'; Query OK, 0 rows affected (0.01 sec) mysql> grant all on *.* to 'ushastry'@'localhost'; Query OK, 0 rows affected, 1 warning (0.00 sec) -- Sysbench session bin/sysbench --mysql-user=ushastry --mysql-password=mysql123 --mysql-socket=/tmp/mysql_ushastry.sock --mysql-db=test --tables=2 --time=100 --report-interval=1 --table-size=10000000 --threads=10 ./share/sysbench/oltp_insert.lua prepare sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Initializing worker threads... Creating table 'sbtest1'... Creating table 'sbtest2'... Inserting 10000000 records into 'sbtest2' Inserting 10000000 records into 'sbtest1' Creating a secondary index on 'sbtest2'... Creating a secondary index on 'sbtest1'... -- File size -rw-r----- 1 umshastr common 61 Dec 15 06:33 db.opt -rw-r----- 1 umshastr common 8.5K Dec 15 06:49 sbtest1.frm -rw-r----- 1 umshastr common 2.3G Dec 15 06:49 sbtest1.ibd -rw-r----- 1 umshastr common 8.5K Dec 15 06:49 sbtest2.frm -rw-r----- 1 umshastr common 2.7G Dec 15 07:01 sbtest2.ibd -- CLI session/ follow steps from report mysql> alter table sbtest2 add a int default null; Query OK, 0 rows affected (1 min 17.61 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> update sbtest1, sbtest2 set sbtest2.a= sbtest1.k where sbtest1.id = sbtest2.id; Query OK, 10000000 rows affected (5 min 15.04 sec) Rows matched: 10000000 Changed: 10000000 Warnings: 0 mysql> set optimizer_switch = 'firstmatch=off'; Query OK, 0 rows affected (0.00 sec) mysql> set optimizer_switch = 'materialization=off'; Query OK, 0 rows affected (0.00 sec) mysql> set max_heap_table_size = 16384; Query OK, 0 rows affected (0.00 sec) mysql> explain select count(*) from sbtest1 where k in (select a from sbtest2 ); +----+-------------+---------+------------+------+---------------+------+---------+----------------+---------+----------+------------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+---------+------------+------+---------------+------+---------+----------------+---------+----------+------------------------------+ | 1 | SIMPLE | sbtest2 | NULL | ALL | NULL | NULL | NULL | NULL | 9861119 | 100.00 | Using where; Start temporary | | 1 | SIMPLE | sbtest1 | NULL | ref | k_1 | k_1 | 4 | test.sbtest2.a | 5 | 100.00 | Using index; End temporary | +----+-------------+---------+------------+------+---------------+------+---------+----------------+---------+----------+------------------------------+ 2 rows in set, 1 warning (0.00 sec) mysql> select count(*) from sbtest1 where k in (select a from sbtest2 ); +----------+ | count(*) | +----------+ | 10000000 | +----------+ 1 row in set (1 hour 47 min 36.86 sec) mysql> -- ibtmp1 size at the end of read ls -lh data/ibtmp1 -rw-r----- 1 umshastr common 19G Dec 15 08:50 data/ibtmp1 -- table structures bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 Server version: 5.7.32-log MySQL Community Server (GPL) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show create table sbtest1\G *************************** 1. row *************************** Table: sbtest1 Create Table: CREATE TABLE `sbtest1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `k_1` (`k`) ) ENGINE=InnoDB AUTO_INCREMENT=10000001 DEFAULT CHARSET=utf8 1 row in set (0.00 sec) mysql> show create table sbtest2\G *************************** 1. row *************************** Table: sbtest2 Create Table: CREATE TABLE `sbtest2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', `a` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `k_2` (`k`) ) ENGINE=InnoDB AUTO_INCREMENT=10000001 DEFAULT CHARSET=utf8 1 row in set (0.00 sec) - perf record -F 10 -o mysql-572.perf -p 13072 -- sleep 20 perf record -g -F 10 -o mysql-572.g.perf -p 13072 -- sleep 5 #################################################################################################################### perf report --input mysql-572.perf --stdio |c++filt # To display the perf.data header info, please use --header/--header-only options. # # # Total Lost Samples: 0 # # Samples: 369 of event 'cycles:u' # Event count (approx.): 45622659161 # # Overhead Command Shared Object Symbol # ........ ....... .................. ......................................................................................................................... # 20.90% mysqld mysqld [.] rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) 20.18% mysqld mysqld [.] cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) 15.45% mysqld mysqld [.] buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) 10.40% mysqld mysqld [.] page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) 1.50% mysqld mysqld [.] PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) 1.50% mysqld mysqld [.] row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) 1.50% mysqld mysqld [.] row_ins_index_entry_set_vals(dict_index_t const*, dtuple_t*, dtuple_t const*) 1.00% mysqld mysqld [.] row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) 1.00% mysqld mysqld [.] mtr_t::Command::release_blocks() 1.00% mysqld mysqld [.] page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) 1.00% mysqld mysqld [.] ut_new_get_key_by_file(char const*) 1.00% mysqld mysqld [.] memo_slot_release(mtr_memo_slot_t*) 1.00% mysqld libc-2.17.so [.] __strcmp_sse42 1.00% mysqld libc-2.17.so [.] malloc 1.00% mysqld mysqld [.] mtr_t::Command::prepare_write() 0.99% mysqld mysqld [.] PolicyMutex >::exit() 0.99% mysqld mysqld [.] mtr_t::Command::release_all() 0.99% mysqld mysqld [.] btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) 0.97% mysqld mysqld [.] ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) 0.97% mysqld mysqld [.] row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, unsigned char const*, unsigned long) 0.55% mysqld mysqld [.] PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) 0.50% mysqld mysqld [.] Aggregator_simple::add() 0.50% mysqld mysqld [.] handler::mark_trx_read_write() 0.50% mysqld mysqld [.] row_sel_store_mysql_rec(unsigned char*, row_prebuilt_t*, unsigned char const*, dtuple_t const*, unsigned long, dict_index_t const*, unsigned long const*, bool) 0.50% mysqld mysqld [.] buf::Block_hint::buffer_fix_block_if_still_valid() 0.50% mysqld libc-2.17.so [.] __memmove_ssse3_back 0.50% mysqld mysqld [.] key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) 0.50% mysqld mysqld [.] buf_pool_watch_is_sentinel(buf_pool_t const*, buf_page_t const*) 0.50% mysqld mysqld [.] pfs_unlock_rwlock_v1 0.50% mysqld mysqld [.] btr_pcur_move_to_next(btr_pcur_t*, mtr_t*) 0.50% mysqld mysqld [.] Field_num::charset() const 0.50% mysqld mysqld [.] mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) 0.50% mysqld mysqld [.] mem_heap_block_free(mem_block_info_t*, mem_block_info_t*) 0.50% mysqld mysqld [.] mtr_t::start(bool, bool) 0.50% mysqld libc-2.17.so [.] _int_free 0.50% mysqld mysqld [.] row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) 0.50% mysqld mysqld [.] handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) 0.50% mysqld mysqld [.] Field::get_key_image(unsigned char*, unsigned long, Field::imagetype) 0.50% mysqld libc-2.17.so [.] _int_malloc 0.50% mysqld mysqld [.] ut_basename_noext(char const*, char*, unsigned long) 0.50% mysqld mysqld [.] row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 0.50% mysqld mysqld [.] fsp_is_system_temporary(unsigned long) 0.50% mysqld mysqld [.] rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) 0.49% mysqld mysqld [.] fil_space_get(unsigned long) 0.49% mysqld mysqld [.] sel_restore_position_for_mysql(unsigned long*, unsigned long, btr_pcur_t*, unsigned long, mtr_t*) [clone .clone.8] 0.49% mysqld mysqld [.] page_get_max_insert_size_after_reorganize(unsigned char const*, unsigned long) 0.49% mysqld mysqld [.] btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) 0.44% mysqld mysqld [.] buf_page_hash_get_locked(buf_pool_t*, page_id_t const&, rw_lock_t**, unsigned long, bool) [clone .clone.6] 0.28% mysqld libc-2.17.so [.] __memset_sse2 0.16% mysqld mysqld [.] buf_flush_page_and_try_neighbors(buf_page_t*, buf_flush_t, unsigned long, unsigned long*) 0.15% mysqld mysqld [.] ut_delay(unsigned long) 0.14% mysqld libaio.so.1.0.1 [.] 0x0000000000000645 0.13% mysqld mysqld [.] buf_page_io_complete(buf_page_t*, bool) 0.12% mysqld mysqld [.] buf_pool_get_oldest_modification() 0.10% mysqld mysqld [.] sync_array_print_long_waits_low(sync_array_t*, unsigned long*, void const**, unsigned long*) 0.08% mysqld mysqld [.] fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, void*, void*) 0.08% mysqld mysqld [.] LinuxAIOHandler::collect() 0.08% mysqld mysqld [.] pfs_start_mutex_wait_v1 0.07% mysqld mysqld [.] buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*) 0.07% mysqld libpthread-2.17.so [.] pthread_mutex_lock 0.06% mysqld mysqld [.] LinuxAIOHandler::find_completed_slot(unsigned long*) 0.05% mysqld mysqld [.] io_handler_thread 0.05% mysqld mysqld [.] fil_aio_wait(unsigned long) 0.05% mysqld libpthread-2.17.so [.] pthread_cond_timedwait@@GLIBC_2.3.2 0.03% mysqld mysqld [.] handler::ha_statistic_increment(unsigned long long system_status_var::*) const 0.00% mysqld [unknown] [k] 0xffffffff87c03ca0 0.00% mysqld libpthread-2.17.so [.] 0x000000000000eea1 0.00% mysqld mysqld [.] AIO::linux_dispatch(Slot*) 0.00% mysqld [unknown] [k] 0xffffffff87c00398 0.00% mysqld libaio.so.1.0.1 [.] 0x0000000000000644 0.00% mysqld libaio.so.1.0.1 [.] io_submit 0.00% mysqld libpthread-2.17.so [.] 0x000000000000ee9d ############################################################################################################################ perf report -i mysql-572.g.perf|c++filt # To display the perf.data header info, please use --header/--header-only options. # # # Total Lost Samples: 0 # # Samples: 160 of event 'cycles:u' # Event count (approx.): 11742917368 # # Children Self Command Shared Object Symbol # ........ ........ ....... .................. ......................................................................................................................... # 100.00% 0.00% mysqld libpthread-2.17.so [.] start_thread | ---start_thread | |--96.38%--pfs_spawn_thread | handle_connection | do_command(THD*) | dispatch_command(THD*, COM_DATA const*, enum_server_command) | mysql_parse(THD*, Parser_state*) | mysql_execute_command(THD*, bool) | execute_sqlcom_select(THD*, TABLE_LIST*) | handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) | JOIN::exec() | sub_select(JOIN*, QEP_TAB*, bool) | evaluate_join_record(JOIN*, QEP_TAB*) | sub_select(JOIN*, QEP_TAB*, bool) | | | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | | handler::ha_write_row(unsigned char*) | | ha_innobase::write_row(unsigned char*) | | ha_innobase::intrinsic_table_write_row(unsigned char*) | | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | | | |--1.97%--mtr_t::commit() | | | | mtr_t::Command::release_all() | | | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | | mtr_t::start(bool, bool) | | | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | | | --1.94%--mtr_t::commit() | | mtr_t::Command::execute() | | mtr_t::Command::release_blocks() | | | |--1.94%--thd_to_trx(THD*) | | | |--1.94%--ha_innobase::position(unsigned char const*) | | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | | | --1.90%--join_read_next_same(READ_RECORD*) | handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) | ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) | row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) | |--1.83%--io_handler_thread | fil_aio_wait(unsigned long) | | | --1.01%--os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) | LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) | | | --0.79%--__memset_sse2 | --1.19%--buf_flush_page_cleaner_coordinator | --1.19%--buf_flush_lists(unsigned long, unsigned long, unsigned long*) buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*) buf_flush_page_and_try_neighbors(buf_page_t*, buf_flush_t, unsigned long, unsigned long*) | --0.69%--buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool) 96.38% 0.00% mysqld mysqld [.] pfs_spawn_thread | ---pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] handle_connection | ---handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] do_command(THD*) | ---do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] dispatch_command(THD*, COM_DATA const*, enum_server_command) | ---dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] mysql_parse(THD*, Parser_state*) | ---mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] mysql_execute_command(THD*, bool) | ---mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] execute_sqlcom_select(THD*, TABLE_LIST*) | ---execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) | ---handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] JOIN::exec() | ---JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] sub_select(JOIN*, QEP_TAB*, bool) | ---sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 96.38% 0.00% mysqld mysqld [.] evaluate_join_record(JOIN*, QEP_TAB*) | ---evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) | |--90.60%--evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | | | |--1.97%--mtr_t::commit() | | | mtr_t::Command::release_all() | | | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | | mtr_t::start(bool, bool) | | | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | | | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | | | --1.94%--mtr_t::commit() | mtr_t::Command::execute() | mtr_t::Command::release_blocks() | |--1.94%--thd_to_trx(THD*) | |--1.94%--ha_innobase::position(unsigned char const*) | key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | --1.90%--join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 90.60% 0.00% mysqld mysqld [.] do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | ---do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | |--1.97%--mtr_t::commit() | | mtr_t::Command::release_all() | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | mtr_t::start(bool, bool) | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | --1.94%--mtr_t::commit() mtr_t::Command::execute() mtr_t::Command::release_blocks() 90.60% 0.00% mysqld mysqld [.] handler::ha_write_row(unsigned char*) | ---handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | |--1.97%--mtr_t::commit() | | mtr_t::Command::release_all() | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | mtr_t::start(bool, bool) | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | --1.94%--mtr_t::commit() mtr_t::Command::execute() mtr_t::Command::release_blocks() 90.60% 0.00% mysqld mysqld [.] ha_innobase::write_row(unsigned char*) | ---ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | |--1.97%--mtr_t::commit() | | mtr_t::Command::release_all() | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | mtr_t::start(bool, bool) | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | --1.94%--mtr_t::commit() mtr_t::Command::execute() mtr_t::Command::release_blocks() 90.60% 0.00% mysqld mysqld [.] ha_innobase::intrinsic_table_write_row(unsigned char*) | ---ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | |--1.97%--mtr_t::commit() | | mtr_t::Command::release_all() | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | mtr_t::start(bool, bool) | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | --1.94%--mtr_t::commit() mtr_t::Command::execute() mtr_t::Command::release_blocks() 90.60% 0.00% mysqld mysqld [.] row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | ---row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | |--78.85%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | |--1.97%--mtr_t::commit() | | mtr_t::Command::release_all() | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | mtr_t::start(bool, bool) | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | |--7.73%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | |--3.84%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | |--1.94%--row_get_prebuilt_insert_row(row_prebuilt_t*) | --1.94%--mtr_t::commit() mtr_t::Command::execute() mtr_t::Command::release_blocks() 78.88% 0.00% mysqld mysqld [.] btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | ---btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | |--22.29%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | |--1.94%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | --1.94%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) 78.85% 1.94% mysqld mysqld [.] row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | |--76.91%--row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | | | |--1.97%--mtr_t::commit() | | mtr_t::Command::release_all() | | | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | | mtr_t::start(bool, bool) | | | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | --1.94%--start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) 78.85% 0.00% mysqld mysqld [.] row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | ---row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | |--71.16%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | | |--52.71%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | | | --18.45%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | --1.95%--PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | |--1.97%--mtr_t::commit() | mtr_t::Command::release_all() | |--1.94%--row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | mtr_t::start(bool, bool) | --1.83%--btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) 52.71% 11.65% mysqld mysqld [.] page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | |--41.05%--page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | | | |--30.93%--rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | | | --10.12%--cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | --11.65%--start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) 32.87% 32.87% mysqld mysqld [.] rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | |--30.93%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) | --1.94%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) 22.29% 20.35% mysqld mysqld [.] buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | |--20.35%--start_thread | pfs_spawn_thread | handle_connection | do_command(THD*) | dispatch_command(THD*, COM_DATA const*, enum_server_command) | mysql_parse(THD*, Parser_state*) | mysql_execute_command(THD*, bool) | execute_sqlcom_select(THD*, TABLE_LIST*) | handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) | JOIN::exec() | sub_select(JOIN*, QEP_TAB*, bool) | evaluate_join_record(JOIN*, QEP_TAB*) | sub_select(JOIN*, QEP_TAB*, bool) | evaluate_join_record(JOIN*, QEP_TAB*) | do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) | handler::ha_write_row(unsigned char*) | ha_innobase::write_row(unsigned char*) | ha_innobase::intrinsic_table_write_row(unsigned char*) | row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | | | |--16.51%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | | btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | | buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | | | --3.84%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) | --1.95%--buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) 12.07% 12.07% mysqld mysqld [.] cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) | |--10.12%--row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) | row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) | btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) | page_cur_search_with_match(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, page_cur_t*, rtr_info*) | cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) | --1.94%--btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) cmp_dtuple_rec_with_match_low(dtuple_t const*, unsigned char const*, unsigned long const*, unsigned long, unsigned long*) 3.91% 0.00% mysqld mysqld [.] mtr_t::commit() | ---mtr_t::commit() | |--1.97%--mtr_t::Command::release_all() | --1.94%--mtr_t::Command::execute() mtr_t::Command::release_blocks() 1.97% 1.83% mysqld mysqld [.] rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) | --1.83%--start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) 1.97% 0.00% mysqld mysqld [.] btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) | ---btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*) page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) 1.97% 0.00% mysqld mysqld [.] page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) | ---page_cur_direct_insert_rec_low(unsigned char*, dict_index_t*, dtuple_t const*, unsigned long, mtr_t*) rec_convert_dtuple_to_rec(unsigned char*, dict_index_t const*, dtuple_t const*, unsigned long) 1.97% 1.97% mysqld mysqld [.] mtr_t::Command::release_all() | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) mtr_t::commit() mtr_t::Command::release_all() 1.95% 1.95% mysqld mysqld [.] PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) btr_cur_search_to_nth_level_with_no_latch(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, btr_cur_t*, char const*, unsigned long, mtr_t*, bool) buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) PolicyMutex >::enter(unsigned int, unsigned int, char const*, unsigned int) 1.94% 1.94% mysqld mysqld [.] mtr_t::start(bool, bool) | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool) row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool) row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) mtr_t::start(bool, bool) 1.94% 0.00% mysqld mysqld [.] row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) | ---row_ins_sec_mtr_start_and_check_if_aborted(mtr_t*, dict_index_t*, bool, unsigned long) mtr_t::start(bool, bool) 1.94% 1.94% mysqld mysqld [.] row_get_prebuilt_insert_row(row_prebuilt_t*) | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) row_get_prebuilt_insert_row(row_prebuilt_t*) 1.94% 1.94% mysqld mysqld [.] mtr_t::Command::release_blocks() | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) do_sj_dups_weedout(THD*, SJ_TMP_TABLE*) handler::ha_write_row(unsigned char*) ha_innobase::write_row(unsigned char*) ha_innobase::intrinsic_table_write_row(unsigned char*) row_insert_for_mysql_using_cursor(unsigned char const*, row_prebuilt_t*) mtr_t::commit() mtr_t::Command::execute() mtr_t::Command::release_blocks() 1.94% 0.00% mysqld mysqld [.] mtr_t::Command::execute() | ---mtr_t::Command::execute() mtr_t::Command::release_blocks() 1.94% 1.94% mysqld mysqld [.] thd_to_trx(THD*) | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) thd_to_trx(THD*) 1.94% 1.94% mysqld mysqld [.] key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) | ---start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) ha_innobase::position(unsigned char const*) key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) 1.94% 0.00% mysqld mysqld [.] ha_innobase::position(unsigned char const*) | ---ha_innobase::position(unsigned char const*) key_copy(unsigned char*, unsigned char*, st_key*, unsigned int) 1.90% 1.90% mysqld mysqld [.] row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) | --1.90%--start_thread pfs_spawn_thread handle_connection do_command(THD*) dispatch_command(THD*, COM_DATA const*, enum_server_command) mysql_parse(THD*, Parser_state*) mysql_execute_command(THD*, bool) execute_sqlcom_select(THD*, TABLE_LIST*) handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) JOIN::exec() sub_select(JOIN*, QEP_TAB*, bool) evaluate_join_record(JOIN*, QEP_TAB*) sub_select(JOIN*, QEP_TAB*, bool) join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 1.90% 0.00% mysqld mysqld [.] join_read_next_same(READ_RECORD*) | ---join_read_next_same(READ_RECORD*) handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 1.90% 0.00% mysqld mysqld [.] handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) | ---handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int) ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 1.90% 0.00% mysqld mysqld [.] ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) | ---ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) 1.83% 0.00% mysqld mysqld [.] io_handler_thread | ---io_handler_thread fil_aio_wait(unsigned long) | --1.01%--os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) | --0.79%--__memset_sse2 1.83% 0.66% mysqld mysqld [.] fil_aio_wait(unsigned long) | |--1.17%--fil_aio_wait(unsigned long) | | | --1.01%--os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) | LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) | | | --0.79%--__memset_sse2 | --0.66%--start_thread io_handler_thread fil_aio_wait(unsigned long) 1.19% 0.00% mysqld mysqld [.] buf_flush_page_cleaner_coordinator | ---buf_flush_page_cleaner_coordinator | --1.19%--buf_flush_lists(unsigned long, unsigned long, unsigned long*) buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*) buf_flush_page_and_try_neighbors(buf_page_t*, buf_flush_t, unsigned long, unsigned long*) | --0.69%--buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool) 1.19% 0.00% mysqld mysqld [.] buf_flush_lists(unsigned long, unsigned long, unsigned long*) | ---buf_flush_lists(unsigned long, unsigned long, unsigned long*) buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*) buf_flush_page_and_try_neighbors(buf_page_t*, buf_flush_t, unsigned long, unsigned long*) | --0.69%--buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool) 1.19% 0.00% mysqld mysqld [.] buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*) | ---buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, unsigned long*) buf_flush_page_and_try_neighbors(buf_page_t*, buf_flush_t, unsigned long, unsigned long*) | --0.69%--buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool) 1.19% 0.21% mysqld mysqld [.] buf_flush_page_and_try_neighbors(buf_page_t*, buf_flush_t, unsigned long, unsigned long*) | --0.98%--buf_flush_page_and_try_neighbors(buf_page_t*, buf_flush_t, unsigned long, unsigned long*) | --0.69%--buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool) 1.01% 0.00% mysqld mysqld [.] os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) | ---os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) | --0.79%--__memset_sse2 1.01% 0.00% mysqld mysqld [.] LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) | ---LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) | --0.79%--__memset_sse2 0.79% 0.79% mysqld libc-2.17.so [.] __memset_sse2 | ---start_thread io_handler_thread fil_aio_wait(unsigned long) os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) __memset_sse2 0.69% 0.00% mysqld mysqld [.] buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool) | ---buf_flush_page(buf_pool_t*, buf_page_t*, buf_flush_t, bool) 0.48% 0.21% mysqld mysqld [.] fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, void*, void*) 0.29% 0.29% mysqld mysqld [.] buf_page_hash_get_locked(buf_pool_t*, page_id_t const&, rw_lock_t**, unsigned long, bool) [clone .clone.6] 0.29% 0.00% mysqld mysqld [.] buf_flush_check_neighbor(page_id_t const&, buf_flush_t) 0.27% 0.27% mysqld mysqld [.] my_timer_cycles 0.27% 0.00% mysqld mysqld [.] pfs_end_file_wait_v1 0.22% 0.00% mysqld mysqld [.] srv_error_monitor_thread 0.22% 0.22% mysqld mysqld [.] sync_array_print_long_waits_low(sync_array_t*, unsigned long*, void const**, unsigned long*) 0.22% 0.00% mysqld mysqld [.] sync_array_print_long_waits(unsigned long*, void const**) 0.21% 0.00% mysqld mysqld [.] srv_master_thread 0.21% 0.21% mysqld mysqld [.] buf_pool_get_oldest_modification() 0.21% 0.00% mysqld mysqld [.] log_checkpoint(bool, bool) 0.21% 0.21% mysqld mysqld [.] rw_lock_sx_lock_low(rw_lock_t*, unsigned long, char const*, unsigned long) 0.21% 0.00% mysqld mysqld [.] pfs_rw_lock_sx_lock_low(rw_lock_t*, unsigned long, char const*, unsigned long) [clone .clone.5] 0.16% 0.16% mysqld libaio.so.1.0.1 [.] 0x0000000000000645 0.16% 0.00% mysqld libaio.so.1.0.1 [.] 0x00007fef7ca8c645 0.16% 0.16% mysqld mysqld [.] PolicyMutex >::exit() 0.16% 0.00% mysqld mysqld [.] buf_page_io_complete(buf_page_t*, bool) 0.16% 0.00% mysqld mysqld [.] buf_flush_write_complete(buf_page_t*) 0.16% 0.00% mysqld mysqld [.] buf_flush_remove(buf_page_t*) 0.16% 0.00% mysqld mysqld [.] os_event::wait_time_low(unsigned long, long) 0.15% 0.00% mysqld mysqld [.] lock_wait_timeout_thread 0.15% 0.15% mysqld libc-2.17.so [.] __clock_gettime 0.14% 0.14% mysqld mysqld [.] rec_get_converted_size_comp(dict_index_t const*, unsigned long, dfield_t const*, unsigned long, unsigned long*) 0.14% 0.00% mysqld mysqld [.] row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, unsigned long, bool) 0.14% 0.00% mysqld mysqld [.] row_ins_sorted_clust_index_entry(unsigned long, dict_index_t*, dtuple_t*, unsigned long, que_thr_t*) 0.06% 0.06% mysqld libaio.so.1.0.1 [.] io_getevents 0.00% 0.00% mysqld libpthread-2.17.so [.] pthread_cond_timedwait@@GLIBC_2.3.2 0.00% 0.00% mysqld [unknown] [k] 0xffffffff87c03ca0 0.00% 0.00% mysqld libaio.so.1.0.1 [.] 0x00007fef7ca8c644 0.00% 0.00% mysqld libpthread-2.17.so [.] 0x000000000000eea1 0.00% 0.00% mysqld libpthread-2.17.so [.] 0x00007fef7cea0ea1 0.00% 0.00% mysqld mysqld [.] os_aio_func(IORequest&, unsigned long, char const*, pfs_os_file_t, void*, unsigned long, unsigned long, bool, fil_node_t*, void*) 0.00% 0.00% mysqld mysqld [.] AIO::linux_dispatch(Slot*) 0.00% 0.00% mysqld mysqld [.] dict_stats_thread 0.00% 0.00% mysqld mysqld [.] fts_optimize_thread(void*) 0.00% 0.00% mysqld mysqld [.] ib_wqueue_timedwait(ib_wqueue_t*, long) 0.00% 0.00% mysqld mysqld [.] srv_monitor_thread 0.00% 0.00% mysqld mysqld [.] row_sel_store_mysql_rec(unsigned char*, row_prebuilt_t*, unsigned char const*, dtuple_t const*, unsigned long, dict_index_t const*, unsigned long const*, bool) 0.00% 0.00% mysqld libaio.so.1.0.1 [.] 0x0000000000000644 0.00% 0.00% mysqld libaio.so.1.0.1 [.] io_submit 0.00% 0.00% mysqld libpthread-2.17.so [.] 0x000000000000ee9d 0.00% 0.00% mysqld libpthread-2.17.so [.] 0x00007fef7cea0e9d # # (Cannot load tips.txt file, please install perf!) # -- Env mount | grep sdb1 /dev/sdb1 on /export/home type xfs (rw,noatime,attr2,inode64,logbufs=8,logbsize=32k,noquota,_netdev) cat /proc/version Linux version 5.4.17-2011.1.2.el7uek.x86_64 (mockbuild@jenkins-10-147-72-125-c911a06e-95d0-49d7-936f-31236a50dd4e) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-39.0.1) (GCC)) #2 SMP Mon Apr 20 22:10:25 PDT 2020 cat /etc/*release Oracle Linux Server release 7.8 NAME="Oracle Linux Server" VERSION="7.8" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="7.8" PRETTY_NAME="Oracle Linux Server 7.8" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:8:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.8 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.8 Red Hat Enterprise Linux Server release 7.8 (Maipo) Oracle Linux Server release 7.8