------------------------------- group by with rollup (faster) 15seconds ------------------------------- 1. CPU Time Module Function (Full) memcpy 1.449s mysqld.exe memcpy 1.1 CPU Time Module Function (Full) _mi_get_binary_pack_key 0.591s mysqld.exe memcpy mysqld.exe!memcpy - memcpy.asm mysqld.exe!_mi_get_binary_pack_key - mi_search.c:1037 mysqld.exe!_mi_seq_search - mi_search.c:261 mysqld.exe!_mi_search - mi_search.c:90 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!mi_rkey - mi_rkey.c:95 mysqld.exe!ha_myisam::index_read_map(unsigned char *,unsigned char const *,unsigned long,enum ha_rkey_function) - ha_myisam.cc:1558 mysqld.exe!join_read_always_key - sql_select.cc:12337 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11700 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 1.2 CPU Time Module Function (Full) _mi_seq_search<-_mi_search<-_mi_search 0.425s mysqld.exe memcpy mysqld.exe!memcpy - memcpy.asm mysqld.exe!_mi_seq_search - mi_search.c:278 mysqld.exe!_mi_search - mi_search.c:90 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!mi_rkey - mi_rkey.c:95 mysqld.exe!ha_myisam::index_read_map(unsigned char *,unsigned char const *,unsigned long,enum ha_rkey_function) - ha_myisam.cc:1558 mysqld.exe!join_read_always_key - sql_select.cc:12337 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11700 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 2. CPU Time Module Function (Full) _mi_get_binary_pack_key 1.025s mysqld.exe _mi_get_binary_pack_key mysqld.exe!_mi_get_binary_pack_key - mi_search.c mysqld.exe!_mi_seq_search - mi_search.c:261 mysqld.exe!_mi_search - mi_search.c:90 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!mi_rkey - mi_rkey.c:95 mysqld.exe!ha_myisam::index_read_map(unsigned char *,unsigned char const *,unsigned long,enum ha_rkey_function) - ha_myisam.cc:1558 mysqld.exe!join_read_always_key - sql_select.cc:12337 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11700 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 3. CPU Time Module Function (Full) memmove 1.010s mysqld.exe memmove mysqld.exe!memmove - MEMCPY.ASM mysqld.exe!_mi_get_binary_pack_key - mi_search.c:1005 mysqld.exe!_mi_seq_search - mi_search.c:261 mysqld.exe!_mi_search - mi_search.c:90 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!mi_rkey - mi_rkey.c:95 mysqld.exe!ha_myisam::index_read_map(unsigned char *,unsigned char const *,unsigned long,enum ha_rkey_function) - ha_myisam.cc:1558 mysqld.exe!join_read_always_key - sql_select.cc:12337 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11700 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 4. CPU Time Module Function (Full) ha_key_cmp 0.731s mysqld.exe ha_key_cmp mysqld.exe!ha_key_cmp - my_compare.c mysqld.exe!_mi_seq_search - mi_search.c:272 mysqld.exe!_mi_search - mi_search.c:90 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!mi_rkey - mi_rkey.c:95 mysqld.exe!ha_myisam::index_read_map(unsigned char *,unsigned char const *,unsigned long,enum ha_rkey_function) - ha_myisam.cc:1558 mysqld.exe!join_read_always_key - sql_select.cc:12337 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11700 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 5. CPU Time Module Function (Full) my_strnncollsp_simple 0.663s mysqld.exe my_strnncollsp_simple mysqld.exe!my_strnncollsp_simple - ctype-simple.c mysqld.exe!ha_compare_text - my_compare.c:30 mysqld.exe!ha_key_cmp - my_compare.c:183 mysqld.exe!_mi_seq_search - mi_search.c:272 mysqld.exe!_mi_search - mi_search.c:90 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!_mi_search - mi_search.c:99 mysqld.exe!mi_rkey - mi_rkey.c:95 mysqld.exe!ha_myisam::index_read_map(unsigned char *,unsigned char const *,unsigned long,enum ha_rkey_function) - ha_myisam.cc:1558 mysqld.exe!join_read_always_key - sql_select.cc:12337 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11700 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 6. CPU Time Module Function (Full) my_win_write 0.462s mysqld.exe my_win_write mysqld.exe!my_win_write - my_winfile.c mysqld.exe!my_write - my_write.c:39 mysqld.exe!inline_mysql_file_write - mysql_file.h:1134 mysqld.exe!my_b_flush_io_cache - mf_iocache.c:1776 mysqld.exe!_my_b_write - mf_iocache.c:1544 mysqld.exe!write_keys - filesort.cc:721 mysqld.exe!find_all_keys - filesort.cc:630 mysqld.exe!filesort(class THD *,struct TABLE *,struct st_sort_field *,unsigned int,class SQL_SELECT *,unsigned __int64,bool,unsigned __int64 *) - filesort.cc:252 mysqld.exe!create_sort_index - sql_select.cc:14109 mysqld.exe!JOIN::exec(void) - sql_select.cc:2340 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 7. CPU Time Module Function (Full) radixsort_for_str_ptr 0.424s mysqld.exe radixsort_for_str_ptr mysqld.exe!radixsort_for_str_ptr - mf_radix.c mysqld.exe!my_string_ptr_sort - mf_sort.c:29 mysqld.exe!write_keys - filesort.cc:707 mysqld.exe!find_all_keys - filesort.cc:630 mysqld.exe!filesort(class THD *,struct TABLE *,struct st_sort_field *,unsigned int,class SQL_SELECT *,unsigned __int64,bool,unsigned __int64 *) - filesort.cc:252 mysqld.exe!create_sort_index - sql_select.cc:14109 mysqld.exe!JOIN::exec(void) - sql_select.cc:2340 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] ----------------- group by (slower) 50seconds ----------------- 1. CPU Time Module Function (Full) my_win_pwrite 11.562s mysqld.exe my_win_pwrite mysqld.exe!my_win_pwrite - my_winfile.c mysqld.exe!my_pwrite - my_pread.c:160 mysqld.exe!inline_mysql_file_pwrite - mysql_file.h:1201 mysqld.exe!mi_nommap_pwrite - mi_dynrec.c:258 mysqld.exe!_mi_update_static_record - mi_statrec.c:94 mysqld.exe!mi_update - mi_update.c:154 mysqld.exe!ha_myisam::update_row(unsigned char const *,unsigned char *) - ha_myisam.cc:1542 mysqld.exe!handler::ha_update_row(unsigned char const *,unsigned char *) - handler.cc:4813 mysqld.exe!end_unique_update - sql_select.cc:12972 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 2. CPU Time Module Function (Full) _mi_get_binary_pack_key 4.049s mysqld.exe _mi_get_binary_pack_key mysqld.exe!_mi_get_binary_pack_key - mi_search.c mysqld.exe!_mi_seq_search - mi_search.c:261 mysqld.exe!w_search - mi_write.c:356 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!_mi_ck_real_write_btree - mi_write.c:297 mysqld.exe!_mi_ck_write_btree - mi_write.c:276 mysqld.exe!mi_write - mi_write.c:121 mysqld.exe!ha_myisam::write_row(unsigned char *) - ha_myisam.cc:788 mysqld.exe!handler::ha_write_row(unsigned char *) - handler.cc:4788 mysqld.exe!end_unique_update - sql_select.cc:12955 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 3. CPU Time Module Function (Full) ha_key_cmp 3.890s mysqld.exe ha_key_cmp mysqld.exe!ha_key_cmp - my_compare.c mysqld.exe!_mi_seq_search - mi_search.c:272 mysqld.exe!w_search - mi_write.c:356 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!_mi_ck_real_write_btree - mi_write.c:297 mysqld.exe!_mi_ck_write_btree - mi_write.c:276 mysqld.exe!mi_write - mi_write.c:121 mysqld.exe!ha_myisam::write_row(unsigned char *) - ha_myisam.cc:788 mysqld.exe!handler::ha_write_row(unsigned char *) - handler.cc:4788 mysqld.exe!end_unique_update - sql_select.cc:12955 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 4. CPU Time Module Function (Full) memcpy 3.705s mysqld.exe memcpy 4.1 CPU Time Module Function (Full) _mi_get_binary_pack_key 1.672s mysqld.exe memcpy mysqld.exe!memcpy - memcpy.asm mysqld.exe!_mi_get_binary_pack_key - mi_search.c:1037 mysqld.exe!_mi_seq_search - mi_search.c:261 mysqld.exe!w_search - mi_write.c:356 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!_mi_ck_real_write_btree - mi_write.c:297 mysqld.exe!_mi_ck_write_btree - mi_write.c:276 mysqld.exe!mi_write - mi_write.c:121 mysqld.exe!ha_myisam::write_row(unsigned char *) - ha_myisam.cc:788 mysqld.exe!handler::ha_write_row(unsigned char *) - handler.cc:4788 mysqld.exe!end_unique_update - sql_select.cc:12955 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 4.2 CPU Time Module Function (Full) _mi_seq_search 1.608s mysqld.exe memcpy mysqld.exe!memcpy - memcpy.asm mysqld.exe!_mi_seq_search - mi_search.c:278 mysqld.exe!w_search - mi_write.c:356 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!_mi_ck_real_write_btree - mi_write.c:297 mysqld.exe!_mi_ck_write_btree - mi_write.c:276 mysqld.exe!mi_write - mi_write.c:121 mysqld.exe!ha_myisam::write_row(unsigned char *) - ha_myisam.cc:788 mysqld.exe!handler::ha_write_row(unsigned char *) - handler.cc:4788 mysqld.exe!end_unique_update - sql_select.cc:12955 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 5. CPU Time Module Function (Full) memmove 3.436s mysqld.exe memmove mysqld.exe!memmove - MEMCPY.ASM mysqld.exe!_mi_get_binary_pack_key - mi_search.c:1005 mysqld.exe!_mi_seq_search - mi_search.c:261 mysqld.exe!w_search - mi_write.c:356 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!_mi_ck_real_write_btree - mi_write.c:297 mysqld.exe!_mi_ck_write_btree - mi_write.c:276 mysqld.exe!mi_write - mi_write.c:121 mysqld.exe!ha_myisam::write_row(unsigned char *) - ha_myisam.cc:788 mysqld.exe!handler::ha_write_row(unsigned char *) - handler.cc:4788 mysqld.exe!end_unique_update - sql_select.cc:12955 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 6. CPU Time Module Function (Full) my_strnncollsp_simple 2.713s mysqld.exe my_strnncollsp_simple mysqld.exe!my_strnncollsp_simple - ctype-simple.c mysqld.exe!ha_compare_text - my_compare.c:30 mysqld.exe!ha_key_cmp - my_compare.c:183 mysqld.exe!_mi_seq_search - mi_search.c:272 mysqld.exe!w_search - mi_write.c:356 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!w_search - mi_write.c:418 mysqld.exe!_mi_ck_real_write_btree - mi_write.c:297 mysqld.exe!_mi_ck_write_btree - mi_write.c:276 mysqld.exe!mi_write - mi_write.c:121 mysqld.exe!ha_myisam::write_row(unsigned char *) - ha_myisam.cc:788 mysqld.exe!handler::ha_write_row(unsigned char *) - handler.cc:4788 mysqld.exe!end_unique_update - sql_select.cc:12955 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown] 7. CPU Time Module Function (Full) my_win_pread 2.414s mysqld.exe my_win_pread mysqld.exe!my_win_pread - my_winfile.c mysqld.exe!my_pread - my_pread.c:73 mysqld.exe!inline_mysql_file_pread - mysql_file.h:1167 mysqld.exe!mi_nommap_pread - mi_dynrec.c:201 mysqld.exe!_mi_read_static_record - mi_statrec.c:179 mysqld.exe!_mi_read_rnd_static_record - mi_statrec.c:263 mysqld.exe!mi_rrnd - mi_rrnd.c:58 mysqld.exe!ha_myisam::rnd_pos(unsigned char *,unsigned char *) - ha_myisam.cc:1680 mysqld.exe!end_unique_update - sql_select.cc:12964 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!evaluate_join_record - sql_select.cc:11848 mysqld.exe!sub_select(class JOIN *,struct st_join_table *,bool) - sql_select.cc:11706 mysqld.exe!do_select - sql_select.cc:11466 mysqld.exe!JOIN::exec(void) - sql_select.cc:1977 mysqld.exe!mysql_select(class THD *,class Item * * *,struct TABLE_LIST *,unsigned int,class List &,class Item *,unsigned int,struct st_order *,struct st_order *,class Item *,struct st_order *,unsigned __int64,class select_result *,class st_select_lex_unit *,class st_select_lex *) - sql_select.cc:2579 mysqld.exe!handle_select(class THD *,struct LEX *,class select_result *,unsigned long) - sql_select.cc:297 mysqld.exe!execute_sqlcom_select - sql_parse.cc:4466 mysqld.exe!mysql_execute_command(class THD *) - sql_parse.cc:2052 mysqld.exe!mysql_parse(class THD *,char *,unsigned int,class Parser_state *) - sql_parse.cc:5503 mysqld.exe!dispatch_command(enum enum_server_command,class THD *,char *,unsigned int) - sql_parse.cc:1034 mysqld.exe!do_command(class THD *) - sql_parse.cc:771 mysqld.exe!do_handle_one_connection(class THD *) - sql_connect.cc:771 mysqld.exe!handle_one_connection - sql_connect.cc:707 mysqld.exe!pthread_start - my_winthread.c:61 mysqld.exe!callthreadstartex - threadex.c:348 mysqld.exe!threadstartex - threadex.c:326 kernel32.dll!GetModuleFileNameA+0xb728 - [Unknown] ntdll.dll!NtRegisterThreadTerminatePort+0xda19 - [Unknown]