-------------------------------------------------------------------------------- Command: bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.29/80645/log.err Massif arguments: --massif-out-file=/tmp/massif.out ms_print arguments: /tmp/massif.out -------------------------------------------------------------------------------- MB 824.4^ : | #:::::::::@:::::@:::: | # : ::::::@:::::@:::: | @@# : ::::::@:::::@:::: | @ # : ::::::@:::::@:::: | @@ # : ::::::@:::::@:::: | @@@ # : ::::::@:::::@:::: | @@@ # : ::::::@:::::@:::: | @@@@ # : ::::::@:::::@:::: | ::::::::::::::::::::::::::::::::::::::@@@@ # : ::::::@:::::@::::@ |:::::::::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ |: :::: ::::: :::::: ::::::: ::::: :::: ::: ::@@@@ # : ::::::@:::::@::::@ 0 +----------------------------------------------------------------------->Gi 0 50.55 Number of snapshots: 76 Detailed snapshots: [38, 39, 40, 41, 42 (peak), 54, 64, 74] -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 0 0 0 0 0 0 1 651,986,241 457,485,680 457,078,224 407,456 0 2 1,706,244,621 462,801,184 462,120,924 680,260 0 3 2,559,232,145 467,038,896 466,142,525 896,371 0 4 3,266,290,313 469,284,264 468,275,275 1,008,989 0 5 4,187,202,382 472,418,496 471,255,846 1,162,650 0 6 5,492,952,615 477,147,032 475,753,995 1,393,037 0 7 6,522,943,468 480,584,048 479,038,493 1,545,555 0 8 7,288,233,174 483,491,040 481,827,788 1,663,252 0 9 7,897,661,790 485,638,104 483,888,814 1,749,290 0 10 8,861,315,818 488,883,312 487,003,925 1,879,387 0 11 9,985,402,608 478,748,720 477,147,674 1,601,046 0 12 10,627,007,142 481,019,400 479,316,993 1,702,407 0 13 11,535,322,856 484,106,960 482,275,002 1,831,958 0 14 12,572,316,121 487,695,872 485,709,729 1,986,143 0 15 13,497,783,481 490,672,312 488,557,424 2,114,888 0 16 14,110,734,804 492,759,072 490,556,011 2,203,061 0 17 15,136,746,870 496,204,120 493,861,254 2,342,866 0 18 15,843,363,683 498,690,552 496,249,727 2,440,825 0 19 16,587,666,875 500,980,576 498,447,097 2,533,479 0 20 17,518,546,713 503,956,648 501,315,245 2,641,403 0 21 18,263,000,706 505,502,120 502,810,571 2,691,549 0 22 19,289,510,156 507,699,168 504,935,755 2,763,413 0 23 20,033,710,689 509,674,456 506,846,311 2,828,145 0 24 21,177,985,232 513,021,064 510,079,910 2,941,154 0 25 22,109,769,641 515,760,504 512,722,002 3,038,502 0 26 23,303,988,945 517,908,152 514,786,735 3,121,417 0 27 24,048,078,292 517,971,584 514,838,783 3,132,801 0 28 24,792,818,673 518,132,800 514,988,459 3,144,341 0 29 25,878,195,188 518,286,624 515,125,563 3,161,061 0 30 26,692,159,993 518,386,392 515,212,975 3,173,417 0 31 27,777,599,349 498,161,768 495,614,038 2,547,730 0 32 28,591,752,201 500,575,600 497,940,440 2,635,160 0 33 29,406,188,214 503,011,296 500,289,686 2,721,610 0 34 30,225,995,642 505,371,176 502,566,359 2,804,817 0 35 31,582,668,825 509,401,592 506,446,716 2,954,876 0 36 32,939,688,242 513,442,416 510,336,846 3,105,570 0 37 33,482,438,287 515,117,416 511,948,724 3,168,692 0 38 34,504,515,433 555,347,416 551,961,189 3,386,227 0 99.39% (551,961,189B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->76.27% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->49.99% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->49.99% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->49.99% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->49.99% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->06.83% (37,950,400B) in 35 places, all below massif's threshold (01.00%) | | | ->06.68% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->06.68% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->06.68% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->06.68% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->03.69% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->03.69% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->03.69% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->03.69% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.24% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->02.24% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.24% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.24% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.84% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->01.84% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.84% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.84% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.84% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->01.84% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.84% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.84% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.67% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | | ->01.67% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | | | ->01.48% (8,232,960B) 0xAD9CC8: init_instruments(PFS_global_param const*) (pfs_instr.cc:389) | ->01.48% (8,232,960B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | ->01.48% (8,232,960B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | ->01.48% (8,232,960B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->10.26% (57,005,944B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->10.26% (57,005,944B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->06.11% (33,926,240B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | | ->02.16% (11,996,424B) 0xA7051C: dict_mem_table_create(char const*, unsigned long, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->01.62% (8,993,952B) 0xA65E1D: dict_load_table_low(char const*, unsigned char const*, dict_table_t**) (dict0load.cc:2178) | | | | ->01.62% (8,993,952B) 0xA692EA: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2346) | | | | ->01.62% (8,986,608B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | ->01.62% (8,986,608B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | ->01.62% (8,986,608B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | ->01.62% (8,986,608B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | ->01.62% (8,986,608B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | ->01.62% (8,985,384B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | ->01.57% (8,723,448B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | ->01.57% (8,723,448B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | ->01.57% (8,723,448B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | ->01.57% (8,723,448B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | ->01.57% (8,723,448B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | ->01.57% (8,723,448B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | ->01.57% (8,723,448B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | ->01.57% (8,723,448B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | ->01.57% (8,723,448B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | ->01.57% (8,723,448B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | ->01.57% (8,723,448B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | ->01.57% (8,723,448B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | ->00.05% (261,936B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (1,224B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.00% (7,344B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.54% (3,002,472B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.02% (11,210,056B) 0xA70988: dict_mem_index_create(char const*, char const*, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->02.02% (11,210,056B) 0xA5DF59: dict_index_add_to_cache(dict_table_t*, dict_index_t*, unsigned long, unsigned long) (dict0dict.cc:2988) | | | | ->01.51% (8,406,112B) 0xA68CD8: dict_load_indexes(dict_table_t*, mem_block_info_t*, dict_err_ignore_t) (dict0load.cc:2010) | | | | | ->01.51% (8,406,112B) 0xA69BB5: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2443) | | | | | ->01.51% (8,399,248B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | | ->01.51% (8,399,248B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | | ->01.51% (8,399,248B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | | ->01.51% (8,399,248B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | | ->01.51% (8,399,248B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | | ->01.51% (8,398,104B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | | ->01.47% (8,153,288B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | | ->01.47% (8,153,288B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | | ->01.47% (8,153,288B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | | ->01.47% (8,153,288B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | | ->01.47% (8,153,288B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | | ->01.47% (8,153,288B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | | ->01.47% (8,153,288B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | | ->01.47% (8,153,288B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | | ->01.47% (8,153,288B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | | ->01.47% (8,153,288B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | | ->01.47% (8,153,288B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | | ->01.47% (8,153,288B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | | | ->00.04% (244,816B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | | | ->00.00% (1,144B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (6,864B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.50% (2,803,944B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.93% (10,719,760B) in 25 places, all below massif's threshold (01.00%) | | | ->02.65% (14,690,480B) in 106 places, all below massif's threshold (01.00%) | | | ->01.51% (8,389,224B) 0x96E14D: log_init() (mem0mem.ic:449) | ->01.51% (8,389,224B) 0x9E93CD: innobase_start_or_create_for_mysql() (srv0start.cc:2005) | ->01.51% (8,389,224B) 0x930A04: innobase_init(void*) (ha_innodb.cc:3418) | ->01.51% (8,389,224B) 0x58F9A4: ha_initialize_handlerton(st_plugin_int*) (handler.cc:662) | ->01.51% (8,389,224B) 0x703F1E: plugin_initialize(st_plugin_int*) (sql_plugin.cc:1137) | ->01.51% (8,389,224B) 0x70496B: plugin_init(int*, char**, int) (sql_plugin.cc:1431) | ->01.51% (8,389,224B) 0x58621E: init_server_components() (mysqld.cc:4866) | ->01.51% (8,389,224B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | ->01.51% (8,389,224B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->08.77% (48,694,283B) 0x90BA00: my_malloc (my_malloc.c:38) | ->05.45% (30,263,296B) 0x90804C: alloc_root (my_alloc.c:224) | | ->02.93% (16,293,376B) in 50 places, all below massif's threshold (01.00%) | | | | | ->02.52% (13,969,920B) 0x67C4AE: sp_head::reset_lex(THD*) (sql_lex.h:2868) | | ->02.20% (12,223,680B) 0x7BA052: MYSQLparse(THD*) (sql_yacc.yy:3800) | | | ->02.20% (12,223,680B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->02.20% (12,223,680B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->02.20% (12,223,680B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->02.20% (12,223,680B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->02.20% (12,223,680B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->02.20% (12,223,680B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->02.20% (12,223,680B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->02.20% (12,223,680B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->02.20% (12,223,680B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->02.20% (12,223,680B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->02.20% (12,223,680B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->02.20% (12,223,680B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->02.20% (12,223,680B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->02.20% (12,223,680B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->02.20% (12,223,680B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.31% (1,746,240B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->02.08% (11,572,235B) in 52 places, all below massif's threshold (01.00%) | | | ->01.24% (6,858,752B) 0x915F67: my_large_malloc (my_largepage.c:64) | ->01.24% (6,858,752B) 0x900BBF: init_key_cache (mf_keycache.c:430) | ->01.24% (6,858,752B) 0x595DE6: ha_init_key_cache (handler.cc:5125) | ->01.24% (6,858,752B) 0x65F442: process_key_caches(int (*)(char const*, st_key_cache*)) (keycaches.cc:128) | ->01.24% (6,858,752B) 0x5861BB: init_server_components() (mysqld.cc:4851) | ->01.24% (6,858,752B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | ->01.24% (6,858,752B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->03.71% (20,611,730B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->02.39% (13,292,800B) 0x981886: os_event_create() (os0sync.cc:370) | | ->02.39% (13,292,800B) in 23 places, all below massif's threshold (01.00%) | | | ->01.32% (7,318,930B) in 30 places, all below massif's threshold (01.00%) | ->00.38% (2,085,648B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 39 35,112,391,612 608,104,704 604,543,483 3,561,221 0 99.41% (604,543,483B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->69.65% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->45.65% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->45.65% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->45.65% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->45.65% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->06.24% (37,950,400B) in 35 places, all below massif's threshold (01.00%) | | | ->06.10% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->06.10% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->06.10% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->06.10% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->03.37% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->03.37% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->03.37% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->03.37% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.04% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->02.04% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.04% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.04% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.68% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->01.68% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.68% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.68% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.68% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->01.68% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.68% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.68% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.53% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | | ->01.53% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | | | ->01.35% (8,232,960B) 0xAD9CC8: init_instruments(PFS_global_param const*) (pfs_instr.cc:389) | ->01.35% (8,232,960B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | ->01.35% (8,232,960B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | ->01.35% (8,232,960B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->16.19% (98,443,697B) 0x90BA00: my_malloc (my_malloc.c:38) | ->11.73% (71,360,248B) 0x90804C: alloc_root (my_alloc.c:224) | | ->05.51% (33,488,640B) 0x67C4AE: sp_head::reset_lex(THD*) (sql_lex.h:2868) | | | ->04.82% (29,302,560B) 0x7BA052: MYSQLparse(THD*) (sql_yacc.yy:3800) | | | | ->04.82% (29,302,560B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->04.82% (29,302,560B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->04.82% (29,302,560B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->04.82% (29,302,560B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->04.82% (29,302,560B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->04.82% (29,302,560B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->04.82% (29,302,560B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->04.82% (29,302,560B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->04.82% (29,302,560B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->04.82% (29,302,560B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->04.82% (29,302,560B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->04.82% (29,302,560B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->04.82% (29,302,560B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->04.82% (29,302,560B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->04.82% (29,302,560B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.69% (4,186,080B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.10% (12,755,128B) in 47 places, all below massif's threshold (01.00%) | | | | | ->01.38% (8,372,160B) 0x6F12A7: st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List*, List*, st_mysql_lex_string*) (sql_class.h:752) | | | ->01.38% (8,372,160B) 0x7B4B71: MYSQLparse(THD*) (sql_yacc.yy:11918) | | | ->01.38% (8,372,160B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.38% (8,372,160B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.38% (8,372,160B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.38% (8,372,160B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.38% (8,372,160B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.38% (8,372,160B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.38% (8,372,160B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.38% (8,372,160B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.38% (8,372,160B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.38% (8,372,160B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.38% (8,372,160B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.38% (8,372,160B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.38% (8,372,160B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.38% (8,372,160B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.38% (8,372,160B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.38% (8,372,160B) 0x7C2267: MYSQLparse(THD*) (item.h:661) | | | ->01.38% (8,372,160B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.38% (8,372,160B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.38% (8,372,160B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.38% (8,372,160B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.38% (8,372,160B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.38% (8,372,160B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.38% (8,372,160B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.38% (8,372,160B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.38% (8,372,160B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.38% (8,372,160B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.38% (8,372,160B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.38% (8,372,160B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.38% (8,372,160B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.38% (8,372,160B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.38% (8,372,160B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.38% (8,372,160B) 0x7C1CD0: MYSQLparse(THD*) (item.h:661) | | ->01.38% (8,372,160B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | ->01.38% (8,372,160B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | ->01.38% (8,372,160B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | ->01.38% (8,372,160B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | ->01.38% (8,372,160B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | ->01.38% (8,372,160B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | ->01.38% (8,372,160B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | ->01.38% (8,372,160B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | ->01.38% (8,372,160B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | ->01.38% (8,372,160B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | ->01.38% (8,372,160B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | ->01.38% (8,372,160B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | ->01.38% (8,372,160B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | ->01.38% (8,372,160B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | ->01.38% (8,372,160B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->01.77% (10,749,609B) in 51 places, all below massif's threshold (01.00%) | | | ->01.56% (9,475,088B) 0x8F9994: init_dynamic_array2 (array.c:70) | | ->01.40% (8,541,920B) 0x8FB5B2: _my_hash_init (hash.c:111) | | | ->01.40% (8,541,920B) in 45 places, all below massif's threshold (01.00%) | | | | | ->00.15% (933,168B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->01.13% (6,858,752B) 0x915F67: my_large_malloc (my_largepage.c:64) | ->01.13% (6,858,752B) 0x900BBF: init_key_cache (mf_keycache.c:430) | ->01.13% (6,858,752B) 0x595DE6: ha_init_key_cache (handler.cc:5125) | ->01.13% (6,858,752B) 0x65F442: process_key_caches(int (*)(char const*, st_key_cache*)) (keycaches.cc:128) | ->01.13% (6,858,752B) 0x5861BB: init_server_components() (mysqld.cc:4851) | ->01.13% (6,858,752B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | ->01.13% (6,858,752B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->09.81% (59,661,248B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->09.81% (59,661,248B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->05.73% (34,830,496B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | | ->02.02% (12,257,136B) 0xA7051C: dict_mem_table_create(char const*, unsigned long, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->01.52% (9,254,664B) 0xA65E1D: dict_load_table_low(char const*, unsigned char const*, dict_table_t**) (dict0load.cc:2178) | | | | ->01.52% (9,254,664B) 0xA692EA: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2346) | | | | ->01.52% (9,247,320B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | ->01.52% (9,247,320B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | ->01.52% (9,247,320B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | ->01.52% (9,247,320B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | ->01.52% (9,247,320B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | ->01.52% (9,246,096B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | ->01.43% (8,723,448B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | ->01.43% (8,723,448B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | ->01.43% (8,723,448B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | ->01.43% (8,723,448B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | ->01.43% (8,723,448B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | ->01.43% (8,723,448B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | ->01.43% (8,723,448B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | ->01.43% (8,723,448B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | ->01.43% (8,723,448B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | ->01.43% (8,723,448B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | ->01.43% (8,723,448B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | ->01.43% (8,723,448B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | ->00.09% (522,648B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (1,224B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.00% (7,344B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.49% (3,002,472B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.88% (11,453,728B) 0xA70988: dict_mem_index_create(char const*, char const*, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->01.88% (11,453,728B) 0xA5DF59: dict_index_add_to_cache(dict_table_t*, dict_index_t*, unsigned long, unsigned long) (dict0dict.cc:2988) | | | | ->01.42% (8,649,784B) 0xA68CD8: dict_load_indexes(dict_table_t*, mem_block_info_t*, dict_err_ignore_t) (dict0load.cc:2010) | | | | | ->01.42% (8,649,784B) 0xA69BB5: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2443) | | | | | ->01.42% (8,642,920B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | | ->01.42% (8,642,920B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | | ->01.42% (8,642,920B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | | ->01.42% (8,642,920B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | | ->01.42% (8,642,920B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | | ->01.42% (8,641,776B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | | ->01.34% (8,153,288B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | | ->01.34% (8,153,288B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | | ->01.34% (8,153,288B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | | ->01.34% (8,153,288B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | | ->01.34% (8,153,288B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | | ->01.34% (8,153,288B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | | ->01.34% (8,153,288B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | | ->01.34% (8,153,288B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | | ->01.34% (8,153,288B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | | ->01.34% (8,153,288B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | | ->01.34% (8,153,288B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | | ->01.34% (8,153,288B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | | | ->00.08% (488,488B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | | | ->00.00% (1,144B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (6,864B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.46% (2,803,944B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.83% (11,119,632B) in 25 places, all below massif's threshold (01.00%) | | | ->02.70% (16,441,528B) in 106 places, all below massif's threshold (01.00%) | | | ->01.38% (8,389,224B) 0x96E14D: log_init() (mem0mem.ic:449) | ->01.38% (8,389,224B) 0x9E93CD: innobase_start_or_create_for_mysql() (srv0start.cc:2005) | ->01.38% (8,389,224B) 0x930A04: innobase_init(void*) (ha_innodb.cc:3418) | ->01.38% (8,389,224B) 0x58F9A4: ha_initialize_handlerton(st_plugin_int*) (handler.cc:662) | ->01.38% (8,389,224B) 0x703F1E: plugin_initialize(st_plugin_int*) (sql_plugin.cc:1137) | ->01.38% (8,389,224B) 0x70496B: plugin_init(int*, char**, int) (sql_plugin.cc:1431) | ->01.38% (8,389,224B) 0x58621E: init_server_components() (mysqld.cc:4866) | ->01.38% (8,389,224B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | ->01.38% (8,389,224B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->03.41% (20,751,458B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->02.21% (13,429,120B) 0x981886: os_event_create() (os0sync.cc:370) | | ->02.21% (13,429,120B) in 23 places, all below massif's threshold (01.00%) | | | ->01.20% (7,322,338B) in 30 places, all below massif's threshold (01.00%) | ->00.35% (2,123,496B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 40 35,864,498,840 672,301,824 668,555,081 3,746,743 0 99.44% (668,555,081B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->63.00% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->41.29% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->41.29% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->41.29% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->41.29% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->05.64% (37,950,400B) in 35 places, all below massif's threshold (01.00%) | | | ->05.52% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->05.52% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->05.52% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->05.52% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->03.05% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->03.05% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->03.05% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->03.05% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.85% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->01.85% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.85% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.85% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.52% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->01.52% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.52% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.52% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.52% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->01.52% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.52% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.52% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.38% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | | ->01.38% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | | | ->01.22% (8,232,960B) 0xAD9CC8: init_instruments(PFS_global_param const*) (pfs_instr.cc:389) | ->01.22% (8,232,960B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | ->01.22% (8,232,960B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | ->01.22% (8,232,960B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->23.82% (160,172,903B) 0x90BA00: my_malloc (my_malloc.c:38) | ->18.20% (122,353,456B) 0x90804C: alloc_root (my_alloc.c:224) | | ->08.58% (57,707,520B) 0x67C4AE: sp_head::reset_lex(THD*) (sql_lex.h:2868) | | | ->07.51% (50,494,080B) 0x7BA052: MYSQLparse(THD*) (sql_yacc.yy:3800) | | | | ->07.51% (50,494,080B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->07.51% (50,494,080B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->07.51% (50,494,080B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->07.51% (50,494,080B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->07.51% (50,494,080B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->07.51% (50,494,080B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->07.51% (50,494,080B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->07.51% (50,494,080B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->07.51% (50,494,080B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->07.51% (50,494,080B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->07.51% (50,494,080B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->07.51% (50,494,080B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->07.51% (50,494,080B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->07.51% (50,494,080B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->07.51% (50,494,080B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.07% (7,213,440B) 0x7AF471: MYSQLparse(THD*) (sql_yacc.yy:817) | | | ->01.07% (7,213,440B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.07% (7,213,440B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.07% (7,213,440B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.07% (7,213,440B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.07% (7,213,440B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.07% (7,213,440B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.07% (7,213,440B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.07% (7,213,440B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.07% (7,213,440B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.07% (7,213,440B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.07% (7,213,440B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.07% (7,213,440B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.07% (7,213,440B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.07% (7,213,440B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.07% (7,213,440B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.15% (14,426,880B) 0x6F12A7: st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List*, List*, st_mysql_lex_string*) (sql_class.h:752) | | | ->02.15% (14,426,880B) 0x7B4B71: MYSQLparse(THD*) (sql_yacc.yy:11918) | | | ->02.15% (14,426,880B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->02.15% (14,426,880B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->02.15% (14,426,880B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->02.15% (14,426,880B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->02.15% (14,426,880B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->02.15% (14,426,880B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->02.15% (14,426,880B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->02.15% (14,426,880B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->02.15% (14,426,880B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->02.15% (14,426,880B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->02.15% (14,426,880B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->02.15% (14,426,880B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->02.15% (14,426,880B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->02.15% (14,426,880B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->02.15% (14,426,880B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.15% (14,426,880B) 0x7C2267: MYSQLparse(THD*) (item.h:661) | | | ->02.15% (14,426,880B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->02.15% (14,426,880B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->02.15% (14,426,880B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->02.15% (14,426,880B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->02.15% (14,426,880B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->02.15% (14,426,880B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->02.15% (14,426,880B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->02.15% (14,426,880B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->02.15% (14,426,880B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->02.15% (14,426,880B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->02.15% (14,426,880B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->02.15% (14,426,880B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->02.15% (14,426,880B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->02.15% (14,426,880B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->02.15% (14,426,880B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.15% (14,426,880B) 0x7C1CD0: MYSQLparse(THD*) (item.h:661) | | | ->02.15% (14,426,880B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->02.15% (14,426,880B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->02.15% (14,426,880B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->02.15% (14,426,880B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->02.15% (14,426,880B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->02.15% (14,426,880B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->02.15% (14,426,880B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->02.15% (14,426,880B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->02.15% (14,426,880B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->02.15% (14,426,880B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->02.15% (14,426,880B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->02.15% (14,426,880B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->02.15% (14,426,880B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->02.15% (14,426,880B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->02.15% (14,426,880B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.10% (14,151,856B) in 46 places, all below massif's threshold (01.00%) | | | | | ->01.07% (7,213,440B) 0x6E5543: Lex_input_stream::body_utf8_start(THD*, char const*) (sql_class.h:748) | | ->01.07% (7,213,440B) 0x7AD943: MYSQLparse(THD*) (sql_yacc.yy:16241) | | ->01.07% (7,213,440B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | ->01.07% (7,213,440B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | ->01.07% (7,213,440B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | ->01.07% (7,213,440B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | ->01.07% (7,213,440B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | ->01.07% (7,213,440B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | ->01.07% (7,213,440B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | ->01.07% (7,213,440B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | ->01.07% (7,213,440B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | ->01.07% (7,213,440B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | ->01.07% (7,213,440B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | ->01.07% (7,213,440B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | ->01.07% (7,213,440B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | ->01.07% (7,213,440B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | ->01.07% (7,213,440B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->02.41% (16,206,512B) 0x8F9994: init_dynamic_array2 (array.c:70) | | ->02.17% (14,608,512B) 0x8FB5B2: _my_hash_init (hash.c:111) | | | ->01.08% (7,227,584B) 0x67EA54: sp_head::sp_head(enum_sp_type) (sp_head.cc:264) | | | | ->01.08% (7,227,584B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.08% (7,227,584B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.08% (7,227,584B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.08% (7,227,584B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.08% (7,227,584B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.08% (7,227,584B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.08% (7,227,584B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.08% (7,227,584B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.08% (7,227,584B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.08% (7,227,584B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.08% (7,227,584B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.08% (7,227,584B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.08% (7,227,584B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.08% (7,227,584B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.08% (7,227,584B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.08% (7,227,584B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.08% (7,227,584B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.08% (7,227,584B) 0x67EA92: sp_head::sp_head(enum_sp_type) (sp_head.cc:265) | | | | ->01.08% (7,227,584B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.08% (7,227,584B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.08% (7,227,584B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.08% (7,227,584B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.08% (7,227,584B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.08% (7,227,584B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.08% (7,227,584B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.08% (7,227,584B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.08% (7,227,584B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.08% (7,227,584B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.08% (7,227,584B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.08% (7,227,584B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.08% (7,227,584B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.08% (7,227,584B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.08% (7,227,584B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.08% (7,227,584B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.08% (7,227,584B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.02% (153,344B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.24% (1,598,000B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->01.11% (7,494,055B) in 50 places, all below massif's threshold (01.00%) | | | ->01.08% (7,260,128B) 0x9084CD: init_alloc_root (my_alloc.c:62) | | ->01.08% (7,255,872B) 0x792D63: init_sql_alloc(st_mem_root*, unsigned int, unsigned int) (thr_malloc.cc:33) | | | ->01.08% (7,255,872B) 0x67A472: sp_head::operator new(unsigned long) (sp_head.cc:196) | | | | ->01.08% (7,255,872B) 0x67632F: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.08% (7,255,872B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.08% (7,255,872B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.08% (7,255,872B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.08% (7,255,872B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.08% (7,255,872B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.08% (7,255,872B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.08% (7,255,872B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.08% (7,255,872B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.08% (7,255,872B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.08% (7,255,872B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.08% (7,255,872B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.08% (7,255,872B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.08% (7,255,872B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.08% (7,255,872B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.08% (7,255,872B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.08% (7,255,872B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (4,256B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->01.02% (6,858,752B) 0x915F67: my_large_malloc (my_largepage.c:64) | ->01.02% (6,858,752B) 0x900BBF: init_key_cache (mf_keycache.c:430) | ->01.02% (6,858,752B) 0x595DE6: ha_init_key_cache (handler.cc:5125) | ->01.02% (6,858,752B) 0x65F442: process_key_caches(int (*)(char const*, st_key_cache*)) (keycaches.cc:128) | ->01.02% (6,858,752B) 0x5861BB: init_server_components() (mysqld.cc:4851) | ->01.02% (6,858,752B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | ->01.02% (6,858,752B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->09.21% (61,934,736B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->09.21% (61,934,736B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->05.21% (35,041,224B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | | ->01.82% (12,257,136B) 0xA7051C: dict_mem_table_create(char const*, unsigned long, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->01.38% (9,254,664B) 0xA65E1D: dict_load_table_low(char const*, unsigned char const*, dict_table_t**) (dict0load.cc:2178) | | | | ->01.38% (9,254,664B) 0xA692EA: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2346) | | | | ->01.38% (9,247,320B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | ->01.38% (9,247,320B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | ->01.38% (9,247,320B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | ->01.38% (9,247,320B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | ->01.38% (9,247,320B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | ->01.38% (9,246,096B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | ->01.30% (8,723,448B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | ->01.30% (8,723,448B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | ->01.30% (8,723,448B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | ->01.30% (8,723,448B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | ->01.30% (8,723,448B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | ->01.30% (8,723,448B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | ->01.30% (8,723,448B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | ->01.30% (8,723,448B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | ->01.30% (8,723,448B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | ->01.30% (8,723,448B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | ->01.30% (8,723,448B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | ->01.30% (8,723,448B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | ->00.08% (522,648B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (1,224B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.00% (7,344B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.45% (3,002,472B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.70% (11,453,728B) 0xA70988: dict_mem_index_create(char const*, char const*, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->01.70% (11,453,728B) 0xA5DF59: dict_index_add_to_cache(dict_table_t*, dict_index_t*, unsigned long, unsigned long) (dict0dict.cc:2988) | | | | ->01.29% (8,649,784B) 0xA68CD8: dict_load_indexes(dict_table_t*, mem_block_info_t*, dict_err_ignore_t) (dict0load.cc:2010) | | | | | ->01.29% (8,649,784B) 0xA69BB5: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2443) | | | | | ->01.29% (8,642,920B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | | ->01.29% (8,642,920B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | | ->01.29% (8,642,920B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | | ->01.29% (8,642,920B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | | ->01.29% (8,642,920B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | | ->01.29% (8,641,776B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | | ->01.21% (8,153,288B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | | ->01.21% (8,153,288B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | | ->01.21% (8,153,288B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | | ->01.21% (8,153,288B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | | ->01.21% (8,153,288B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | | ->01.21% (8,153,288B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | | ->01.21% (8,153,288B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | | ->01.21% (8,153,288B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | | ->01.21% (8,153,288B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | | ->01.21% (8,153,288B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | | ->01.21% (8,153,288B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | | ->01.21% (8,153,288B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | | | ->00.07% (488,488B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | | | ->00.00% (1,144B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (6,864B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.42% (2,803,944B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.69% (11,330,360B) in 25 places, all below massif's threshold (01.00%) | | | ->02.75% (18,504,288B) in 106 places, all below massif's threshold (01.00%) | | | ->01.25% (8,389,224B) 0x96E14D: log_init() (mem0mem.ic:449) | ->01.25% (8,389,224B) 0x9E93CD: innobase_start_or_create_for_mysql() (srv0start.cc:2005) | ->01.25% (8,389,224B) 0x930A04: innobase_init(void*) (ha_innodb.cc:3418) | ->01.25% (8,389,224B) 0x58F9A4: ha_initialize_handlerton(st_plugin_int*) (handler.cc:662) | ->01.25% (8,389,224B) 0x703F1E: plugin_initialize(st_plugin_int*) (sql_plugin.cc:1137) | ->01.25% (8,389,224B) 0x70496B: plugin_init(int*, char**, int) (sql_plugin.cc:1431) | ->01.25% (8,389,224B) 0x58621E: init_server_components() (mysqld.cc:4866) | ->01.25% (8,389,224B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | ->01.25% (8,389,224B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->03.09% (20,751,458B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->02.00% (13,429,120B) 0x981886: os_event_create() (os0sync.cc:370) | | ->02.00% (13,429,120B) in 23 places, all below massif's threshold (01.00%) | | | ->01.09% (7,322,338B) in 30 places, all below massif's threshold (01.00%) | ->00.32% (2,132,400B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 41 36,678,515,429 750,702,016 746,729,101 3,972,915 0 99.47% (746,729,101B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->56.42% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->36.98% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->36.98% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->36.98% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->36.98% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->05.06% (37,950,400B) in 35 places, all below massif's threshold (01.00%) | | | ->04.94% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->04.94% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->04.94% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->04.94% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.73% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->02.73% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.73% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.73% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.66% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->01.66% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.66% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.66% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.36% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->01.36% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.36% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.36% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.36% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->01.36% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.36% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.36% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.24% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | | ->01.24% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | | | ->01.10% (8,232,960B) 0xAD9CC8: init_instruments(PFS_global_param const*) (pfs_instr.cc:389) | ->01.10% (8,232,960B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | ->01.10% (8,232,960B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | ->01.10% (8,232,960B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->31.37% (235,529,491B) 0x90BA00: my_malloc (my_malloc.c:38) | ->24.59% (184,622,792B) 0x90804C: alloc_root (my_alloc.c:224) | | ->11.63% (87,279,360B) 0x67C4AE: sp_head::reset_lex(THD*) (sql_lex.h:2868) | | | ->10.17% (76,369,440B) 0x7BA052: MYSQLparse(THD*) (sql_yacc.yy:3800) | | | | ->10.17% (76,369,440B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->10.17% (76,369,440B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->10.17% (76,369,440B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->10.17% (76,369,440B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->10.17% (76,369,440B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->10.17% (76,369,440B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->10.17% (76,369,440B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->10.17% (76,369,440B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->10.17% (76,369,440B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->10.17% (76,369,440B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->10.17% (76,369,440B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->10.17% (76,369,440B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->10.17% (76,369,440B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->10.17% (76,369,440B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->10.17% (76,369,440B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.45% (10,909,920B) 0x7AF471: MYSQLparse(THD*) (sql_yacc.yy:817) | | | ->01.45% (10,909,920B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.45% (10,909,920B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.45% (10,909,920B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.45% (10,909,920B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.45% (10,909,920B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.45% (10,909,920B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.45% (10,909,920B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.45% (10,909,920B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.45% (10,909,920B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.45% (10,909,920B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.45% (10,909,920B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.45% (10,909,920B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.45% (10,909,920B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.45% (10,909,920B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.45% (10,909,920B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.91% (21,819,840B) 0x6F12A7: st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List*, List*, st_mysql_lex_string*) (sql_class.h:752) | | | ->02.91% (21,819,840B) 0x7B4B71: MYSQLparse(THD*) (sql_yacc.yy:11918) | | | ->02.91% (21,819,840B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->02.91% (21,819,840B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->02.91% (21,819,840B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->02.91% (21,819,840B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->02.91% (21,819,840B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->02.91% (21,819,840B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->02.91% (21,819,840B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->02.91% (21,819,840B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->02.91% (21,819,840B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->02.91% (21,819,840B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->02.91% (21,819,840B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->02.91% (21,819,840B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->02.91% (21,819,840B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->02.91% (21,819,840B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->02.91% (21,819,840B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.91% (21,819,840B) 0x7C2267: MYSQLparse(THD*) (item.h:661) | | | ->02.91% (21,819,840B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->02.91% (21,819,840B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->02.91% (21,819,840B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->02.91% (21,819,840B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->02.91% (21,819,840B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->02.91% (21,819,840B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->02.91% (21,819,840B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->02.91% (21,819,840B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->02.91% (21,819,840B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->02.91% (21,819,840B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->02.91% (21,819,840B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->02.91% (21,819,840B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->02.91% (21,819,840B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->02.91% (21,819,840B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->02.91% (21,819,840B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.91% (21,819,840B) 0x7C1CD0: MYSQLparse(THD*) (item.h:661) | | | ->02.91% (21,819,840B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->02.91% (21,819,840B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->02.91% (21,819,840B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->02.91% (21,819,840B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->02.91% (21,819,840B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->02.91% (21,819,840B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->02.91% (21,819,840B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->02.91% (21,819,840B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->02.91% (21,819,840B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->02.91% (21,819,840B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->02.91% (21,819,840B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->02.91% (21,819,840B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->02.91% (21,819,840B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->02.91% (21,819,840B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->02.91% (21,819,840B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->02.79% (20,973,992B) in 46 places, all below massif's threshold (01.00%) | | | | | ->01.45% (10,909,920B) 0x6E5543: Lex_input_stream::body_utf8_start(THD*, char const*) (sql_class.h:748) | | ->01.45% (10,909,920B) 0x7AD943: MYSQLparse(THD*) (sql_yacc.yy:16241) | | ->01.45% (10,909,920B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | ->01.45% (10,909,920B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | ->01.45% (10,909,920B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | ->01.45% (10,909,920B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | ->01.45% (10,909,920B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | ->01.45% (10,909,920B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | ->01.45% (10,909,920B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | ->01.45% (10,909,920B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | ->01.45% (10,909,920B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | ->01.45% (10,909,920B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | ->01.45% (10,909,920B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | ->01.45% (10,909,920B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | ->01.45% (10,909,920B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | ->01.45% (10,909,920B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | ->01.45% (10,909,920B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->03.25% (24,403,344B) 0x8F9994: init_dynamic_array2 (array.c:70) | | ->02.93% (21,993,568B) 0x8FB5B2: _my_hash_init (hash.c:111) | | | ->01.46% (10,931,312B) 0x67EA54: sp_head::sp_head(enum_sp_type) (sp_head.cc:264) | | | | ->01.46% (10,931,312B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.46% (10,931,312B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.46% (10,931,312B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.46% (10,931,312B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.46% (10,931,312B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.46% (10,931,312B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.46% (10,931,312B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.46% (10,931,312B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.46% (10,931,312B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.46% (10,931,312B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.46% (10,931,312B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.46% (10,931,312B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.46% (10,931,312B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.46% (10,931,312B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.46% (10,931,312B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.46% (10,931,312B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.46% (10,931,312B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.46% (10,931,312B) 0x67EA92: sp_head::sp_head(enum_sp_type) (sp_head.cc:265) | | | | ->01.46% (10,931,312B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.46% (10,931,312B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.46% (10,931,312B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.46% (10,931,312B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.46% (10,931,312B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.46% (10,931,312B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.46% (10,931,312B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.46% (10,931,312B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.46% (10,931,312B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.46% (10,931,312B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.46% (10,931,312B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.46% (10,931,312B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.46% (10,931,312B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.46% (10,931,312B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.46% (10,931,312B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.46% (10,931,312B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.46% (10,931,312B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.02% (130,944B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.32% (2,409,776B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->02.07% (15,525,003B) in 51 places, all below massif's threshold (01.00%) | | | ->01.46% (10,978,352B) 0x9084CD: init_alloc_root (my_alloc.c:62) | ->01.46% (10,974,096B) 0x792D63: init_sql_alloc(st_mem_root*, unsigned int, unsigned int) (thr_malloc.cc:33) | | ->01.46% (10,974,096B) 0x67A472: sp_head::operator new(unsigned long) (sp_head.cc:196) | | | ->01.46% (10,974,096B) 0x67632F: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | ->01.46% (10,974,096B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | ->01.46% (10,974,096B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.46% (10,974,096B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.46% (10,974,096B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.46% (10,974,096B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.46% (10,974,096B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.46% (10,974,096B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.46% (10,974,096B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.46% (10,974,096B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.46% (10,974,096B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.46% (10,974,096B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.46% (10,974,096B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.46% (10,974,096B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.46% (10,974,096B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.46% (10,974,096B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.46% (10,974,096B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.00% (4,256B) in 1+ places, all below ms_print's threshold (01.00%) | ->08.62% (64,710,720B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->08.62% (64,710,720B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->04.70% (35,298,528B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | | ->01.63% (12,257,136B) 0xA7051C: dict_mem_table_create(char const*, unsigned long, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->01.23% (9,254,664B) 0xA65E1D: dict_load_table_low(char const*, unsigned char const*, dict_table_t**) (dict0load.cc:2178) | | | | ->01.23% (9,254,664B) 0xA692EA: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2346) | | | | ->01.23% (9,247,320B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | ->01.23% (9,247,320B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | ->01.23% (9,247,320B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | ->01.23% (9,247,320B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | ->01.23% (9,247,320B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | ->01.23% (9,246,096B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | ->01.16% (8,723,448B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | ->01.16% (8,723,448B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | ->01.16% (8,723,448B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | ->01.16% (8,723,448B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | ->01.16% (8,723,448B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | ->01.16% (8,723,448B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | ->01.16% (8,723,448B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | ->01.16% (8,723,448B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | ->01.16% (8,723,448B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | ->01.16% (8,723,448B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | ->01.16% (8,723,448B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | ->01.16% (8,723,448B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | ->00.07% (522,648B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (1,224B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.00% (7,344B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.40% (3,002,472B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.54% (11,587,664B) in 25 places, all below massif's threshold (01.00%) | | | | | ->01.53% (11,453,728B) 0xA70988: dict_mem_index_create(char const*, char const*, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | ->01.53% (11,453,728B) 0xA5DF59: dict_index_add_to_cache(dict_table_t*, dict_index_t*, unsigned long, unsigned long) (dict0dict.cc:2988) | | | ->01.15% (8,649,784B) 0xA68CD8: dict_load_indexes(dict_table_t*, mem_block_info_t*, dict_err_ignore_t) (dict0load.cc:2010) | | | | ->01.15% (8,649,784B) 0xA69BB5: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2443) | | | | ->01.15% (8,642,920B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | ->01.15% (8,642,920B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | ->01.15% (8,642,920B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | ->01.15% (8,642,920B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | ->01.15% (8,642,920B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | ->01.15% (8,641,776B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | ->01.09% (8,153,288B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | ->01.09% (8,153,288B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | ->01.09% (8,153,288B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | ->01.09% (8,153,288B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | ->01.09% (8,153,288B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | ->01.09% (8,153,288B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | ->01.09% (8,153,288B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | ->01.09% (8,153,288B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | ->01.09% (8,153,288B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | ->01.09% (8,153,288B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | ->01.09% (8,153,288B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | ->01.09% (8,153,288B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | ->00.07% (488,488B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (1,144B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.00% (6,864B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.37% (2,803,944B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->02.80% (21,022,968B) in 106 places, all below massif's threshold (01.00%) | | | ->01.12% (8,389,224B) 0x96E14D: log_init() (mem0mem.ic:449) | ->01.12% (8,389,224B) 0x9E93CD: innobase_start_or_create_for_mysql() (srv0start.cc:2005) | ->01.12% (8,389,224B) 0x930A04: innobase_init(void*) (ha_innodb.cc:3418) | ->01.12% (8,389,224B) 0x58F9A4: ha_initialize_handlerton(st_plugin_int*) (handler.cc:662) | ->01.12% (8,389,224B) 0x703F1E: plugin_initialize(st_plugin_int*) (sql_plugin.cc:1137) | ->01.12% (8,389,224B) 0x70496B: plugin_init(int*, char**, int) (sql_plugin.cc:1431) | ->01.12% (8,389,224B) 0x58621E: init_server_components() (mysqld.cc:4866) | ->01.12% (8,389,224B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | ->01.12% (8,389,224B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->02.76% (20,751,458B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->01.79% (13,429,120B) 0x981886: os_event_create() (os0sync.cc:370) | | ->01.79% (13,429,120B) in 23 places, all below massif's threshold (01.00%) | | | ->00.98% (7,322,338B) in 1+ places, all below ms_print's threshold (01.00%) | ->00.29% (2,173,848B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 42 37,946,232,859 863,612,320 859,327,093 4,285,227 0 99.50% (859,327,093B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->49.05% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->32.14% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->32.14% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->32.14% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->32.14% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->05.35% (46,183,360B) in 36 places, all below massif's threshold (01.00%) | | | ->04.30% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->04.30% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->04.30% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->04.30% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.37% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->02.37% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.37% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.37% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.44% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->01.44% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.44% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.44% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.19% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->01.19% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.19% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.19% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.19% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->01.19% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.19% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.19% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.07% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | ->01.07% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | ->39.84% (344,035,803B) 0x90BA00: my_malloc (my_malloc.c:38) | ->31.77% (274,343,112B) 0x90804C: alloc_root (my_alloc.c:224) | | ->15.07% (130,168,320B) 0x67C4AE: sp_head::reset_lex(THD*) (sql_lex.h:2868) | | | ->13.19% (113,897,280B) 0x7BA052: MYSQLparse(THD*) (sql_yacc.yy:3800) | | | | ->13.19% (113,897,280B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->13.19% (113,897,280B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->13.19% (113,897,280B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->13.19% (113,897,280B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->13.19% (113,897,280B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->13.19% (113,897,280B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->13.19% (113,897,280B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->13.19% (113,897,280B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->13.19% (113,897,280B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->13.19% (113,897,280B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->13.19% (113,897,280B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->13.19% (113,897,280B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->13.19% (113,897,280B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->13.19% (113,897,280B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->13.19% (113,897,280B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.88% (16,271,040B) 0x7AF471: MYSQLparse(THD*) (sql_yacc.yy:817) | | | ->01.88% (16,271,040B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.88% (16,271,040B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.88% (16,271,040B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.88% (16,271,040B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.88% (16,271,040B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.88% (16,271,040B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.88% (16,271,040B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.88% (16,271,040B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.88% (16,271,040B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.88% (16,271,040B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.88% (16,271,040B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.88% (16,271,040B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.88% (16,271,040B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.88% (16,271,040B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.88% (16,271,040B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.77% (32,542,080B) 0x6F12A7: st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List*, List*, st_mysql_lex_string*) (sql_class.h:752) | | | ->03.77% (32,542,080B) 0x7B4B71: MYSQLparse(THD*) (sql_yacc.yy:11918) | | | ->03.77% (32,542,080B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.77% (32,542,080B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.77% (32,542,080B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.77% (32,542,080B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.77% (32,542,080B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.77% (32,542,080B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.77% (32,542,080B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.77% (32,542,080B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.77% (32,542,080B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.77% (32,542,080B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.77% (32,542,080B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.77% (32,542,080B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.77% (32,542,080B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.77% (32,542,080B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.77% (32,542,080B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.77% (32,542,080B) 0x7C2267: MYSQLparse(THD*) (item.h:661) | | | ->03.77% (32,542,080B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.77% (32,542,080B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.77% (32,542,080B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.77% (32,542,080B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.77% (32,542,080B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.77% (32,542,080B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.77% (32,542,080B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.77% (32,542,080B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.77% (32,542,080B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.77% (32,542,080B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.77% (32,542,080B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.77% (32,542,080B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.77% (32,542,080B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.77% (32,542,080B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.77% (32,542,080B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.77% (32,542,080B) 0x7C1CD0: MYSQLparse(THD*) (item.h:661) | | | ->03.77% (32,542,080B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.77% (32,542,080B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.77% (32,542,080B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.77% (32,542,080B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.77% (32,542,080B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.77% (32,542,080B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.77% (32,542,080B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.77% (32,542,080B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.77% (32,542,080B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.77% (32,542,080B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.77% (32,542,080B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.77% (32,542,080B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.77% (32,542,080B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.77% (32,542,080B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.77% (32,542,080B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.51% (30,277,512B) in 46 places, all below massif's threshold (01.00%) | | | | | ->01.88% (16,271,040B) 0x6E5543: Lex_input_stream::body_utf8_start(THD*, char const*) (sql_class.h:748) | | ->01.88% (16,271,040B) 0x7AD943: MYSQLparse(THD*) (sql_yacc.yy:16241) | | ->01.88% (16,271,040B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | ->01.88% (16,271,040B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | ->01.88% (16,271,040B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | ->01.88% (16,271,040B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | ->01.88% (16,271,040B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | ->01.88% (16,271,040B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | ->01.88% (16,271,040B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | ->01.88% (16,271,040B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | ->01.88% (16,271,040B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | ->01.88% (16,271,040B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | ->01.88% (16,271,040B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | ->01.88% (16,271,040B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | ->01.88% (16,271,040B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | ->01.88% (16,271,040B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | ->01.88% (16,271,040B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->04.20% (36,287,888B) 0x8F9994: init_dynamic_array2 (array.c:70) | | ->03.79% (32,700,512B) 0x8FB5B2: _my_hash_init (hash.c:111) | | | ->01.89% (16,302,944B) 0x67EA54: sp_head::sp_head(enum_sp_type) (sp_head.cc:264) | | | | ->01.89% (16,302,944B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.89% (16,302,944B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.89% (16,302,944B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.89% (16,302,944B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.89% (16,302,944B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.89% (16,302,944B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.89% (16,302,944B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.89% (16,302,944B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.89% (16,302,944B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.89% (16,302,944B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.89% (16,302,944B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.89% (16,302,944B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.89% (16,302,944B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.89% (16,302,944B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.89% (16,302,944B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.89% (16,302,944B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.89% (16,302,944B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.89% (16,302,944B) 0x67EA92: sp_head::sp_head(enum_sp_type) (sp_head.cc:265) | | | | ->01.89% (16,302,944B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.89% (16,302,944B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.89% (16,302,944B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.89% (16,302,944B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.89% (16,302,944B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.89% (16,302,944B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.89% (16,302,944B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.89% (16,302,944B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.89% (16,302,944B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.89% (16,302,944B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.89% (16,302,944B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.89% (16,302,944B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.89% (16,302,944B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.89% (16,302,944B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.89% (16,302,944B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.89% (16,302,944B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.89% (16,302,944B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.01% (94,624B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.42% (3,587,376B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->01.97% (17,033,795B) in 51 places, all below massif's threshold (01.00%) | | | ->01.90% (16,371,008B) 0x9084CD: init_alloc_root (my_alloc.c:62) | ->01.90% (16,366,752B) 0x792D63: init_sql_alloc(st_mem_root*, unsigned int, unsigned int) (thr_malloc.cc:33) | | ->01.90% (16,366,752B) 0x67A472: sp_head::operator new(unsigned long) (sp_head.cc:196) | | | ->01.90% (16,366,752B) 0x67632F: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | ->01.90% (16,366,752B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | ->01.90% (16,366,752B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.90% (16,366,752B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.90% (16,366,752B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.90% (16,366,752B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.90% (16,366,752B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.90% (16,366,752B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.90% (16,366,752B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.90% (16,366,752B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.90% (16,366,752B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.90% (16,366,752B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.90% (16,366,752B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.90% (16,366,752B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.90% (16,366,752B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.90% (16,366,752B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.90% (16,366,752B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.00% (4,256B) in 1+ places, all below ms_print's threshold (01.00%) | ->07.96% (68,739,600B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->07.96% (68,739,600B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->04.13% (35,671,704B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | | ->01.42% (12,257,136B) 0xA7051C: dict_mem_table_create(char const*, unsigned long, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | | ->01.07% (9,254,664B) 0xA65E1D: dict_load_table_low(char const*, unsigned char const*, dict_table_t**) (dict0load.cc:2178) | | | | ->01.07% (9,254,664B) 0xA692EA: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2346) | | | | ->01.07% (9,247,320B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | ->01.07% (9,247,320B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | ->01.07% (9,247,320B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | ->01.07% (9,247,320B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | ->01.07% (9,247,320B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | ->01.07% (9,246,096B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | ->01.01% (8,723,448B) 0x6B074C: open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) (sql_base.cc:5808) | | | | | | | ->01.01% (8,723,448B) 0x6B080B: open_n_lock_single_table(THD*, TABLE_LIST*, thr_lock_type, unsigned int, Prelocking_strategy*) (sql_base.cc:5660) | | | | | | | ->01.01% (8,723,448B) 0x757382: mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) (sql_base.h:461) | | | | | | | ->01.01% (8,723,448B) 0x6F8DDF: mysql_execute_command(THD*) (sql_parse.cc:4840) | | | | | | | ->01.01% (8,723,448B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | | | ->01.01% (8,723,448B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | | | ->01.01% (8,723,448B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | | | ->01.01% (8,723,448B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | | | ->01.01% (8,723,448B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | | | ->01.01% (8,723,448B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | | | ->01.01% (8,723,448B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | | | ->01.01% (8,723,448B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | | | | | ->00.06% (522,648B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | | | ->00.00% (1,224B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.00% (7,344B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.35% (3,002,472B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->01.38% (11,960,840B) in 25 places, all below massif's threshold (01.00%) | | | | | ->01.33% (11,453,728B) 0xA70988: dict_mem_index_create(char const*, char const*, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | ->01.33% (11,453,728B) 0xA5DF59: dict_index_add_to_cache(dict_table_t*, dict_index_t*, unsigned long, unsigned long) (dict0dict.cc:2988) | | | ->01.00% (8,649,784B) 0xA68CD8: dict_load_indexes(dict_table_t*, mem_block_info_t*, dict_err_ignore_t) (dict0load.cc:2010) | | | | ->01.00% (8,649,784B) 0xA69BB5: dict_load_table(char const*, unsigned long, dict_err_ignore_t) (dict0load.cc:2443) | | | | ->01.00% (8,642,920B) 0xA649B0: dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t) (dict0dict.cc:1131) | | | | | ->01.00% (8,642,920B) 0x93D520: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:4882) | | | | | ->01.00% (8,642,920B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | | | | | ->01.00% (8,642,920B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | | | | | ->01.00% (8,642,920B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | | | | | ->01.00% (8,641,776B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | | ->01.00% (8,641,776B) in 2 places, all below massif's threshold (01.00%) | | | | | | | | | | | ->00.00% (1,144B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | | | ->00.00% (6,864B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.32% (2,803,944B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->03.83% (33,067,896B) in 108 places, all below massif's threshold (01.00%) | ->02.40% (20,751,458B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->01.55% (13,429,120B) 0x981886: os_event_create() (os0sync.cc:370) | | ->01.55% (13,429,120B) in 23 places, all below massif's threshold (01.00%) | | | ->00.85% (7,322,338B) in 1+ places, all below ms_print's threshold (01.00%) | ->00.26% (2,236,648B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 43 38,344,922,370 864,324,728 860,039,255 4,285,473 0 44 39,530,967,693 864,335,208 860,050,619 4,284,589 0 45 40,716,861,495 864,471,232 860,199,651 4,271,581 0 46 41,507,492,562 864,404,736 860,134,435 4,270,301 0 47 42,298,045,785 864,344,672 860,071,159 4,273,513 0 48 43,098,936,476 864,348,928 860,076,355 4,272,573 0 49 43,889,488,282 840,151,640 836,735,615 3,416,025 0 50 44,288,177,911 841,164,400 837,703,622 3,460,778 0 51 44,686,938,058 842,292,568 838,797,771 3,494,797 0 52 45,085,628,031 843,134,640 839,610,729 3,523,911 0 53 45,498,737,810 844,044,520 840,490,121 3,554,399 0 54 45,897,434,645 845,076,160 841,486,499 3,589,661 0 99.58% (841,486,499B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->50.12% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->32.85% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->32.85% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->32.85% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->32.85% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->05.46% (46,183,360B) in 36 places, all below massif's threshold (01.00%) | | | ->04.39% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->04.39% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->04.39% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->04.39% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.42% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->02.42% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.42% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.42% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.47% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->01.47% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.47% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.47% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.21% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->01.21% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.21% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.21% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.21% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->01.21% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.21% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.21% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.10% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | ->01.10% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | ->40.80% (344,750,773B) 0x90BA00: my_malloc (my_malloc.c:38) | ->32.54% (274,955,432B) 0x90804C: alloc_root (my_alloc.c:224) | | ->15.44% (130,494,720B) 0x67C4AE: sp_head::reset_lex(THD*) (sql_lex.h:2868) | | | ->13.51% (114,182,880B) 0x7BA052: MYSQLparse(THD*) (sql_yacc.yy:3800) | | | | ->13.51% (114,182,880B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->13.51% (114,182,880B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->13.51% (114,182,880B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->13.51% (114,182,880B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->13.51% (114,182,880B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->13.51% (114,182,880B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->13.51% (114,182,880B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->13.51% (114,182,880B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->13.51% (114,182,880B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->13.51% (114,182,880B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->13.51% (114,182,880B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->13.51% (114,182,880B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->13.51% (114,182,880B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->13.51% (114,182,880B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->13.51% (114,182,880B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.93% (16,311,840B) 0x7AF471: MYSQLparse(THD*) (sql_yacc.yy:817) | | | ->01.93% (16,311,840B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.93% (16,311,840B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.93% (16,311,840B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.93% (16,311,840B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.93% (16,311,840B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.93% (16,311,840B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.93% (16,311,840B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.93% (16,311,840B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.93% (16,311,840B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.93% (16,311,840B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.93% (16,311,840B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.93% (16,311,840B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.93% (16,311,840B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.93% (16,311,840B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.93% (16,311,840B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.86% (32,623,680B) 0x6F12A7: st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List*, List*, st_mysql_lex_string*) (sql_class.h:752) | | | ->03.86% (32,623,680B) 0x7B4B71: MYSQLparse(THD*) (sql_yacc.yy:11918) | | | ->03.86% (32,623,680B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.86% (32,623,680B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.86% (32,623,680B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.86% (32,623,680B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.86% (32,623,680B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.86% (32,623,680B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.86% (32,623,680B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.86% (32,623,680B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.86% (32,623,680B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.86% (32,623,680B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.86% (32,623,680B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.86% (32,623,680B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.86% (32,623,680B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.86% (32,623,680B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.86% (32,623,680B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.86% (32,623,680B) 0x7C2267: MYSQLparse(THD*) (item.h:661) | | | ->03.86% (32,623,680B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.86% (32,623,680B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.86% (32,623,680B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.86% (32,623,680B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.86% (32,623,680B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.86% (32,623,680B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.86% (32,623,680B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.86% (32,623,680B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.86% (32,623,680B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.86% (32,623,680B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.86% (32,623,680B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.86% (32,623,680B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.86% (32,623,680B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.86% (32,623,680B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.86% (32,623,680B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.86% (32,623,680B) 0x7C1CD0: MYSQLparse(THD*) (item.h:661) | | | ->03.86% (32,623,680B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.86% (32,623,680B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.86% (32,623,680B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.86% (32,623,680B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.86% (32,623,680B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.86% (32,623,680B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.86% (32,623,680B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.86% (32,623,680B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.86% (32,623,680B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.86% (32,623,680B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.86% (32,623,680B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.86% (32,623,680B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.86% (32,623,680B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.86% (32,623,680B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.86% (32,623,680B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.58% (30,277,832B) in 46 places, all below massif's threshold (01.00%) | | | | | ->01.93% (16,311,840B) 0x6E5543: Lex_input_stream::body_utf8_start(THD*, char const*) (sql_class.h:748) | | ->01.93% (16,311,840B) 0x7AD943: MYSQLparse(THD*) (sql_yacc.yy:16241) | | ->01.93% (16,311,840B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | ->01.93% (16,311,840B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | ->01.93% (16,311,840B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | ->01.93% (16,311,840B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | ->01.93% (16,311,840B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | ->01.93% (16,311,840B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | ->01.93% (16,311,840B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | ->01.93% (16,311,840B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | ->01.93% (16,311,840B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | ->01.93% (16,311,840B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | ->01.93% (16,311,840B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | ->01.93% (16,311,840B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | ->01.93% (16,311,840B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | ->01.93% (16,311,840B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | ->01.93% (16,311,840B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->04.30% (36,377,920B) 0x8F9994: init_dynamic_array2 (array.c:70) | | ->03.88% (32,781,584B) 0x8FB5B2: _my_hash_init (hash.c:111) | | | ->01.93% (16,343,824B) 0x67EA54: sp_head::sp_head(enum_sp_type) (sp_head.cc:264) | | | | ->01.93% (16,343,824B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.93% (16,343,824B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.93% (16,343,824B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.93% (16,343,824B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.93% (16,343,824B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.93% (16,343,824B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.93% (16,343,824B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.93% (16,343,824B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.93% (16,343,824B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.93% (16,343,824B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.93% (16,343,824B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.93% (16,343,824B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.93% (16,343,824B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.93% (16,343,824B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.93% (16,343,824B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.93% (16,343,824B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.93% (16,343,824B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.93% (16,343,824B) 0x67EA92: sp_head::sp_head(enum_sp_type) (sp_head.cc:265) | | | | ->01.93% (16,343,824B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.93% (16,343,824B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.93% (16,343,824B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.93% (16,343,824B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.93% (16,343,824B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.93% (16,343,824B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.93% (16,343,824B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.93% (16,343,824B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.93% (16,343,824B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.93% (16,343,824B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.93% (16,343,824B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.93% (16,343,824B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.93% (16,343,824B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.93% (16,343,824B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.93% (16,343,824B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.93% (16,343,824B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.93% (16,343,824B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.01% (93,936B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.43% (3,596,336B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->02.01% (17,005,373B) in 51 places, all below massif's threshold (01.00%) | | | ->01.94% (16,412,048B) 0x9084CD: init_alloc_root (my_alloc.c:62) | ->01.94% (16,407,792B) 0x792D63: init_sql_alloc(st_mem_root*, unsigned int, unsigned int) (thr_malloc.cc:33) | | ->01.94% (16,407,792B) 0x67A472: sp_head::operator new(unsigned long) (sp_head.cc:196) | | | ->01.94% (16,407,792B) 0x67632F: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | ->01.94% (16,407,792B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | ->01.94% (16,407,792B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.94% (16,407,792B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.94% (16,407,792B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.94% (16,407,792B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.94% (16,407,792B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.94% (16,407,792B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.94% (16,407,792B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.94% (16,407,792B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.94% (16,407,792B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.94% (16,407,792B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.94% (16,407,792B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.94% (16,407,792B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.94% (16,407,792B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.94% (16,407,792B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.94% (16,407,792B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.00% (4,256B) in 1+ places, all below ms_print's threshold (01.00%) | ->06.32% (53,375,088B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->06.32% (53,375,088B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->02.71% (22,908,816B) in 107 places, all below massif's threshold (01.00%) | | | ->02.60% (21,937,712B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | | ->02.60% (21,937,712B) in 27 places, all below massif's threshold (01.00%) | | | ->01.01% (8,528,560B) 0x9BE19B: row_create_prebuilt(dict_table_t*, unsigned long) (mem0mem.ic:449) | ->01.01% (8,528,560B) 0x93D8EC: ha_innobase::open(char const*, int, unsigned int) (ha_innodb.cc:5040) | ->01.01% (8,528,560B) 0x58F68C: handler::ha_open(TABLE*, char const*, int, int) (handler.cc:2505) | ->01.01% (8,528,560B) 0x78B2B6: open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) (table.cc:2343) | ->01.01% (8,528,560B) 0x6AD0FE: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3172) | ->01.01% (8,523,736B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | ->01.01% (8,523,736B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | ->01.01% (8,523,736B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | ->01.01% (8,523,736B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | ->01.01% (8,523,736B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | ->01.01% (8,523,736B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | ->01.01% (8,523,736B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | ->01.01% (8,523,736B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | ->01.01% (8,523,736B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | ->01.01% (8,523,736B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | ->01.01% (8,523,736B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | ->01.01% (8,523,736B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.00% (4,824B) in 1+ places, all below ms_print's threshold (01.00%) | ->02.15% (18,134,102B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->01.29% (10,879,360B) 0x981886: os_event_create() (os0sync.cc:370) | | ->01.29% (10,879,360B) in 23 places, all below massif's threshold (01.00%) | | | ->00.86% (7,254,742B) in 1+ places, all below ms_print's threshold (01.00%) | ->00.20% (1,662,952B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 55 46,296,129,289 845,832,200 842,216,517 3,615,683 0 56 46,694,835,624 846,835,888 843,184,967 3,650,921 0 57 47,093,531,727 847,795,096 844,110,729 3,684,367 0 58 47,492,419,350 848,786,800 845,067,334 3,719,466 0 59 47,891,112,778 849,805,016 846,049,317 3,755,699 0 60 48,289,846,243 850,781,984 846,994,011 3,787,973 0 61 48,689,271,903 851,713,136 847,889,411 3,823,725 0 62 49,087,963,915 852,706,184 848,843,684 3,862,500 0 63 49,486,653,539 853,674,072 849,775,818 3,898,254 0 64 49,885,345,531 854,679,624 850,743,491 3,936,133 0 99.54% (850,743,491B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->49.56% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->32.48% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->32.48% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->32.48% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->32.48% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->05.40% (46,183,360B) in 36 places, all below massif's threshold (01.00%) | | | ->04.34% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->04.34% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->04.34% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->04.34% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.40% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->02.40% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.40% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.40% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.45% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->01.45% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.45% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.45% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.20% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->01.20% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.20% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.20% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.20% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->01.20% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.20% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.20% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.09% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | ->01.09% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | ->40.34% (344,750,861B) 0x90BA00: my_malloc (my_malloc.c:38) | ->32.17% (274,955,432B) 0x90804C: alloc_root (my_alloc.c:224) | | ->15.27% (130,494,720B) 0x67C4AE: sp_head::reset_lex(THD*) (sql_lex.h:2868) | | | ->13.36% (114,182,880B) 0x7BA052: MYSQLparse(THD*) (sql_yacc.yy:3800) | | | | ->13.36% (114,182,880B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->13.36% (114,182,880B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->13.36% (114,182,880B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->13.36% (114,182,880B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->13.36% (114,182,880B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->13.36% (114,182,880B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->13.36% (114,182,880B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->13.36% (114,182,880B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->13.36% (114,182,880B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->13.36% (114,182,880B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->13.36% (114,182,880B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->13.36% (114,182,880B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->13.36% (114,182,880B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->13.36% (114,182,880B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->13.36% (114,182,880B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.91% (16,311,840B) 0x7AF471: MYSQLparse(THD*) (sql_yacc.yy:817) | | | ->01.91% (16,311,840B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.91% (16,311,840B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.91% (16,311,840B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.91% (16,311,840B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.91% (16,311,840B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.91% (16,311,840B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.91% (16,311,840B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.91% (16,311,840B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.91% (16,311,840B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.91% (16,311,840B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.91% (16,311,840B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.91% (16,311,840B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.91% (16,311,840B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.91% (16,311,840B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.91% (16,311,840B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.82% (32,623,680B) 0x6F12A7: st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List*, List*, st_mysql_lex_string*) (sql_class.h:752) | | | ->03.82% (32,623,680B) 0x7B4B71: MYSQLparse(THD*) (sql_yacc.yy:11918) | | | ->03.82% (32,623,680B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.82% (32,623,680B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.82% (32,623,680B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.82% (32,623,680B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.82% (32,623,680B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.82% (32,623,680B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.82% (32,623,680B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.82% (32,623,680B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.82% (32,623,680B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.82% (32,623,680B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.82% (32,623,680B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.82% (32,623,680B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.82% (32,623,680B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.82% (32,623,680B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.82% (32,623,680B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.82% (32,623,680B) 0x7C2267: MYSQLparse(THD*) (item.h:661) | | | ->03.82% (32,623,680B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.82% (32,623,680B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.82% (32,623,680B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.82% (32,623,680B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.82% (32,623,680B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.82% (32,623,680B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.82% (32,623,680B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.82% (32,623,680B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.82% (32,623,680B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.82% (32,623,680B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.82% (32,623,680B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.82% (32,623,680B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.82% (32,623,680B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.82% (32,623,680B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.82% (32,623,680B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.82% (32,623,680B) 0x7C1CD0: MYSQLparse(THD*) (item.h:661) | | | ->03.82% (32,623,680B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->03.82% (32,623,680B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->03.82% (32,623,680B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->03.82% (32,623,680B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->03.82% (32,623,680B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->03.82% (32,623,680B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->03.82% (32,623,680B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->03.82% (32,623,680B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->03.82% (32,623,680B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->03.82% (32,623,680B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->03.82% (32,623,680B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->03.82% (32,623,680B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->03.82% (32,623,680B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->03.82% (32,623,680B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->03.82% (32,623,680B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->03.54% (30,277,832B) in 46 places, all below massif's threshold (01.00%) | | | | | ->01.91% (16,311,840B) 0x6E5543: Lex_input_stream::body_utf8_start(THD*, char const*) (sql_class.h:748) | | ->01.91% (16,311,840B) 0x7AD943: MYSQLparse(THD*) (sql_yacc.yy:16241) | | ->01.91% (16,311,840B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | ->01.91% (16,311,840B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | ->01.91% (16,311,840B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | ->01.91% (16,311,840B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | ->01.91% (16,311,840B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | ->01.91% (16,311,840B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | ->01.91% (16,311,840B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | ->01.91% (16,311,840B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | ->01.91% (16,311,840B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | ->01.91% (16,311,840B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | ->01.91% (16,311,840B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | ->01.91% (16,311,840B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | ->01.91% (16,311,840B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | ->01.91% (16,311,840B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | ->01.91% (16,311,840B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->04.26% (36,377,920B) 0x8F9994: init_dynamic_array2 (array.c:70) | | ->03.84% (32,781,584B) 0x8FB5B2: _my_hash_init (hash.c:111) | | | ->01.91% (16,343,824B) 0x67EA54: sp_head::sp_head(enum_sp_type) (sp_head.cc:264) | | | | ->01.91% (16,343,824B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.91% (16,343,824B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.91% (16,343,824B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.91% (16,343,824B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.91% (16,343,824B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.91% (16,343,824B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.91% (16,343,824B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.91% (16,343,824B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.91% (16,343,824B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.91% (16,343,824B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.91% (16,343,824B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.91% (16,343,824B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.91% (16,343,824B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.91% (16,343,824B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.91% (16,343,824B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.91% (16,343,824B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.91% (16,343,824B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->01.91% (16,343,824B) 0x67EA92: sp_head::sp_head(enum_sp_type) (sp_head.cc:265) | | | | ->01.91% (16,343,824B) 0x676344: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | | ->01.91% (16,343,824B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | | ->01.91% (16,343,824B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | | ->01.91% (16,343,824B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | | ->01.91% (16,343,824B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | | ->01.91% (16,343,824B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | | ->01.91% (16,343,824B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | | ->01.91% (16,343,824B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | | ->01.91% (16,343,824B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | | ->01.91% (16,343,824B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | | ->01.91% (16,343,824B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | | ->01.91% (16,343,824B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | | ->01.91% (16,343,824B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | | ->01.91% (16,343,824B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | | ->01.91% (16,343,824B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | | ->01.91% (16,343,824B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | | ->01.91% (16,343,824B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | | | ->00.01% (93,936B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.42% (3,596,336B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->01.99% (17,005,461B) in 51 places, all below massif's threshold (01.00%) | | | ->01.92% (16,412,048B) 0x9084CD: init_alloc_root (my_alloc.c:62) | ->01.92% (16,407,792B) 0x792D63: init_sql_alloc(st_mem_root*, unsigned int, unsigned int) (thr_malloc.cc:33) | | ->01.92% (16,407,792B) 0x67A472: sp_head::operator new(unsigned long) (sp_head.cc:196) | | | ->01.92% (16,407,792B) 0x67632F: sp_start_parsing(THD*, enum_sp_type, sp_name*) (sp.cc:2311) | | | ->01.92% (16,407,792B) 0x7AD893: MYSQLparse(THD*) (sql_yacc.yy:16225) | | | ->01.92% (16,407,792B) 0x6EF7F2: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:8359) | | | ->01.92% (16,407,792B) 0x758001: Table_triggers_list::check_n_load(THD*, char const*, char const*, TABLE*, bool) (sql_trigger.cc:1416) | | | | ->01.92% (16,407,792B) 0x6AD72E: open_table(THD*, TABLE_LIST*, Open_table_context*) (sql_base.cc:3929) | | | | ->01.92% (16,407,792B) 0x6B04EA: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (sql_base.cc:4731) | | | | ->01.92% (16,407,792B) 0x6B0695: open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int) (sql_base.cc:5860) | | | | ->01.92% (16,407,792B) 0x6E0995: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:737) | | | | ->01.92% (16,407,792B) 0x6F6653: mysql_execute_command(THD*) (sql_parse.cc:3449) | | | | ->01.92% (16,407,792B) 0x6FBC46: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6385) | | | | ->01.92% (16,407,792B) 0x6FD01E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1339) | | | | ->01.92% (16,407,792B) 0x6FEE15: do_command(THD*) (sql_parse.cc:1036) | | | | ->01.92% (16,407,792B) 0x6C5FA4: do_handle_one_connection(THD*) (sql_connect.cc:982) | | | | ->01.92% (16,407,792B) 0x6C6083: handle_one_connection (sql_connect.cc:898) | | | | ->01.92% (16,407,792B) 0xAFCFE4: pfs_spawn_thread (pfs.cc:1860) | | | | ->01.92% (16,407,792B) 0x4E34DF3: start_thread (in /usr/lib64/libpthread-2.17.so) | | | | ->01.92% (16,407,792B) 0x61A360B: clone (in /usr/lib64/libc-2.17.so) | | | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | | | ->00.00% (4,256B) in 1+ places, all below ms_print's threshold (01.00%) | ->07.14% (61,042,808B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->07.14% (61,042,808B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->03.78% (32,264,264B) in 108 places, all below massif's threshold (01.00%) | | | ->03.37% (28,778,544B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | ->01.15% (9,809,136B) 0xA7051C: dict_mem_table_create(char const*, unsigned long, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | | ->01.15% (9,809,136B) in 9 places, all below massif's threshold (01.00%) | | | ->01.15% (9,803,680B) in 25 places, all below massif's threshold (01.00%) | | | ->01.07% (9,165,728B) 0xA70988: dict_mem_index_create(char const*, char const*, unsigned long, unsigned long, unsigned long) (mem0mem.ic:199) | ->01.07% (9,165,728B) 0xA5DF59: dict_index_add_to_cache(dict_table_t*, dict_index_t*, unsigned long, unsigned long) (dict0dict.cc:2988) | | ->01.07% (9,165,728B) in 7 places, all below massif's threshold (01.00%) | | | ->00.00% (0B) in 1+ places, all below ms_print's threshold (01.00%) | ->02.27% (19,437,590B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->01.42% (12,149,120B) 0x981886: os_event_create() (os0sync.cc:370) | | ->01.42% (12,149,120B) in 23 places, all below massif's threshold (01.00%) | | | ->00.85% (7,288,470B) in 1+ places, all below ms_print's threshold (01.00%) | ->00.23% (1,948,648B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 65 50,284,035,208 855,668,376 851,693,947 3,974,429 0 66 50,682,940,367 856,657,840 852,647,991 4,009,849 0 67 51,081,706,353 857,503,104 853,463,260 4,039,844 0 68 51,480,406,650 858,452,632 854,376,625 4,076,007 0 69 51,880,024,105 859,448,896 855,336,191 4,112,705 0 70 52,278,785,065 860,537,856 856,392,401 4,145,455 0 71 52,677,481,887 861,359,792 857,176,646 4,183,146 0 72 53,076,174,846 862,547,808 858,319,171 4,228,637 0 73 53,474,868,596 863,747,152 859,476,494 4,270,658 0 74 53,873,574,268 476,778,672 474,864,158 1,914,514 0 99.60% (474,864,158B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc. ->88.84% (423,563,584B) 0xAD72D8: pfs_malloc(unsigned long, int) (pfs_global.cc:57) | ->58.22% (277,600,000B) 0xADD704: init_table_share(unsigned int) (pfs_instr_class.cc:344) | | ->58.22% (277,600,000B) 0xAE0409: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->58.22% (277,600,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->58.22% (277,600,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->07.79% (37,120,000B) 0xAD9B01: init_instruments(PFS_global_param const*) (pfs_instr.cc:325) | | ->07.79% (37,120,000B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->07.79% (37,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->07.79% (37,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->04.72% (22,487,616B) in 32 places, all below massif's threshold (01.00%) | | | ->04.30% (20,480,000B) 0xAD65DE: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:63) | | ->04.30% (20,480,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->04.30% (20,480,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->04.30% (20,480,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.61% (12,426,624B) 0xAD9D23: init_instruments(PFS_global_param const*) (pfs_instr.cc:407) | | ->02.61% (12,426,624B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.61% (12,426,624B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.61% (12,426,624B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.15% (10,240,000B) 0xAD3709: init_digest(PFS_global_param const*) (pfs_digest.cc:90) | | ->02.15% (10,240,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.15% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.15% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->02.15% (10,240,000B) 0xAD6680: init_events_statements_history_long(unsigned long) (pfs_events_statements.cc:78) | | ->02.15% (10,240,000B) 0xAE0486: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->02.15% (10,240,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->02.15% (10,240,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.95% (9,273,600B) 0xAD30DA: PFS_connection_slice::alloc_statements_slice(unsigned int) (pfs_con_slice.cc:82) | | ->01.95% (9,273,600B) in 3 places, all below massif's threshold (01.00%) | | | ->01.73% (8,232,960B) 0xAD9CC8: init_instruments(PFS_global_param const*) (pfs_instr.cc:389) | | ->01.73% (8,232,960B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.73% (8,232,960B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.73% (8,232,960B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.14% (5,415,872B) 0xAD9ADD: init_instruments(PFS_global_param const*) (pfs_instr.cc:311) | | ->01.14% (5,415,872B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.14% (5,415,872B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.14% (5,415,872B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.07% (5,120,000B) 0xAD369F: init_digest(PFS_global_param const*) (pfs_digest.cc:73) | | ->01.07% (5,120,000B) 0xAE054C: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | | ->01.07% (5,120,000B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | | ->01.07% (5,120,000B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.03% (4,926,912B) 0xAD9BB0: init_instruments(PFS_global_param const*) (pfs_instr.cc:356) | ->01.03% (4,926,912B) 0xAE0452: initialize_performance_schema(PFS_global_param*) (pfs_server.cc:84) | ->01.03% (4,926,912B) 0x587251: mysqld_main(int, char**) (mysqld.cc:5269) | ->01.03% (4,926,912B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | ->04.88% (23,266,792B) 0x9782F4: mem_area_alloc(unsigned long*, mem_pool_t*) (mem0pool.cc:381) | ->04.88% (23,266,792B) 0x976A02: mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) (mem0mem.cc:336) | ->02.10% (10,003,408B) in 107 places, all below massif's threshold (01.00%) | | | ->01.76% (8,389,224B) 0x96E14D: log_init() (mem0mem.ic:449) | | ->01.76% (8,389,224B) 0x9E93CD: innobase_start_or_create_for_mysql() (srv0start.cc:2005) | | ->01.76% (8,389,224B) 0x930A04: innobase_init(void*) (ha_innodb.cc:3418) | | ->01.76% (8,389,224B) 0x58F9A4: ha_initialize_handlerton(st_plugin_int*) (handler.cc:662) | | ->01.76% (8,389,224B) 0x703F1E: plugin_initialize(st_plugin_int*) (sql_plugin.cc:1137) | | ->01.76% (8,389,224B) 0x70496B: plugin_init(int*, char**, int) (sql_plugin.cc:1431) | | ->01.76% (8,389,224B) 0x58621E: init_server_components() (mysqld.cc:4866) | | ->01.76% (8,389,224B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | | ->01.76% (8,389,224B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.02% (4,874,160B) 0x976EDD: mem_heap_add_block(mem_block_info_t*, unsigned long) (mem0mem.cc:454) | ->01.02% (4,874,160B) in 27 places, all below massif's threshold (01.00%) | ->03.17% (15,100,141B) 0xA0A291: ut_malloc_low(unsigned long, unsigned long) (ut0mem.cc:104) | ->01.66% (7,922,944B) 0x981886: os_event_create() (os0sync.cc:370) | | ->01.66% (7,922,944B) in 23 places, all below massif's threshold (01.00%) | | | ->01.51% (7,177,197B) in 30 places, all below massif's threshold (01.00%) | ->02.52% (12,009,217B) 0x90BA00: my_malloc (my_malloc.c:38) | ->01.44% (6,858,752B) 0x915F67: my_large_malloc (my_largepage.c:64) | | ->01.44% (6,858,752B) 0x900BBF: init_key_cache (mf_keycache.c:430) | | ->01.44% (6,858,752B) 0x595DE6: ha_init_key_cache (handler.cc:5125) | | ->01.44% (6,858,752B) 0x65F442: process_key_caches(int (*)(char const*, st_key_cache*)) (keycaches.cc:128) | | ->01.44% (6,858,752B) 0x5861BB: init_server_components() (mysqld.cc:4851) | | ->01.44% (6,858,752B) 0x5870B3: mysqld_main(int, char**) (mysqld.cc:5463) | | ->01.44% (6,858,752B) 0x60CEAF3: (below main) (in /usr/lib64/libc-2.17.so) | | | ->01.08% (5,150,465B) in 53 places, all below massif's threshold (01.00%) | ->00.19% (924,424B) in 1+ places, all below ms_print's threshold (01.00%) -------------------------------------------------------------------------------- n time(i) total(B) useful-heap(B) extra-heap(B) stacks(B) -------------------------------------------------------------------------------- 75 54,278,369,201 476,776,304 474,861,806 1,914,498 0