==13560== ==13560== malloc/free: in use at exit: 6,764 bytes in 18 blocks. ==13560== malloc/free: 437,950 allocs, 437,932 frees, 2,750,146,584 bytes allocated. ==13560== ==13560== searching for pointers to 18 not-freed blocks. ==13560== checked 84,743,624 bytes. ==13560== ==13560== Thread 1: ==13560== ==13560== 19 bytes in 1 blocks are still reachable in loss record 1 of 8 ==13560== at 0x4005400: malloc (vg_replace_malloc.c:149) ==13560== by 0x2CD7E4: _dl_new_object (in /lib/ld-2.5.so) ==13560== by 0x2C90E0: _dl_map_object_from_fd (in /lib/ld-2.5.so) ==13560== by 0x2CB403: _dl_map_object (in /lib/ld-2.5.so) ==13560== by 0x2D4668: dl_open_worker (in /lib/ld-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==13560== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==13560== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==13560== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==13560== ==13560== ==13560== 19 bytes in 1 blocks are still reachable in loss record 2 of 8 ==13560== at 0x4005400: malloc (vg_replace_malloc.c:149) ==13560== by 0x2CB953: _dl_map_object (in /lib/ld-2.5.so) ==13560== by 0x2D4668: dl_open_worker (in /lib/ld-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==13560== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==13560== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==13560== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==13560== by 0x48F640: __pthread_unwind (in /lib/libpthread-2.5.so) ==13560== by 0x48A31F: pthread_exit (in /lib/libpthread-2.5.so) ==13560== ==13560== ==13560== 28 bytes in 1 blocks are still reachable in loss record 3 of 8 ==13560== at 0x4005400: malloc (vg_replace_malloc.c:149) ==13560== by 0x2CFA38: _dl_map_object_deps (in /lib/ld-2.5.so) ==13560== by 0x2D46C4: dl_open_worker (in /lib/ld-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==13560== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==13560== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==13560== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==13560== by 0x48F640: __pthread_unwind (in /lib/libpthread-2.5.so) ==13560== by 0x48A31F: pthread_exit (in /lib/libpthread-2.5.so) ==13560== ==13560== ==13560== 224 bytes in 1 blocks are still reachable in loss record 4 of 8 ==13560== at 0x400473F: calloc (vg_replace_malloc.c:279) ==13560== by 0x2D2353: _dl_check_map_versions (in /lib/ld-2.5.so) ==13560== by 0x2D4980: dl_open_worker (in /lib/ld-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==13560== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==13560== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==13560== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==13560== by 0x48F640: __pthread_unwind (in /lib/libpthread-2.5.so) ==13560== by 0x48A31F: pthread_exit (in /lib/libpthread-2.5.so) ==13560== ==13560== ==13560== 614 bytes in 1 blocks are still reachable in loss record 5 of 8 ==13560== at 0x400473F: calloc (vg_replace_malloc.c:279) ==13560== by 0x2CD57A: _dl_new_object (in /lib/ld-2.5.so) ==13560== by 0x2C90E0: _dl_map_object_from_fd (in /lib/ld-2.5.so) ==13560== by 0x2CB403: _dl_map_object (in /lib/ld-2.5.so) ==13560== by 0x2D4668: dl_open_worker (in /lib/ld-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==13560== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==13560== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==13560== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==13560== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==13560== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==13560== ==13560== ==13560== 1,224 bytes in 9 blocks are possibly lost in loss record 6 of 8 ==13560== at 0x400473F: calloc (vg_replace_malloc.c:279) ==13560== by 0x2D3AA9: _dl_allocate_tls (in /lib/ld-2.5.so) ==13560== by 0x489AC8: pthread_create@@GLIBC_2.1 (in /lib/libpthread-2.5.so) ==13560== by 0x84B1EA8: my_thread_global_init (my_thr_init.c:113) ==13560== by 0x848F1FF: my_init (my_init.c:92) ==13560== by 0x81C6435: main (mysqld.cc:4133) ==13560== ==13560== ==13560== 4,636 (996 direct, 3,640 indirect) bytes in 1 blocks are definitely lost in loss record 7 of 8 ==13560== at 0x4005400: malloc (vg_replace_malloc.c:149) ==13560== by 0x849AF99: my_malloc (my_malloc.c:34) ==13560== by 0x849B940: alloc_root (my_alloc.c:201) ==13560== by 0x817284D: sql_alloc(unsigned) (thr_malloc.cc:41) ==13560== by 0x811FF19: Item::tmp_table_field_from_field_type(st_table*, bool) (field.h:52) ==13560== by 0x8226E2C: create_tmp_field_from_item(THD*, Item*, st_table*, Item***, bool, unsigned) (sql_select.cc:9269) ==13560== by 0x82273A4: create_tmp_field(THD*, st_table*, Item*, Item::Type, Item***, Field**, Field**, bool, bool, bool, bool, unsigned) (sql_select.cc:9527) ==13560== by 0x8227F7F: create_tmp_table(THD*, TMP_TABLE_PARAM*, List&, st_order*, bool, bool, unsigned long long, unsigned long long, char*) (sql_select.cc:9853) ==13560== by 0x831793E: select_union::create_result_table(THD*, List*, bool, unsigned long long, char const*) (sql_union.cc:122) ==13560== by 0x8327AB7: Select_materialize::send_fields(List&, unsigned) (sql_cursor.cc:706) ==13560== by 0x82431E6: JOIN::exec() (sql_select.cc:1659) ==13560== by 0x82460ED: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_re) ==13560== ==13560== ==13560== 3,640 bytes in 3 blocks are indirectly lost in loss record 8 of 8 ==13560== at 0x4005400: malloc (vg_replace_malloc.c:149) ==13560== by 0x849AF99: my_malloc (my_malloc.c:34) ==13560== by 0x849B940: alloc_root (my_alloc.c:201) ==13560== by 0x8327ADF: Select_materialize::send_fields(List&, unsigned) (sql_list.h:39) ==13560== by 0x82431E6: JOIN::exec() (sql_select.cc:1659) ==13560== by 0x82460ED: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_re) ==13560== by 0x824664C: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:269) ==13560== by 0x81CFA73: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4765) ==13560== by 0x81D2774: mysql_execute_command(THD*) (sql_parse.cc:2073) ==13560== by 0x8327E38: mysql_open_cursor(THD*, unsigned, select_result*, Server_side_cursor**) (sql_cursor.cc:170) ==13560== by 0x8253DD6: Prepared_statement::execute(String*, bool) (sql_prepare.cc:3526) ==13560== by 0x82550A8: Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) (sql_prepare.cc:3224) ==13560== ==13560== LEAK SUMMARY: ==13560== definitely lost: 996 bytes in 1 blocks. ==13560== indirectly lost: 3,640 bytes in 3 blocks. ==13560== possibly lost: 1,224 bytes in 9 blocks. ==13560== still reachable: 904 bytes in 5 blocks. ==13560== suppressed: 0 bytes in 0 blocks. --13560-- memcheck: sanity checks: 33172 cheap, 1327 expensive --13560-- memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use --13560-- memcheck: auxmaps: 0 searches, 0 comparisons --13560-- memcheck: SMs: n_issued = 37762 (604192k, 590M) --13560-- memcheck: SMs: n_deissued = 37320 (597120k, 583M) --13560-- memcheck: SMs: max_noaccess = 65535 (1048560k, 1023M) --13560-- memcheck: SMs: max_undefined = 1177 (18832k, 18M) --13560-- memcheck: SMs: max_defined = 1442 (23072k, 22M) --13560-- memcheck: SMs: max_non_DSM = 1173 (18768k, 18M) --13560-- memcheck: max sec V bit nodes: 19897 (1010k, 0M) --13560-- memcheck: set_sec_vbits8 calls: 260516 (new: 19930, updates: 240586) --13560-- memcheck: max shadow mem size: 20082k, 19M --13560-- translate: fast SP updates identified: 67,272 ( 84.6%) --13560-- translate: generic_known SP updates identified: 10,263 ( 12.9%) --13560-- translate: generic_unknown SP updates identified: 1,889 ( 2.3%) --13560-- tt/tc: 9,051,745 tt lookups requiring 16,798,742 probes --13560-- tt/tc: 9,051,745 fast-cache updates, 5 flushes --13560-- transtab: new 47,374 (1,455,928 -> 20,934,073; ratio 143:10) [0 scs] --13560-- transtab: dumped 0 (0 -> ??) --13560-- transtab: discarded 126 (2,146 -> ??) --13560-- scheduler: 3,199,779,916 jumps (bb entries). --13560-- scheduler: 33,172/11,194,415 major/minor sched events. --13560-- sanity: 33173 cheap, 1327 expensive checks. --13560-- exectx: 30,011 lists, 2,299 contexts (avg 0 per list) --13560-- exectx: 875,607 searches, 877,393 full compares (1,002 per 1000) --13560-- exectx: 20 cmp2, 197 cmp4, 0 cmpAll [sbester@box1 mysql-5.1]$ [sbester@box1 mysql-5.1]$ valgrind --version valgrind-3.2.1 [sbester@box1 mysql-5.1]$