######################################## -- all defaults rm -rf /dev/shm/84286 scripts/mysql_install_db --basedir=/export/umesh/server/binaries/GABuilds/mysql-5.6.35 --datadir=/dev/shm/84286 -v bin/mysqld --basedir=/export/umesh/server/binaries/GABuilds/mysql-5.6.35 --datadir=/dev/shm/84286 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/dev/shm/84286/log.err 2>&1 & [umshastr@hod03]~/bugs/sysbench: sysbench/sysbench --test=/home/umshastr/bugs/sysbench/sysbench/tests/db/oltp.lua --report-interval=1 --oltp-tables-count=1000000 --oltp-table-size=10 --max-time=0 --oltp-read-only=off --max-requests=0 --num-threads=64 --rand-type=pareto --db-driver=mysql --mysql-user=root --mysql-socket=/tmp/mysql_ushastry.sock --mysql-db=sbtest prepare . . Creating table 'sbtest980436'... Inserting 10 records into 'sbtest980436' Creating table 'sbtest980437'... ^^Had to stop at somepoint to avoid running out of diskspace :) -- Start backup [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --single-transaction sbtest > backup.sql -- After sometime i.e after "Opening tables", you may observe root@localhost [(none)]> select time,state,info from information_schema.processlist; +------+----------------------+------------------------------------------------------------+ | time | state | info | +------+----------------------+------------------------------------------------------------+ | 0 | executing | select time,state,info from information_schema.processlist | | 2 | checking permissions | show table status like 'sbtest100059' | +------+----------------------+------------------------------------------------------------+ 2 rows in set (0.00 sec) root@localhost [(none)]> select time,state,info from information_schema.processlist; +------+----------------------+------------------------------------------------------------+ | time | state | info | +------+----------------------+------------------------------------------------------------+ | 0 | executing | select time,state,info from information_schema.processlist | | 2 | checking permissions | show table status like 'sbtest10006' | +------+----------------------+------------------------------------------------------------+ 2 rows in set (0.00 sec) root@localhost [(none)]> select time,state,info from information_schema.processlist; +------+----------------------+------------------------------------------------------------+ | time | state | info | +------+----------------------+------------------------------------------------------------+ | 0 | executing | select time,state,info from information_schema.processlist | | 2 | checking permissions | SHOW TRIGGERS LIKE 'sbtest100065' | +------+----------------------+------------------------------------------------------------+ 2 rows in set (0.00 sec) root@localhost [(none)]> select time,state,info from information_schema.processlist; +------+----------------------+------------------------------------------------------------+ | time | state | info | +------+----------------------+------------------------------------------------------------+ | 0 | executing | select time,state,info from information_schema.processlist | | 2 | checking permissions | show table status like 'sbtest100066' | +------+----------------------+------------------------------------------------------------+ 2 rows in set (0.00 sec) . . root@localhost [(none)]> select time,state,info from information_schema.processlist; +------+----------------------+------------------------------------------------------------+ | time | state | info | +------+----------------------+------------------------------------------------------------+ | 0 | executing | select time,state,info from information_schema.processlist | | 2 | checking permissions | SHOW TRIGGERS LIKE 'sbtest100120' | +------+----------------------+------------------------------------------------------------+ 2 rows in set (0.00 sec) ### [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35:perf record -g -p $( pidof mysqld ) -- sleep 120 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: perf report|c++filt # ======== # captured on: Wed Dec 21 09:45:50 2016 # hostname : hod03 # os release : 3.8.13-98.2.2.el7uek.x86_64 # perf version : 3.8.13-98.2.2.el7uek.x86_64 # arch : x86_64 # nrcpus online : 32 # nrcpus avail : 32 # cpudesc : Intel(R) Xeon(R) CPU E5-2650 v2 @ 2.60GHz # cpuid : GenuineIntel,6,62,4 # total memory : 264098836 kB # cmdline : /usr/libexec/perf.3.8.13-98.2.2.el7uek.x86_64 record -g -p 21156 -- sleep 120 # event : name = cycles, type = 0, config = 0x0, config1 = 0x0, config2 = 0x0, excl_usr = 0, excl_kern = 0, excl_host = 0, excl_guest = 1, precise_ip = 0, id = { 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391 } # HEADER_CPU_TOPOLOGY info available, use -I to display # HEADER_NUMA_TOPOLOGY info available, use -I to display # pmu mappings: cpu = 4, software = 1, tracepoint = 2, breakpoint = 5 # ======== # # Samples: 479K of event 'cycles' # Event count (approx.): 307930794191 # # Overhead Command Shared Object Symbol # ........ ....... ................... .............................................................................................. # 24.13% mysqld libc-2.17.so [.] __memcpy_sse2 | --- __memcpy_sse2 | |--2.80%-- 0x0 | |--1.57%-- 0xfa0964 | |--1.54%-- 0x8d48000001d890ff | |--1.49%-- 0x5c9ee8d78948de89 | |--1.42%-- 0xb60f41c2094810e0 | |--1.35%-- 0x3436358b4cffb99b | |--1.32%-- 0xc8b3894800 | |--1.21%-- 0x2ece9197400ffff | |--0.93%-- 0x202444c74800 | |--0.84%-- 0xc28948c08548004f | |--0.80%-- 0x8348fb894810678d | |--0.76%-- 0xc045c679726f7463 | |--0.72%-- 0x746165726336656c | |--0.66%-- 0xfffffc9c850f00b0 | |--0.62%-- 0x6c665f625f796d00 | |--0.62%-- 0x6f666e695f7364 | |--0.60%-- 0x18 | 0xd83710 | __cxxabiv1::__si_class_type_info::~__si_class_type_info() | 0x1de907894810c083 | |--0.57%-- 0xc00120002e0ff | |--0.50%-- 0x5f636e75665f6d65 --79.67%-- [...] 14.04% mysqld libc-2.17.so [.] __strcmp_sse42 | --- __strcmp_sse42 | |--94.81%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--5.19%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --0.00%-- [...] 13.31% mysqld [kernel.kallsyms] [k] dcache_readdir | --- dcache_readdir vfs_readdir sys_getdents system_call_fastpath __getdents64 10.03% mysqld mysqld [.] my_qsort | --- my_qsort my_dir find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 6.90% mysqld [kernel.kallsyms] [k] __list_add | --- __list_add | |--99.22%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | |--0.78%-- vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--0.78%-- 0xb2283 | | | |--0.78%-- 0x6093b | | | |--0.78%-- 0xc38d8 | | | |--0.78%-- 0x153848 | | | |--0.78%-- 0xd0265 | | | |--0.78%-- 0x15c1d9 | | | |--0.78%-- 0x186b48 | | | |--0.78%-- 0x165836 | | | |--0.77%-- 0xa5f5c | | | |--0.77%-- 0x167e9a | | | |--0.77%-- 0x144b8a | | | |--0.77%-- 0x110ef1 | | | |--0.77%-- 0x1c816d | --89.92%-- [...] --0.00%-- [...] 5.60% mysqld [kernel.kallsyms] [k] __ticket_spin_lock | --- __ticket_spin_lock | |--97.47%-- _raw_spin_lock | | | |--99.48%-- dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | --0.52%-- [...] | |--2.28%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 --0.25%-- [...] 2.96% mysqld libc-2.17.so [.] __readdir64 | --- __readdir64 | |--66.77%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --33.23%-- [...] 2.59% mysqld mysqld [.] comp_names | --- comp_names | |--97.66%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --2.34%-- my_qsort my_dir find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 2.12% mysqld libc-2.17.so [.] __memmove_ssse3_back | --- __memmove_ssse3_back | |--99.92%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --0.08%-- [...] 1.89% mysqld mysqld [.] strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | --- strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | |--97.53%-- filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --2.47%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 1.70% mysqld mysqld [.] my_mb_wc_filename | --- my_mb_wc_filename | |--60.99%-- strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --39.01%-- filename_to_tablename(char const*, char*, unsigned int) find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 1.29% mysqld libc-2.17.so [.] __strrchr_sse42 | --- __strrchr_sse42 find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 1.20% mysqld mysqld [.] my_uni_utf8 | --- my_uni_utf8 | |--65.99%-- strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --34.01%-- filename_to_tablename(char const*, char*, unsigned int) find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 1.16% mysqld libc-2.17.so [.] __memmove_sse2 | --- __memmove_sse2 1.14% mysqld [kernel.kallsyms] [k] __list_del_entry | --- __list_del_entry | |--77.60%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | |--22.36%-- vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 --0.04%-- [...] 1.05% mysqld mysqld [.] filename_to_tablename(char const*, char*, unsigned int) | --- filename_to_tablename(char const*, char*, unsigned int) | |--96.75%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --3.25%-- get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.85% mysqld [kernel.kallsyms] [k] __ticket_spin_unlock | --- __ticket_spin_unlock | |--81.32%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | |--18.41%-- vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 --0.27%-- [...] 0.83% mysqld [kernel.kallsyms] [k] copy_user_enhanced_fast_string | --- copy_user_enhanced_fast_string | |--99.93%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 --0.07%-- [...] 0.69% mysqld mysqld [.] wild_compare | --- wild_compare | |--95.40%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --4.60%-- get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.65% mysqld [kernel.kallsyms] [k] filldir | --- filldir | |--93.81%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | --6.19%-- vfs_readdir sys_getdents system_call_fastpath __getdents64 | |--1.55%-- 0xe957f | |--1.03%-- 0xcb8d0 | |--1.03%-- 0x23645 | |--1.03%-- 0x154ead | |--1.03%-- 0x1501e5 | |--1.03%-- 0x4195a | |--1.03%-- 0x18fe9 | |--1.03%-- 0xd3f2e | |--1.03%-- 0xa5290 | |--1.03%-- 0xe2253 | |--1.03%-- 0x118bb6 | |--1.03%-- 0x542e1 | |--0.52%-- 0x1874e1 | |--0.52%-- 0x892ac | |--0.52%-- 0x10d228 | |--0.52%-- 0x156512 | |--0.52%-- 0x1a94bf | |--0.52%-- 0x9090b | |--0.52%-- 0x15f509 | |--0.52%-- 0xb7c17 | |--0.52%-- 0x34fcd | |--0.52%-- 0xa38f8 | |--0.52%-- 0x4dfb4 | |--0.52%-- 0x2d308 | |--0.52%-- 0x56fab | |--0.52%-- 0x4afb7 | |--0.52%-- 0x22646 | |--0.52%-- 0xb38e8 | |--0.52%-- 0x31c9d | |--0.52%-- 0x17cb7 | |--0.52%-- 0x24caa | |--0.52%-- 0x2aca4 | |--0.52%-- 0x33635 | |--0.52%-- 0x28ca6 | |--0.52%-- 0xc926c | |--0.52%-- 0x13a861 | |--0.52%-- 0x91f70 | |--0.52%-- 0xb5c19 | |--0.52%-- 0x6af97 | |--0.52%-- 0x19ae67 | |--0.52%-- 0x2dca1 | |--0.52%-- 0x6f92c | |--0.52%-- 0x29fd8 | |--0.52%-- 0x15184a | |--0.52%-- 0xb2f4f | |--0.52%-- 0x112bbc | |--0.52%-- 0x1d3afb | |--0.52%-- 0x13b52d | |--0.52%-- 0x472ee | |--0.52%-- 0x48953 | |--0.52%-- 0x3332 | |--0.52%-- 0x1d47c7 | |--0.52%-- 0xe78b4 | |--0.52%-- 0xecc0 | |--0.52%-- 0x1d2163 | |--0.52%-- 0x10c229 | |--0.52%-- 0x73928 | |--0.52%-- 0xa6f5b | |--0.52%-- 0x1a84c0 | |--0.52%-- 0x128ba6 | |--0.52%-- 0x155513 | |--0.52%-- 0x188b46 | |--0.52%-- 0xf659 | |--0.52%-- 0xe1f20 | |--0.52%-- 0x6b2ca | |--0.52%-- 0xaf8ec | |--0.52%-- 0x2f306 | |--0.52%-- 0x178b56 | |--0.52%-- 0x181e80 | |--0.52%-- 0x4a951 | |--0.52%-- 0x11cee5 | |--0.52%-- 0x199a | |--0.52%-- 0x5cc72 | |--0.52%-- 0x36965 | |--0.52%-- 0xa75c1 | |--0.52%-- 0xf5240 | |--0.52%-- 0x19fe8 | |--0.52%-- 0x17fe82 | |--0.52%-- 0xac5bc | |--0.52%-- 0xe6be8 | |--0.52%-- 0xa6c28 | |--0.52%-- 0x1a57f6 | |--0.52%-- 0x1984d0 | |--0.52%-- 0x39962 | |--0.52%-- 0xb4f4d | |--0.52%-- 0x87914 | |--0.52%-- 0x9d8fe | |--0.52%-- 0x114221 | |--0.52%-- 0x18c1a9 | |--0.52%-- 0xfe56a | |--0.52%-- 0xc626f | |--0.52%-- 0xe28b9 | |--0.52%-- 0xcf8cc | |--0.52%-- 0xf48a7 | |--0.52%-- 0xae287 | |--0.52%-- 0xbf276 | |--0.52%-- 0x9929c | |--0.52%-- 0x1531e2 | |--0.52%-- 0x1c6e3b | |--0.52%-- 0x36632 | |--0.52%-- 0x792bc | |--0.52%-- 0x164e9d | |--0.52%-- 0xd5260 | |--0.52%-- 0x161ea0 | |--0.52%-- 0xd6f2b | |--0.52%-- 0x105230 | |--0.52%-- 0x19919c | |--0.52%-- 0x1ba7e1 | |--0.52%-- 0xd38c8 | |--0.52%-- 0x12b53d | |--0.52%-- 0xe9be5 | |--0.52%-- 0x17fb4f | |--0.52%-- 0x137b97 | |--0.52%-- 0x10bef6 | |--0.52%-- 0xdd58b | |--0.52%-- 0x14185a | |--0.52%-- 0x1aeb20 | |--0.52%-- 0x1751c0 | |--0.52%-- 0x75f8c | |--0.52%-- 0xfa8a1 | |--0.52%-- 0xc3272 | |--0.52%-- 0x1a87f3 | |--0.52%-- 0x105563 | |--0.52%-- 0x153515 | |--0.52%-- 0xeff12 | |--0.52%-- 0x1bb4ad | |--0.52%-- 0x135866 | |--0.52%-- 0x175826 | |--0.52%-- 0xf0245 | |--0.52%-- 0x10c55c | |--0.52%-- 0x162e9f | |--0.52%-- 0x1d57c6 | |--0.52%-- 0xc2c0c | |--0.52%-- 0x1aee53 | |--0.52%-- 0xbf8dc | |--0.52%-- 0x67601 | |--0.52%-- 0x69f98 | |--0.52%-- 0x18b4dd | |--0.52%-- 0x19819d | |--0.52%-- 0x18ce75 | |--0.52%-- 0x122edf | |--0.52%-- 0x174e8d | |--0.52%-- 0x132203 | |--0.52%-- 0x1ce167 | |--0.51%-- 0x43c8b | |--0.51%-- 0x6ff92 | |--0.51%-- 0x127eda | |--0.51%-- 0x1921a3 | |--0.51%-- 0xebf16 | |--0.51%-- 0x109bc5 | |--0.51%-- 0x12ded4 | |--0.51%-- 0x12620f | |--0.51%-- 0x1b7e4a | |--0.51%-- 0xf9f08 | |--0.51%-- 0x13d1f8 | |--0.51%-- 0x1b77e4 | |--0.51%-- 0x12a871 | |--0.51%-- 0x14e84d | |--0.51%-- 0x1b44b4 | |--0.51%-- 0x18d80e | |--0.51%-- 0x192e6f | |--0.51%-- 0x147854 | |--0.51%-- 0x12f86c | |--0.51%-- 0x98903 | |--0.51%-- 0x1c8b06 | |--0.51%-- 0x108bc6 | |--0.51%-- 0x18e80d | |--0.51%-- 0x135200 | |--0.51%-- 0x19e197 | |--0.51%-- 0x116885 | |--0.51%-- 0x1ac7ef | |--0.51%-- 0x15db71 | |--0.51%-- 0x1831b2 | |--0.51%-- 0xf3242 | |--0.51%-- 0x15e83d | |--0.51%-- 0x16b4fd | |--0.51%-- 0x1ad4bb | |--0.51%-- 0x1591dc | |--0.51%-- 0x13086b | |--0.51%-- 0x1667 | --0.51%-- 0x1001 0.63% mysqld libc-2.17.so [.] __strlen_sse2_pminub | --- __strlen_sse2_pminub | |--65.98%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--33.95%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --0.06%-- [...] 0.52% mysqld mysqld [.] find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | --- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.47% mysqld mysqld [.] my_strcasecmp_utf8 | --- my_strcasecmp_utf8 | |--77.62%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--22.34%-- get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --0.04%-- [...] 0.34% mysqld libc-2.17.so [.] __getdents64 | --- __getdents64 0.34% mysqld [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock | |--67.71%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | |--32.17%-- vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--0.58%-- 0xa32b | | | |--0.58%-- 0x124edd | | | |--0.58%-- 0x382fd | --98.26%-- [...] --0.12%-- [...] 0.33% mysqld mysqld [.] alloc_root | --- alloc_root | |--87.14%-- strmake_root | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--12.80%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --0.06%-- [...] 0.33% mysqld libc-2.17.so [.] _wordcopy_bwd_dest_aligned | --- _wordcopy_bwd_dest_aligned 0.32% mysqld libc-2.17.so [.] __strlen_sse2 | --- __strlen_sse2 0.31% mysqld [kernel.kallsyms] [k] _cond_resched | --- _cond_resched | |--99.72%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 --0.28%-- [...] 0.31% mysqld libc-2.17.so [.] _int_malloc | --- _int_malloc | |--1.08%-- 0x0 | |--1.01%-- 0x840fdb8548000001 | |--0.94%-- 0x303d65646f6d2820 | |--0.94%-- 0x8d48ffffe502e8df | |--0.81%-- 0x98a88b4cc0458b48 | |--0.74%-- 0x1 | |--0.67%-- 0x28a2823d8d48004d | |--0.61%-- 0x84e981480b8b4800 | |--0.47%-- 0x8bad68949 | |--0.47%-- 0x68635f676f6c6e69 | |--0.40%-- 0x870f000002ffc07d | |--0.34%-- 0x18 | 0xd83710 | __cxxabiv1::__si_class_type_info::~__si_class_type_info() | 0x1de907894810c083 | |--0.27%-- 0x1358070 | |--0.20%-- 0xe845c748 | |--0.20%-- 0x324e5a5f0076456c | |--0.20%-- 0x666e695f6c705234 | |--0.20%-- 0xe8f60148f8e68348 | |--0.20%-- 0x1bd41de8948d231 | |--0.20%-- 0x20d5d0e81774f3 | |--0.13%-- 0x5f636e75665f6d65 --89.91%-- [...] 0.23% mysqld mysqld [.] fn_rext(char*) | --- fn_rext(char*) | |--69.08%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --30.92%-- get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.22% mysqld mysqld [.] strmake_root | --- strmake_root | |--93.89%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --6.11%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.21% mysqld mysqld [.] insert_dynamic | --- insert_dynamic | |--81.50%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --18.50%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.18% mysqld mysqld [.] strdup_root | --- strdup_root | |--63.18%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --36.82%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.14% mysqld [kernel.kallsyms] [k] _copy_to_user | --- _copy_to_user dcache_readdir vfs_readdir sys_getdents system_call_fastpath __getdents64 0.13% mysqld mysqld [.] my_dir | --- my_dir find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.06% mysqld mysqld [.] find_or_create_table_share(PFS_thread*, bool, TABLE_SHARE const*) | --- find_or_create_table_share(PFS_thread*, bool, TABLE_SHARE const*) get_table_share(THD*, TABLE_LIST*, char const*, unsigned int, unsigned int, int*, unsigned int) get_table_share_with_discover(THD*, TABLE_LIST*, char const*, unsigned int, unsigned int, int*, unsigned int) open_table(THD*, TABLE_LIST*, Open_table_context*) open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) fill_schema_table_by_open(THD*, bool, TABLE*, st_schema_table*, st_mysql_lex_string*, st_mysql_lex_string*, Open_tables_backup*, bool) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.06% mysqld mysqld [.] is_prefix | --- is_prefix | |--61.34%-- get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --38.66%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.06% mysqld mysqld [.] memcpy@plt | --- memcpy@plt | |--99.64%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --0.36%-- [...] 0.04% mysqld mysqld [.] my_lfind | --- my_lfind lf_hash_search | |--57.33%-- find_or_create_file(PFS_thread*, PFS_file_class*, char const*, unsigned int, bool) | | | |--86.27%-- end_file_open_wait_and_bind_to_descriptor_v1 | | | | | |--61.39%-- open_table_def(THD*, TABLE_SHARE*, unsigned int) | | | get_table_share(THD*, TABLE_LIST*, char const*, unsigned int, unsigned int, int*, unsigned int) | | | get_table_share_with_discover(THD*, TABLE_LIST*, char const*, unsigned int, unsigned int, int*, unsigned int) | | | open_table(THD*, TABLE_LIST*, Open_table_context*) | | | open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) | | | open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) | | | fill_schema_table_by_open(THD*, bool, TABLE*, st_schema_table*, st_mysql_lex_string*, st_mysql_lex_string*, Open_tables_backup*, bool) | | | get_all_tables(THD*, TABLE_LIST*, Item*) | | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | | JOIN::prepare_result(List**) | | | JOIN::exec() | | | mysql_execute_select(THD*, st_select_lex*, bool) | | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | | handle_select(THD*, select_result*, unsigned long) | | | execute_sqlcom_select(THD*, TABLE_LIST*) | | | mysql_execute_command(THD*) | | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | | do_command(THD*) | | | do_handle_one_connection(THD*) | | | handle_one_connection | | | pfs_spawn_thread | | | start_thread | | | | | |--25.83%-- mi_create | | | create_myisam_tmp_table(TABLE*, st_key*, st_columndef*, st_columndef**, unsigned long long, char) | | | instantiate_tmp_table(TABLE*, st_key*, st_columndef*, st_columndef**, unsigned long long, char, Opt_trace_context*) | | | create_tmp_table(THD*, TMP_TABLE_PARAM*, List&, st_order*, bool, bool, unsigned long long, unsigned long long, char const*) | | | create_schema_table(THD*, TABLE_LIST*) | | | mysql_schema_table(THD*, LEX*, TABLE_LIST*) | | | open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) | | | open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) | | | execute_sqlcom_select(THD*, TABLE_LIST*) | | | mysql_execute_command(THD*) | | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | | do_command(THD*) | | | do_handle_one_connection(THD*) | | | handle_one_connection | | | pfs_spawn_thread | | | start_thread | | | | | --12.78%-- mi_open | | ha_myisam::open(char const*, int, unsigned int) | | handler::ha_open(TABLE*, char const*, int, int) | | open_tmp_table(TABLE*) | | instantiate_tmp_table(TABLE*, st_key*, st_columndef*, st_columndef**, unsigned long long, char, Opt_trace_context*) | | create_tmp_table(THD*, TMP_TABLE_PARAM*, List&, st_order*, bool, bool, unsigned long long, unsigned long long, char const*) | | create_schema_table(THD*, TABLE_LIST*) | | mysql_schema_table(THD*, LEX*, TABLE_LIST*) | | open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) | | open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --13.73%-- start_file_close_wait_v1 | mi_delete_table | free_tmp_table(THD*, TABLE*) | close_thread_tables(THD*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--35.45%-- find_or_create_digest(PFS_thread*, sql_digest_storage const*, char const*, unsigned int) | end_statement_v1 | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --7.22%-- find_or_create_table_share(PFS_thread*, bool, TABLE_SHARE const*) get_table_share(THD*, TABLE_LIST*, char const*, unsigned int, unsigned int, int*, unsigned int) get_table_share_with_discover(THD*, TABLE_LIST*, char const*, unsigned int, unsigned int, int*, unsigned int) open_table(THD*, TABLE_LIST*, Open_table_context*) open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) fill_schema_table_by_open(THD*, bool, TABLE*, st_schema_table*, st_mysql_lex_string*, st_mysql_lex_string*, Open_tables_backup*, bool) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.04% mysqld mysqld [.] dict_make_room_in_cache(unsigned long, unsigned long) | --- dict_make_room_in_cache(unsigned long, unsigned long) srv_master_evict_from_table_cache(unsigned long) srv_master_thread start_thread 0.03% mysqld mysqld [.] strlen@plt | --- strlen@plt | |--98.77%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --1.23%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.03% mysqld mysqld [.] readdir64@plt | --- readdir64@plt find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.03% mysqld [kernel.kallsyms] [k] apic_timer_interrupt | --- apic_timer_interrupt | |--38.56%-- __memcpy_sse2 | | | |--16.68%-- 0x0 | | | |--11.12%-- 0x3436358b4cffb99b | | | |--11.11%-- 0xc045c679726f7463 | | | |--11.09%-- 0xa0f61 | | | |--5.57%-- 0x5c9ee8d78948de89 | | | |--5.56%-- 0xc8b3894800 | | | |--5.56%-- 0x8d48000001d890ff | | | |--5.56%-- 0x202444c74800 | | | |--5.56%-- 0xfa0964 | | | |--5.56%-- 0xfffffc9c850f00b0 | | | |--5.55%-- 0x1afe7 | | | |--5.54%-- 0x1491ec | | | --5.54%-- 0x17fea | |--13.06%-- vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--11.13%-- 0x48c86 | | | |--5.57%-- 0x1b34b5 | | | |--5.57%-- 0xa2f5f | | | |--5.56%-- 0xa32b | | | |--5.56%-- 0xc7f3a | | | |--5.56%-- 0x4dfb4 | | | |--5.56%-- 0x95f6c | | | |--5.56%-- 0x59fa8 | | | |--5.56%-- 0xc85a0 | | | |--5.55%-- 0x19a19b | | | |--5.55%-- 0x975d1 | | | |--5.55%-- 0xeabe4 | | | |--5.55%-- 0x1651d0 | | | |--5.55%-- 0x16e82d | | | |--5.55%-- 0x18cb42 | | | |--5.54%-- 0x42959 | | | --5.54%-- 0x1ab18a | |--10.06%-- __strcmp_sse42 | | | |--92.85%-- my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --7.15%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--7.91%-- my_qsort | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--6.53%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--11.13%-- 0x29ca5 | | | |--11.13%-- 0xb4281 | | | |--11.12%-- 0x5c60c | | | |--11.12%-- 0x1c17da | | | |--11.11%-- 0x4331 | | | |--11.11%-- 0x1be177 | | | |--11.10%-- 0x1a0e61 | | | |--11.10%-- 0x185816 | | | --11.08%-- 0x1904d8 | |--3.63%-- __readdir64 | | | |--20.04%-- 0x112556 | | | |--20.00%-- 0x3a62e | | | |--20.00%-- 0xcc59c | | | |--19.98%-- 0x1a2193 | | | --19.97%-- 0xf7bd7 | |--3.63%-- _raw_spin_lock | dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--20.03%-- 0x57c77 | | | |--20.02%-- 0x31637 | | | |--20.00%-- 0x6bc63 | | | |--19.98%-- 0x8191a | | | --19.97%-- 0x6a2cb | |--2.18%-- __memmove_ssse3_back | | | |--33.36%-- my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--33.33%-- 0x16a4fe | | | --33.30%-- 0x183b4b | |--2.16%-- filename_to_tablename(char const*, char*, unsigned int) | | | |--66.66%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --33.34%-- filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--2.16%-- my_mb_wc_filename | | | |--66.67%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --33.33%-- filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--1.45%-- _wordcopy_bwd_dest_aligned | | | |--50.01%-- 0x193b3b | | | --49.99%-- 0x122213 | |--1.44%-- my_uni_utf8 | | | |--50.02%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --49.98%-- strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--1.44%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | | |--50.01%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --49.99%-- filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--1.44%-- comp_names | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--0.73%-- _int_malloc | 0x2d96e | |--0.73%-- __getdents64 | 0x165836 | |--0.73%-- strdup_root | 0x148eb9 | |--0.73%-- __memmove_sse2 | 0x169b65 | |--0.72%-- wild_compare | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --0.72%-- __strrchr_sse42 find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.03% mysqld [kernel.kallsyms] [k] native_write_msr_safe | --- native_write_msr_safe | |--40.63%-- intel_pmu_disable_all | x86_pmu_disable | perf_pmu_disable | | | |--97.15%-- perf_adjust_freq_unthr_context.part.72 | | perf_event_task_tick | | scheduler_tick | | update_process_times | | tick_sched_handle.isra.12 | | tick_sched_timer | | __run_hrtimer | | hrtimer_interrupt | | smp_apic_timer_interrupt | | apic_timer_interrupt | | | | | |--26.11%-- __memcpy_sse2 | | | | | | | --100.00%-- 0x18 | | | 0xd83710 | | | __cxxabiv1::__si_class_type_info::~__si_class_type_info() | | | 0x1de907894810c083 | | | | | |--23.95%-- __strcmp_sse42 | | | my_dir | | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | | get_all_tables(THD*, TABLE_LIST*, Item*) | | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | | JOIN::prepare_result(List**) | | | JOIN::exec() | | | mysql_execute_select(THD*, st_select_lex*, bool) | | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | | handle_select(THD*, select_result*, unsigned long) | | | execute_sqlcom_select(THD*, TABLE_LIST*) | | | mysql_execute_command(THD*) | | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | | do_command(THD*) | | | do_handle_one_connection(THD*) | | | handle_one_connection | | | pfs_spawn_thread | | | start_thread | | | | | |--22.11%-- my_qsort | | | my_dir | | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | | get_all_tables(THD*, TABLE_LIST*, Item*) | | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | | JOIN::prepare_result(List**) | | | JOIN::exec() | | | mysql_execute_select(THD*, st_select_lex*, bool) | | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | | handle_select(THD*, select_result*, unsigned long) | | | execute_sqlcom_select(THD*, TABLE_LIST*) | | | mysql_execute_command(THD*) | | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | | do_command(THD*) | | | do_handle_one_connection(THD*) | | | handle_one_connection | | | pfs_spawn_thread | | | start_thread | | | | | |--7.44%-- dcache_readdir | | | vfs_readdir | | | sys_getdents | | | system_call_fastpath | | | __getdents64 | | | | | | | |--25.02%-- 0x9929c | | | | | | | |--25.01%-- 0x85916 | | | | | | | |--25.00%-- 0xd958f | | | | | | | --24.97%-- 0x140ec1 | | | | | |--7.37%-- comp_names | | | my_dir | | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | | get_all_tables(THD*, TABLE_LIST*, Item*) | | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | | JOIN::prepare_result(List**) | | | JOIN::exec() | | | mysql_execute_select(THD*, st_select_lex*, bool) | | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | | handle_select(THD*, select_result*, unsigned long) | | | execute_sqlcom_select(THD*, TABLE_LIST*) | | | mysql_execute_command(THD*) | | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | | do_command(THD*) | | | do_handle_one_connection(THD*) | | | handle_one_connection | | | pfs_spawn_thread | | | start_thread | | | | | |--3.72%-- __memmove_sse2 | | | | | | | |--50.06%-- 0x8303831006d7266 | | | | | | | --49.94%-- 0x12ce6e00000000 | | | | | |--1.86%-- _raw_spin_lock | | | dcache_readdir | | | vfs_readdir | | | sys_getdents | | | system_call_fastpath | | | __getdents64 | | | 0x5d60b | | | | | |--1.86%-- __strlen_sse2 | | | 0x6d72662e37393637 | | | | | |--1.86%-- insert_dynamic | | | my_dir | | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | | get_all_tables(THD*, TABLE_LIST*, Item*) | | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | | JOIN::prepare_result(List**) | | | JOIN::exec() | | | mysql_execute_select(THD*, st_select_lex*, bool) | | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | | handle_select(THD*, select_result*, unsigned long) | | | execute_sqlcom_select(THD*, TABLE_LIST*) | | | mysql_execute_command(THD*) | | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | | do_command(THD*) | | | do_handle_one_connection(THD*) | | | handle_one_connection | | | pfs_spawn_thread | | | start_thread | | | | | |--1.86%-- vfs_readdir | | | sys_getdents | | | system_call_fastpath | | | __getdents64 | | | 0x141ec0 | | | | | --1.85%-- my_uni_utf8 | | filename_to_tablename(char const*, char*, unsigned int) | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --2.85%-- ctx_sched_out | __perf_event_task_sched_out | perf_event_task_sched_out | __schedule | schedule | read_events | sys_io_getevents | system_call_fastpath | 0x7f6e1150a644 | fil_aio_wait(unsigned long) | io_handler_thread | start_thread | |--32.96%-- lapic_next_deadline | clockevents_program_event | tick_program_event | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | | | |--24.58%-- __memcpy_sse2 | | | | | |--50.01%-- 0x0 | | | | | --49.99%-- 0xc00120002e0ff | | | |--20.05%-- vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--11.14%-- 0x2c63c | | | | | |--11.13%-- 0x11e217 | | | | | |--11.13%-- 0x1b3e4e | | | | | |--11.12%-- 0x13f529 | | | | | |--11.12%-- 0x7af87 | | | | | |--11.11%-- 0x1d7e2a | | | | | |--11.10%-- 0x193b3b | | | | | |--11.10%-- 0x133202 | | | | | --11.06%-- 0x99b | | | |--15.44%-- __strcmp_sse42 | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--6.68%-- dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--33.37%-- 0xd5bf9 | | | | | |--33.32%-- 0x1dde24 | | | | | --33.31%-- 0x1a67f5 | | | |--6.67%-- _raw_spin_lock | | dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--33.40%-- 0x1c6b08 | | | | | |--33.35%-- 0xc5f3c | | | | | --33.25%-- 0x12fed2 | | | |--6.62%-- comp_names | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--4.41%-- my_qsort | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--2.23%-- _wordcopy_bwd_dest_aligned | | 0xf13eb51 | | | |--2.23%-- __strlen_sse2 | | 0x6d72662e31363332 | | | |--2.23%-- __getdents64 | | | |--2.23%-- __strlen_sse2_pminub | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--2.22%-- __readdir64 | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--2.21%-- my_uni_utf8 | | strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | | filename_to_tablename(char const*, char*, unsigned int) | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --2.21%-- my_strcasecmp_utf8 | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--16.12%-- native_apic_msr_eoi_write | smp_apic_timer_interrupt | apic_timer_interrupt | | | |--36.54%-- __memcpy_sse2 | | | | | |--33.36%-- 0x5c9ee8d78948de89 | | | | | |--33.32%-- 0xb60f41c2094810e0 | | | | | --33.32%-- 0xfa0964 | | | |--13.67%-- dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--33.43%-- 0x156845 | | | | | |--33.31%-- 0xe3beb | | | | | --33.27%-- 0x116552 | | | |--13.53%-- __strcmp_sse42 | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--9.10%-- _raw_spin_lock | | dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--50.03%-- 0x185e7c | | | | | --49.97%-- 0x8f2a6 | | | |--9.02%-- my_qsort | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--4.55%-- vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | 0xbec10 | | | |--4.55%-- __readdir64 | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--4.52%-- filename_to_tablename(char const*, char*, unsigned int) | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --4.51%-- comp_names | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--6.63%-- intel_pmu_enable_all | x86_pmu_enable | perf_pmu_enable | | | |--77.26%-- perf_adjust_freq_unthr_context.part.72 | | perf_event_task_tick | | scheduler_tick | | update_process_times | | tick_sched_handle.isra.12 | | tick_sched_timer | | __run_hrtimer | | hrtimer_interrupt | | smp_apic_timer_interrupt | | apic_timer_interrupt | | | | | |--43.09%-- __memcpy_sse2 | | | | | | | --100.00%-- 0x5c9ee8d78948de89 | | | | | |--28.41%-- __strcmp_sse42 | | | my_dir | | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | | get_all_tables(THD*, TABLE_LIST*, Item*) | | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | | JOIN::prepare_result(List**) | | | JOIN::exec() | | | mysql_execute_select(THD*, st_select_lex*, bool) | | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | | handle_select(THD*, select_result*, unsigned long) | | | execute_sqlcom_select(THD*, TABLE_LIST*) | | | mysql_execute_command(THD*) | | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | | do_command(THD*) | | | do_handle_one_connection(THD*) | | | handle_one_connection | | | pfs_spawn_thread | | | start_thread | | | | | |--14.33%-- vfs_readdir | | | sys_getdents | | | system_call_fastpath | | | __getdents64 | | | 0x775f1 | | | | | --14.17%-- my_qsort | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--22.56%-- perf_event_context_sched_in | | __perf_event_task_sched_in | | finish_task_switch | | __schedule | | schedule | | | | | |--95.73%-- read_events | | | sys_io_getevents | | | system_call_fastpath | | | 0x7f6e1150a644 | | | fil_aio_wait(unsigned long) | | | io_handler_thread | | | start_thread | | | | | |--2.25%-- futex_wait_queue_me | | | futex_wait | | | do_futex | | | sys_futex | | | system_call_fastpath | | | pthread_cond_timedwait@@GLIBC_2.3.2 | | | | | | | |--38.10%-- srv_error_monitor_thread | | | | start_thread | | | | | | | |--37.73%-- dict_stats_thread | | | | start_thread | | | | | | | |--14.89%-- ib_wqueue_timedwait(ib_wqueue_t*, long) | | | | fts_optimize_thread(void*) | | | | start_thread | | | | | | | |--4.73%-- srv_monitor_thread | | | | start_thread | | | | | | | --4.55%-- lock_wait_timeout_thread | | | start_thread | | | | | --2.01%-- schedule_hrtimeout_range_clock | | schedule_hrtimeout_range | | poll_schedule_timeout | | | | | |--81.43%-- do_select | | | core_sys_select | | | sys_select | | | system_call_fastpath | | | __select | | | | | | | |--50.61%-- buf_flush_page_cleaner_thread | | | | start_thread | | | | | | | --49.39%-- srv_master_thread | | | start_thread | | | | | --18.57%-- do_sys_poll | | sys_poll | | system_call_fastpath | | 0x7f6e103d500d | | vio_socket_io_wait | | vio_read | | net_read_raw_loop(st_net*, unsigned long) | | net_read_packet_header(st_net*) | | my_net_read | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | --0.18%-- [...] | |--1.47%-- x86_pmu_enable | perf_pmu_enable | perf_adjust_freq_unthr_context.part.72 | perf_event_task_tick | scheduler_tick | update_process_times | tick_sched_handle.isra.12 | tick_sched_timer | __run_hrtimer | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | | | |--50.09%-- strmake_root | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --49.91%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | 0x155b79 | |--1.46%-- clockevents_program_event | tick_program_event | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | | | |--50.25%-- vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | 0x77c57 | | | --49.75%-- __strcmp_sse42 | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --0.73%-- x86_pmu_disable perf_pmu_disable ctx_sched_out __perf_event_task_sched_out perf_event_task_sched_out __schedule schedule schedule_hrtimeout_range_clock schedule_hrtimeout_range poll_schedule_timeout do_sys_poll sys_poll system_call_fastpath 0x7f6e103d500d vio_socket_io_wait vio_read net_read_raw_loop(st_net*, unsigned long) net_read_packet_header(st_net*) my_net_read do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.03% mysqld mysqld [.] strrchr@plt | --- strrchr@plt find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.02% mysqld [kernel.kallsyms] [k] __update_cpu_load | --- __update_cpu_load scheduler_tick update_process_times tick_sched_handle.isra.12 tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt | |--25.74%-- __strcmp_sse42 | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--19.78%-- __memcpy_sse2 | | | |--40.03%-- 0x5c9ee8d78948de89 | | | |--19.99%-- 0x0 | | | |--19.99%-- 0x6f666e695f7364 | | | --19.99%-- 0xfa0964 | |--14.19%-- my_qsort | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--10.76%-- vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--8.36%-- 0x965d2 | | | |--8.35%-- 0xe1254 | | | |--8.34%-- 0x1d5160 | | | |--8.34%-- 0x7cf85 | | | |--8.34%-- 0xcaf37 | | | |--8.33%-- 0xc959f | | | |--8.33%-- 0x16f4f9 | | | |--8.33%-- 0xc0275 | | | |--8.33%-- 0x15eea3 | | | |--8.32%-- 0xe6f1b | | | |--8.31%-- 0xf68a5 | | | --8.31%-- 0x1571de | |--6.28%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--14.31%-- 0x5b60d | | | |--14.31%-- 0x156eab | | | |--14.29%-- 0xadc21 | | | |--14.28%-- 0x27641 | | | |--14.28%-- 0x159b75 | | | |--14.27%-- 0x1ceb00 | | | --14.26%-- 0xcaf37 | |--4.49%-- __readdir64 | | | |--79.98%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --20.02%-- 0x492ec | |--3.55%-- comp_names | | | |--74.98%-- my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --25.02%-- my_qsort | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--2.69%-- __memmove_ssse3_back | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--2.69%-- __memmove_sse2 | | | |--33.37%-- 0x17d1f100000000 | | | |--33.34%-- 0x6d72662e31373835 | | | --33.29%-- 0xa8d7f00000000 | |--2.67%-- my_mb_wc_filename | | | |--66.67%-- strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | | filename_to_tablename(char const*, char*, unsigned int) | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --33.33%-- filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--1.80%-- _raw_spin_lock | dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | | | |--50.01%-- 0x61607 | | | --49.99%-- 0x902a5 | |--1.78%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--1.78%-- my_uni_utf8 | filename_to_tablename(char const*, char*, unsigned int) | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--0.90%-- strmake_root | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --0.89%-- wild_compare find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.02% mysqld [kernel.kallsyms] [k] fget_light | --- fget_light | |--70.42%-- sys_getdents | system_call_fastpath | __getdents64 | | | |--3.52%-- 0xbcf45 | | | |--3.51%-- 0xf98a2 | | | |--1.76%-- 0x1884e0 | | | |--1.76%-- 0x895df | | | |--1.76%-- 0x652d0 | | | |--1.76%-- 0x2d63b | | | |--1.76%-- 0x1581dd | | | |--1.76%-- 0x942a1 | | | |--1.76%-- 0x4a61e | | | |--1.76%-- 0x22313 | | | |--1.76%-- 0x11ff0 | | | |--1.76%-- 0xe5be9 | | | |--1.76%-- 0x745f4 | | | |--1.76%-- 0xcb59d | | | |--1.76%-- 0x8191a | | | |--1.76%-- 0x62c6c | | | |--1.76%-- 0x8d2a8 | | | |--1.76%-- 0xe7581 | | | |--1.76%-- 0xdcf25 | | | |--1.76%-- 0xab8f0 | | | |--1.76%-- 0x114221 | | | |--1.76%-- 0x1a3192 | | | |--1.76%-- 0xe2586 | | | |--1.75%-- 0xc58d6 | | | |--1.75%-- 0x155846 | | | |--1.75%-- 0xcd268 | | | |--1.75%-- 0x11821d | | | |--1.75%-- 0x177b57 | | | |--1.75%-- 0x67601 | | | |--1.75%-- 0x11a54e | | | |--1.75%-- 0xa05c8 | | | |--1.75%-- 0xf5240 | | | |--1.75%-- 0x113eee | | | |--1.75%-- 0x1901a5 | | | |--1.75%-- 0x119bb5 | | | |--1.75%-- 0xc98d2 | | | |--1.75%-- 0xbff42 | | | |--1.75%-- 0x16b830 | | | |--1.75%-- 0x1bab14 | | | |--1.75%-- 0x198803 | | | |--1.75%-- 0x72929 | | | |--1.75%-- 0x195b39 | | | |--1.75%-- 0x13186a | | | |--1.75%-- 0x1a5e5c | | | |--1.75%-- 0x2b63d | | | |--1.75%-- 0xaa8f1 | | | |--1.75%-- 0x10b22a | | | |--1.75%-- 0x1964d2 | | | |--1.75%-- 0xc8f39 | | | |--1.75%-- 0xacc4 | | | |--1.75%-- 0xffbcf | | | |--1.75%-- 0x1c0e41 | | | |--1.75%-- 0x42fbf | | | |--1.75%-- 0x1de157 | | | --1.71%-- 0xdc8bf | |--28.42%-- system_call_fastpath | __getdents64 | | | |--4.36%-- 0x18f4d9 | | | |--4.36%-- 0xb75b1 | | | |--4.35%-- 0x5094b | | | |--4.35%-- 0xb3282 | | | |--4.35%-- 0x662cf | | | |--4.35%-- 0x1631d2 | | | |--4.35%-- 0xdc58c | | | |--4.35%-- 0x11b54d | | | |--4.35%-- 0x1904d8 | | | |--4.35%-- 0x19a19b | | | |--4.35%-- 0x4a951 | | | |--4.35%-- 0xfff02 | | | |--4.35%-- 0xa5f5c | | | |--4.35%-- 0xb78e4 | | | |--4.35%-- 0x116885 | | | |--4.35%-- 0x1c0b0e | | | |--4.35%-- 0x5960f | | | |--4.34%-- 0x42626 | | | |--4.34%-- 0x17b4ed | | | |--4.34%-- 0x16f1c6 | | | |--4.34%-- 0xf623f | | | |--4.33%-- 0x1591dc | | | --4.33%-- 0x15aea7 | --1.16%-- sys_write system_call_fastpath 0x7f6e1171a1fd mi_recinfo_write mi_create create_myisam_tmp_table(TABLE*, st_key*, st_columndef*, st_columndef**, unsigned long long, char) instantiate_tmp_table(TABLE*, st_key*, st_columndef*, st_columndef**, unsigned long long, char, Opt_trace_context*) create_tmp_table(THD*, TMP_TABLE_PARAM*, List&, st_order*, bool, bool, unsigned long long, unsigned long long, char const*) create_schema_table(THD*, TABLE_LIST*) mysql_schema_table(THD*, LEX*, TABLE_LIST*) open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 0.01% mysqld [kernel.kallsyms] [k] trigger_load_balance | --- trigger_load_balance | |--98.27%-- scheduler_tick | update_process_times | tick_sched_handle.isra.12 | tick_sched_timer | __run_hrtimer | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | | | |--24.68%-- __memcpy_sse2 | | | | | |--50.00%-- 0x202444c74800 | | | | | --50.00%-- 0xfa0964 | | | |--21.09%-- vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--16.65%-- 0x1ad188 | | | | | |--8.35%-- 0x51617 | | | | | |--8.34%-- 0x1561df | | | | | |--8.34%-- 0xddf24 | | | | | |--8.34%-- 0xa85c0 | | | | | |--8.34%-- 0x6d5fb | | | | | |--8.34%-- 0xa75c1 | | | | | |--8.33%-- 0x19c7ff | | | | | |--8.33%-- 0x132869 | | | | | |--8.33%-- 0x15e83d | | | | | --8.32%-- 0x190e71 | | | |--17.43%-- __strcmp_sse42 | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--10.55%-- dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--16.69%-- 0x4dfb4 | | | | | |--16.69%-- 0x95f6c | | | | | |--16.67%-- 0x18b4dd | | | | | |--16.66%-- 0x8d2a8 | | | | | |--16.66%-- 0x187e7a | | | | | --16.63%-- 0x45fbc | | | |--10.45%-- my_qsort | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--5.27%-- _raw_spin_lock | | dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | | | | | |--33.37%-- 0x15f1d6 | | | | | |--33.34%-- 0x103232 | | | | | --33.30%-- 0x14db81 | | | |--1.76%-- __readdir64 | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--1.76%-- __memmove_ssse3_back | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--1.76%-- alloc_root | | strmake_root | | my_dir | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | |--1.76%-- __strlen_sse2 | | 0x6462692e32333733 | | | |--1.75%-- strconvert(charset_info_st*, char const*, charset_info_st*, char*, unsigned int, unsigned int*) | | filename_to_tablename(char const*, char*, unsigned int) | | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | | get_all_tables(THD*, TABLE_LIST*, Item*) | | get_schema_tables_result(JOIN*, enum_schema_table_state) | | JOIN::prepare_result(List**) | | JOIN::exec() | | mysql_execute_select(THD*, st_select_lex*, bool) | | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | | handle_select(THD*, select_result*, unsigned long) | | execute_sqlcom_select(THD*, TABLE_LIST*) | | mysql_execute_command(THD*) | | mysql_parse(THD*, char*, unsigned int, Parser_state*) | | dispatch_command(enum_server_command, THD*, char*, unsigned int) | | do_command(THD*) | | do_handle_one_connection(THD*) | | handle_one_connection | | pfs_spawn_thread | | start_thread | | | --1.74%-- comp_names | my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | --1.73%-- update_process_times tick_sched_handle.isra.12 tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt __memcpy_sse2 ######### [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: perf record -ag -p $( pidof mysqld ) -- sleep 120 PID/TID switch overriding SYSTEM[ perf record: Woken up 243 times to write data ] [ perf record: Captured and wrote 60.779 MB perf.data (~2655482 samples) ] [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: perf report|c++filt [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: perf report|c++filt # ======== # captured on: Wed Dec 21 10:00:41 2016 # hostname : hod03 # os release : 3.8.13-98.2.2.el7uek.x86_64 # perf version : 3.8.13-98.2.2.el7uek.x86_64 # arch : x86_64 # nrcpus online : 32 # nrcpus avail : 32 # cpudesc : Intel(R) Xeon(R) CPU E5-2650 v2 @ 2.60GHz # cpuid : GenuineIntel,6,62,4 # total memory : 264098836 kB # cmdline : /usr/libexec/perf.3.8.13-98.2.2.el7uek.x86_64 record -ag -p 21156 -- sleep 120 # event : name = cycles, type = 0, config = 0x0, config1 = 0x0, config2 = 0x0, excl_usr = 0, excl_kern = 0, excl_host = 0, excl_guest = 1, precise_ip = 0, id = { 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414 } # HEADER_CPU_TOPOLOGY info available, use -I to display # HEADER_NUMA_TOPOLOGY info available, use -I to display # pmu mappings: cpu = 4, software = 1, tracepoint = 2, breakpoint = 5 # ======== # # Samples: 479K of event 'cycles' # Event count (approx.): 307900981786 # # Overhead Command Shared Object Symbol # ........ ....... ................... .............................................................................................................................................................................................. # 24.59% mysqld libc-2.17.so [.] __memcpy_sse2 | --- __memcpy_sse2 | |--2.77%-- 0x0 | |--1.55%-- 0xfa0964 | |--1.53%-- 0x8d48000001d890ff | |--1.40%-- 0x152ba002ec8 | |--1.36%-- 0x3436358b4cffb99b | |--1.30%-- 0xc8b3894800 | |--1.04%-- 0x5c9ee8d78948de89 | |--0.94%-- 0x202444c74800 | |--0.83%-- 0xc28948c08548004f | |--0.77%-- 0xb60f41c2094810e0 | |--0.75%-- 0xc045c679726f7463 | |--0.71%-- 0x746165726336656c | |--0.66%-- 0x8348fb894810678d | |--0.65%-- 0xfffffc9c850f00b0 | |--0.61%-- 0x6c665f625f796d00 | |--0.61%-- 0x6f666e695f7364 | |--0.58%-- 0x18 | 0xd83710 | __cxxabiv1::__si_class_type_info::~__si_class_type_info() | 0x1de907894810c083 | |--0.55%-- 0xc00120002e0ff | |--0.50%-- 0x5f636e75665f6d65 --80.89%-- [...] 13.95% mysqld libc-2.17.so [.] __strcmp_sse42 | --- __strcmp_sse42 | |--94.87%-- my_dir | find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread | |--5.13%-- find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) | get_all_tables(THD*, TABLE_LIST*, Item*) | get_schema_tables_result(JOIN*, enum_schema_table_state) | JOIN::prepare_result(List**) | JOIN::exec() | mysql_execute_select(THD*, st_select_lex*, bool) | mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) | handle_select(THD*, select_result*, unsigned long) | execute_sqlcom_select(THD*, TABLE_LIST*) | mysql_execute_command(THD*) | mysql_parse(THD*, char*, unsigned int, Parser_state*) | dispatch_command(enum_server_command, THD*, char*, unsigned int) | do_command(THD*) | do_handle_one_connection(THD*) | handle_one_connection | pfs_spawn_thread | start_thread --0.00%-- [...] 13.37% mysqld [kernel.kallsyms] [k] dcache_readdir | --- dcache_readdir | |--100.00%-- vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 --0.00%-- [...] 9.88% mysqld mysqld [.] my_qsort | --- my_qsort my_dir find_files(THD*, List*, char const*, char const*, char const*, bool, st_mem_root*) get_all_tables(THD*, TABLE_LIST*, Item*) get_schema_tables_result(JOIN*, enum_schema_table_state) JOIN::prepare_result(List**) JOIN::exec() mysql_execute_select(THD*, st_select_lex*, bool) mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, SQL_I_List*, SQL_I_List*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) handle_select(THD*, select_result*, unsigned long) execute_sqlcom_select(THD*, TABLE_LIST*) mysql_execute_command(THD*) mysql_parse(THD*, char*, unsigned int, Parser_state*) dispatch_command(enum_server_command, THD*, char*, unsigned int) do_command(THD*) do_handle_one_connection(THD*) handle_one_connection pfs_spawn_thread start_thread 6.89% mysqld [kernel.kallsyms] [k] __list_add | --- __list_add | |--99.16%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 | --0.84%-- vfs_readdir sys_getdents system_call_fastpath __getdents64 | |--1.08%-- 0xe5250 | |--0.72%-- 0x34634 | |--0.72%-- 0x4cc82 | |--0.72%-- 0x582dd | |--0.72%-- 0x47c87 | |--0.72%-- 0xe0255 | |--0.72%-- 0xe18ba | |--0.72%-- 0xc9f38 | |--0.72%-- 0xe2253 | |--0.72%-- 0x145523 | |--0.72%-- 0xeebe0 | |--0.72%-- 0x136532 | |--0.72%-- 0x157511 --90.29%-- [...] 5.60% mysqld [kernel.kallsyms] [k] __ticket_spin_lock | --- __ticket_spin_lock | |--97.47%-- _raw_spin_lock | | | |--99.35%-- dcache_readdir | | vfs_readdir | | sys_getdents | | system_call_fastpath | | __getdents64 | --0.65%-- [...] | |--2.24%-- dcache_readdir | vfs_readdir | sys_getdents | system_call_fastpath | __getdents64 --0.29%-- [...]