[sbester@box1 mysql-enterprise-gpl-5.0.66a-linux-i686-glibc23]$ valgrind --tool=memcheck --leak-check=yes -v --show-reachable=yes ./bin/mysqld --basedir=./ --datadir=/home/sbester/mysql/5.0/mysql-enterprise-gpl-5.0.66a-linux-i686-glibc23/data --skip-grant-tables --skip-name-resolve --innodb_buffer_pool_size=50M --innodb_flush_log_at_trx_commit=0 ==31262== Memcheck, a memory error detector. ==31262== Copyright (C) 2002-2006, and GNU GPL'd, by Julian Seward et al. ==31262== Using LibVEX rev 1658, a library for dynamic binary translation. ==31262== Copyright (C) 2004-2006, and GNU GPL'd, by OpenWorks LLP. ==31262== Using valgrind-3.2.1, a dynamic binary instrumentation framework. ==31262== Copyright (C) 2000-2006, and GNU GPL'd, by Julian Seward et al. ==31262== --31262-- Command line --31262-- ./bin/mysqld --31262-- --basedir=./ --31262-- --datadir=/home/sbester/mysql/5.0/mysql-enterprise-gpl-5.0.66a-linux-i686-glibc23/data --31262-- --skip-grant-tables --31262-- --skip-name-resolve --31262-- --innodb_buffer_pool_size=50M --31262-- --innodb_flush_log_at_trx_commit=0 --31262-- Startup, with flags: --31262-- --tool=memcheck --31262-- --leak-check=yes --31262-- -v --31262-- --show-reachable=yes --31262-- Contents of /proc/version: --31262-- Linux version 2.6.18-1.2798.fc6xen (brewbuilder@hs20-bc2-4.build.redhat.com) (gcc version 4.1.1 20061011 (Red Hat 4.1.1-30)) #1 SMP Mon Oct 16 15:11:19 EDT 2006 --31262-- Arch and hwcaps: X86, x86-sse1-sse2 --31262-- Valgrind library directory: /usr/lib/valgrind --31262-- Reading syms from /lib/ld-2.5.so (0x2C3000) --31262-- Reading syms from /home/sbester/mysql/5.0/mysql-enterprise-gpl-5.0.66a-linux-i686-glibc23/bin/mysqld (0x8048000) --31262-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000) --31262-- object doesn't have a dynamic symbol table --31262-- Reading suppressions file: /usr/lib/valgrind/default.supp --31262-- REDIR: 0x2D80F0 (index) redirected to 0x38027D0F (vgPlain_x86_linux_REDIR_FOR_index) --31262-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000) --31262-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000) ==31262== WARNING: new redirection conflicts with existing -- ignoring it --31262-- new: 0x002D80F0 (index ) R-> 0x040060C0 index --31262-- REDIR: 0x2D8290 (strlen) redirected to 0x4006290 (strlen) --31262-- Reading syms from /lib/librt-2.5.so (0x4C3000) --31262-- Reading syms from /lib/libdl-2.5.so (0xDD5000) --31262-- Reading syms from /lib/libpthread-2.5.so (0x484000) --31262-- Reading syms from /lib/libcrypt-2.5.so (0x50D8000) --31262-- Reading syms from /lib/libnsl-2.5.so (0x2E0000) --31262-- Reading syms from /lib/libm-2.5.so (0x4019000) --31262-- Reading syms from /lib/libc-2.5.so (0x309000) --31262-- REDIR: 0x3764E0 (memset) redirected to 0x4006580 (memset) --31262-- REDIR: 0x3769D0 (memcpy) redirected to 0x4006C60 (memcpy) --31262-- REDIR: 0x375640 (rindex) redirected to 0x4005FA0 (rindex) --31262-- REDIR: 0x3709B0 (calloc) redirected to 0x40046A8 (calloc) --31262-- REDIR: 0x370CB0 (malloc) redirected to 0x400537B (malloc) --31262-- Reading syms from /lib/libgcc_s-4.1.1-20061011.so.1 (0x4ECE000) --31262-- object doesn't have a symbol table --31262-- REDIR: 0x3752A0 (strlen) redirected to 0x4006270 (strlen) --31262-- REDIR: 0x375490 (strncmp) redirected to 0x40062D0 (strncmp) --31262-- REDIR: 0x374A20 (strcat) redirected to 0x4006660 (strcat) --31262-- REDIR: 0x3724C0 (free) redirected to 0x4004F95 (free) --31262-- REDIR: 0x374DB0 (strcpy) redirected to 0x40069F0 (strcpy) --31262-- REDIR: 0x374D40 (strcmp) redirected to 0x4006340 (strcmp) --31262-- REDIR: 0x374BD0 (index) redirected to 0x4006090 (index) --31262-- REDIR: 0x3766D0 (stpcpy) redirected to 0x4006910 (stpcpy) --31262-- REDIR: 0x376470 (memmove) redirected to 0x40065B0 (memmove) --31262-- REDIR: 0x377280 (rawmemchr) redirected to 0x4006640 (rawmemchr) 080729 13:11:57 InnoDB: Started; log sequence number 0 47414407 --31262-- REDIR: 0x375FE0 (memchr) redirected to 0x4006460 (memchr) --31262-- REDIR: 0x377350 (strchrnul) redirected to 0x4006610 (strchrnul) --31262-- Reading syms from /lib/libnss_files-2.5.so (0x4E52000) 080729 13:11:58 [Note] ./bin/mysqld: ready for connections. Version: '5.0.66a-enterprise-gpl' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server (GPL) --31262-- REDIR: 0x3726B0 (realloc) redirected to 0x400542A (realloc) --31262-- REDIR: 0x375590 (strncpy) redirected to 0x4006DE0 (strncpy) --31262-- REDIR: 0x375350 (strnlen) redirected to 0x4006240 (strnlen) ==31262== Thread 11: ==31262== Syscall param pwrite64(buf) points to uninitialised byte(s) ==31262== at 0x490AA6: pwrite64 (in /lib/libpthread-2.5.so) ==31262== by 0x83AD26C: my_pwrite (my_pread.c:104) ==31262== by 0x83AF62B: flush_cached_blocks (mf_keycache.c:2281) ==31262== by 0x83AF0D3: flush_key_blocks_int (mf_keycache.c:2458) ==31262== by 0x83AE620: flush_key_blocks (mf_keycache.c:2554) ==31262== by 0x838030D: mi_lock_database (mi_locking.c:77) ==31262== by 0x818A2CC: unlock_external(THD*, st_table**, unsigned) (handler.h:658) ==31262== by 0x818928B: mysql_unlock_tables(THD*, st_mysql_lock*) (lock.cc:278) ==31262== by 0x81EECDE: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:934) ==31262== by 0x81A4204: mysql_execute_command(THD*) (sql_parse.cc:3596) ==31262== by 0x81A8DA6: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6178) ==31262== by 0x81A0C89: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1875) ==31262== Address 0xE90C045 is 29 bytes inside a block of size 7,418,880 alloc'd ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x83B1D31: my_malloc (my_malloc.c:34) ==31262== by 0x83AD636: init_key_cache (mf_keycache.c:358) ==31262== by 0x82373CE: ha_init_key_cache(char const*, st_key_cache*) (handler.cc:2358) ==31262== by 0x819D3E2: process_key_caches(int (*)(char const*, st_key_cache*)) (set_var.cc:3802) ==31262== by 0x818F474: init_server_components() (mysqld.cc:3473) ==31262== by 0x818D229: main (mysqld.cc:3752) ==31262== ==31262== Thread 14: ==31262== Syscall param write(buf) points to uninitialised byte(s) ==31262== at 0x48FCEB: (within /lib/libpthread-2.5.so) ==31262== by 0x83B0E19: my_b_flush_io_cache (mf_iocache.c:1750) ==31262== by 0x8380B8C: mi_scan_init (mi_scan.c:28) ==31262== by 0x82875F5: Materialized_cursor::open(JOIN*) (handler.h:679) ==31262== by 0x828698C: mysql_open_cursor(THD*, unsigned, select_result*, Server_side_cursor**) (sql_cursor.cc:212) ==31262== by 0x81F5902: Prepared_statement::execute(String*, bool) (sql_prepare.cc:3050) ==31262== by 0x81F46A0: mysql_stmt_execute(THD*, char*, unsigned) (sql_prepare.cc:2320) ==31262== by 0x81A1B9F: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1832) ==31262== by 0x81AC3C3: do_command(THD*) (sql_parse.cc:1581) ==31262== by 0x819FEC2: handle_one_connection (sql_parse.cc:1187) ==31262== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==31262== by 0x3D606D: clone (in /lib/libc-2.5.so) ==31262== Address 0xF50E987 is 23 bytes inside a block of size 131,072 alloc'd ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x83B1D31: my_malloc (my_malloc.c:34) ==31262== by 0x83AFC03: init_io_cache (mf_iocache.c:236) ==31262== by 0x837AEE9: mi_extra (mi_extra.c:157) ==31262== by 0x823C222: ha_myisam::extra(ha_extra_function) (ha_myisam.cc:1722) ==31262== by 0x827658B: select_union::create_result_table(THD*, List*, bool, unsigned long long, char const*) (sql_union.cc:126) ==31262== by 0x8287AB8: Select_materialize::send_fields(List&, unsigned) (sql_cursor.cc:700) ==31262== by 0x81D389F: JOIN::exec() (sql_select.cc:2092) ==31262== by 0x81D4370: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2274) ==31262== by 0x81CFC77: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:245) ==31262== by 0x81A2266: mysql_execute_command(THD*) (sql_parse.cc:2721) ==31262== by 0x828690C: mysql_open_cursor(THD*, unsigned, select_result*, Server_side_cursor**) (sql_cursor.cc:170) q080729 13:41:41 [Note] ./bin/mysqld: Normal shutdown 080729 13:41:41 InnoDB: Starting shutdown... 080729 13:41:42 InnoDB: Shutdown completed; log sequence number 0 47414407 080729 13:41:42 [Note] ./bin/mysqld: Shutdown complete --31262-- Discarding syms at 0x4E52000-0x4E5D000 in /lib/libnss_files-2.5.so due to munmap() ==31262== ==31262== ERROR SUMMARY: 1839 errors from 2 contexts (suppressed: 23 from 1) ==31262== ==31262== 204 errors in context 1 of 2: ==31262== Syscall param write(buf) points to uninitialised byte(s) ==31262== at 0x48FCEB: (within /lib/libpthread-2.5.so) ==31262== by 0x83B0E19: my_b_flush_io_cache (mf_iocache.c:1750) ==31262== by 0x8380B8C: mi_scan_init (mi_scan.c:28) ==31262== by 0x82875F5: Materialized_cursor::open(JOIN*) (handler.h:679) ==31262== by 0x828698C: mysql_open_cursor(THD*, unsigned, select_result*, Server_side_cursor**) (sql_cursor.cc:212) ==31262== by 0x81F5902: Prepared_statement::execute(String*, bool) (sql_prepare.cc:3050) ==31262== by 0x81F46A0: mysql_stmt_execute(THD*, char*, unsigned) (sql_prepare.cc:2320) ==31262== by 0x81A1B9F: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1832) ==31262== by 0x81AC3C3: do_command(THD*) (sql_parse.cc:1581) ==31262== by 0x819FEC2: handle_one_connection (sql_parse.cc:1187) ==31262== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==31262== by 0x3D606D: clone (in /lib/libc-2.5.so) ==31262== Address 0xF50E987 is 23 bytes inside a block of size 131,072 alloc'd ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x83B1D31: my_malloc (my_malloc.c:34) ==31262== by 0x83AFC03: init_io_cache (mf_iocache.c:236) ==31262== by 0x837AEE9: mi_extra (mi_extra.c:157) ==31262== by 0x823C222: ha_myisam::extra(ha_extra_function) (ha_myisam.cc:1722) ==31262== by 0x827658B: select_union::create_result_table(THD*, List*, bool, unsigned long long, char const*) (sql_union.cc:126) ==31262== by 0x8287AB8: Select_materialize::send_fields(List&, unsigned) (sql_cursor.cc:700) ==31262== by 0x81D389F: JOIN::exec() (sql_select.cc:2092) ==31262== by 0x81D4370: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2274) ==31262== by 0x81CFC77: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:245) ==31262== by 0x81A2266: mysql_execute_command(THD*) (sql_parse.cc:2721) ==31262== by 0x828690C: mysql_open_cursor(THD*, unsigned, select_result*, Server_side_cursor**) (sql_cursor.cc:170) ==31262== ==31262== 1635 errors in context 2 of 2: ==31262== Thread 11: ==31262== Syscall param pwrite64(buf) points to uninitialised byte(s) ==31262== at 0x490AA6: pwrite64 (in /lib/libpthread-2.5.so) ==31262== by 0x83AD26C: my_pwrite (my_pread.c:104) ==31262== by 0x83AF62B: flush_cached_blocks (mf_keycache.c:2281) ==31262== by 0x83AF0D3: flush_key_blocks_int (mf_keycache.c:2458) ==31262== by 0x83AE620: flush_key_blocks (mf_keycache.c:2554) ==31262== by 0x838030D: mi_lock_database (mi_locking.c:77) ==31262== by 0x818A2CC: unlock_external(THD*, st_table**, unsigned) (handler.h:658) ==31262== by 0x818928B: mysql_unlock_tables(THD*, st_mysql_lock*) (lock.cc:278) ==31262== by 0x81EECDE: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:934) ==31262== by 0x81A4204: mysql_execute_command(THD*) (sql_parse.cc:3596) ==31262== by 0x81A8DA6: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6178) ==31262== by 0x81A0C89: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1875) ==31262== Address 0xE90C045 is 29 bytes inside a block of size 7,418,880 alloc'd ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x83B1D31: my_malloc (my_malloc.c:34) ==31262== by 0x83AD636: init_key_cache (mf_keycache.c:358) ==31262== by 0x82373CE: ha_init_key_cache(char const*, st_key_cache*) (handler.cc:2358) ==31262== by 0x819D3E2: process_key_caches(int (*)(char const*, st_key_cache*)) (set_var.cc:3802) ==31262== by 0x818F474: init_server_components() (mysqld.cc:3473) ==31262== by 0x818D229: main (mysqld.cc:3752) --31262-- --31262-- supp: 23 Fedora-Core-6-hack3-ld25 ==31262== ==31262== IN SUMMARY: 1839 errors from 2 contexts (suppressed: 23 from 1) ==31262== ==31262== malloc/free: in use at exit: 6,392 bytes in 17 blocks. ==31262== malloc/free: 656,863 allocs, 656,846 frees, 1,801,228,687 bytes allocated. ==31262== ==31262== searching for pointers to 17 not-freed blocks. ==31262== checked 85,638,004 bytes. ==31262== ==31262== Thread 1: ==31262== ==31262== 19 bytes in 1 blocks are still reachable in loss record 1 of 8 ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x2CD7E4: _dl_new_object (in /lib/ld-2.5.so) ==31262== by 0x2C90E0: _dl_map_object_from_fd (in /lib/ld-2.5.so) ==31262== by 0x2CB403: _dl_map_object (in /lib/ld-2.5.so) ==31262== by 0x2D4668: dl_open_worker (in /lib/ld-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==31262== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31262== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31262== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31262== ==31262== ==31262== 19 bytes in 1 blocks are still reachable in loss record 2 of 8 ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x2CB953: _dl_map_object (in /lib/ld-2.5.so) ==31262== by 0x2D4668: dl_open_worker (in /lib/ld-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==31262== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31262== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31262== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31262== by 0x48F640: __pthread_unwind (in /lib/libpthread-2.5.so) ==31262== by 0x48A31F: pthread_exit (in /lib/libpthread-2.5.so) ==31262== ==31262== ==31262== 28 bytes in 1 blocks are still reachable in loss record 3 of 8 ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x2CFA38: _dl_map_object_deps (in /lib/ld-2.5.so) ==31262== by 0x2D46C4: dl_open_worker (in /lib/ld-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==31262== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31262== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31262== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31262== by 0x48F640: __pthread_unwind (in /lib/libpthread-2.5.so) ==31262== by 0x48A31F: pthread_exit (in /lib/libpthread-2.5.so) ==31262== ==31262== ==31262== 224 bytes in 1 blocks are still reachable in loss record 4 of 8 ==31262== at 0x400473F: calloc (vg_replace_malloc.c:279) ==31262== by 0x2D2353: _dl_check_map_versions (in /lib/ld-2.5.so) ==31262== by 0x2D4980: dl_open_worker (in /lib/ld-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==31262== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31262== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31262== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31262== by 0x48F640: __pthread_unwind (in /lib/libpthread-2.5.so) ==31262== by 0x48A31F: pthread_exit (in /lib/libpthread-2.5.so) ==31262== ==31262== ==31262== 614 bytes in 1 blocks are still reachable in loss record 5 of 8 ==31262== at 0x400473F: calloc (vg_replace_malloc.c:279) ==31262== by 0x2CD57A: _dl_new_object (in /lib/ld-2.5.so) ==31262== by 0x2C90E0: _dl_map_object_from_fd (in /lib/ld-2.5.so) ==31262== by 0x2CB403: _dl_map_object (in /lib/ld-2.5.so) ==31262== by 0x2D4668: dl_open_worker (in /lib/ld-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==31262== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==31262== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==31262== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31262== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31262== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31262== ==31262== ==31262== 1,224 bytes in 9 blocks are possibly lost in loss record 6 of 8 ==31262== at 0x400473F: calloc (vg_replace_malloc.c:279) ==31262== by 0x2D3AA9: _dl_allocate_tls (in /lib/ld-2.5.so) ==31262== by 0x489AC8: pthread_create@@GLIBC_2.1 (in /lib/libpthread-2.5.so) ==31262== by 0x83C1F02: my_thread_global_init (my_thr_init.c:112) ==31262== by 0x83AC515: my_init (my_init.c:87) ==31262== by 0x818D089: main (mysqld.cc:3620) ==31262== ==31262== ==31262== 4,264 (996 direct, 3,268 indirect) bytes in 1 blocks are definitely lost in loss record 7 of 8 ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x83B1D31: my_malloc (my_malloc.c:34) ==31262== by 0x83B23F3: alloc_root (my_alloc.c:201) ==31262== by 0x8287AE9: Select_materialize::send_fields(List&, unsigned) (sql_list.h:37) ==31262== by 0x81D28D5: JOIN::exec() (sql_select.cc:1592) ==31262== by 0x81D4370: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2274) ==31262== by 0x81CFC77: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:245) ==31262== by 0x81A2266: mysql_execute_command(THD*) (sql_parse.cc:2721) ==31262== by 0x828690C: mysql_open_cursor(THD*, unsigned, select_result*, Server_side_cursor**) (sql_cursor.cc:170) ==31262== by 0x81F5902: Prepared_statement::execute(String*, bool) (sql_prepare.cc:3050) ==31262== by 0x81F46A0: mysql_stmt_execute(THD*, char*, unsigned) (sql_prepare.cc:2320) ==31262== by 0x81A1B9F: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1832) ==31262== ==31262== ==31262== 3,268 bytes in 2 blocks are indirectly lost in loss record 8 of 8 ==31262== at 0x4005400: malloc (vg_replace_malloc.c:149) ==31262== by 0x83B1D31: my_malloc (my_malloc.c:34) ==31262== by 0x83B23F3: alloc_root (my_alloc.c:201) ==31262== by 0x815CD54: sql_alloc(unsigned) (thr_malloc.cc:41) ==31262== by 0x811C068: Item::tmp_table_field_from_field_type(st_table*) (field.h:51) ==31262== by 0x81DE0A7: create_tmp_field_from_item(THD*, Item*, st_table*, Item***, bool, unsigned) (sql_select.cc:8961) ==31262== by 0x81D69F7: create_tmp_table(THD*, TMP_TABLE_PARAM*, List&, st_order*, bool, bool, unsigned long long, unsigned long long, char*) (sql_select.cc:9481) ==31262== by 0x8276550: select_union::create_result_table(THD*, List*, bool, unsigned long long, char const*) (sql_union.cc:122) ==31262== by 0x8287AB8: Select_materialize::send_fields(List&, unsigned) (sql_cursor.cc:700) ==31262== by 0x81D28D5: JOIN::exec() (sql_select.cc:1592) ==31262== by 0x81D4370: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2274) ==31262== by 0x81CFC77: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:245) ==31262== ==31262== LEAK SUMMARY: ==31262== definitely lost: 996 bytes in 1 blocks. ==31262== indirectly lost: 3,268 bytes in 2 blocks. ==31262== possibly lost: 1,224 bytes in 9 blocks. ==31262== still reachable: 904 bytes in 5 blocks. ==31262== suppressed: 0 bytes in 0 blocks. --31262-- memcheck: sanity checks: 21178 cheap, 848 expensive --31262-- memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use --31262-- memcheck: auxmaps: 0 searches, 0 comparisons --31262-- memcheck: SMs: n_issued = 9124 (145984k, 142M) --31262-- memcheck: SMs: n_deissued = 8545 (136720k, 133M) --31262-- memcheck: SMs: max_noaccess = 65535 (1048560k, 1023M) --31262-- memcheck: SMs: max_undefined = 1066 (17056k, 16M) --31262-- memcheck: SMs: max_defined = 1432 (22912k, 22M) --31262-- memcheck: SMs: max_non_DSM = 704 (11264k, 11M) --31262-- memcheck: max sec V bit nodes: 568 (28k, 0M) --31262-- memcheck: set_sec_vbits8 calls: 655 (new: 568, updates: 87) --31262-- memcheck: max shadow mem size: 11596k, 11M --31262-- translate: fast SP updates identified: 80,179 ( 89.9%) --31262-- translate: generic_known SP updates identified: 2,989 ( 3.3%) --31262-- translate: generic_unknown SP updates identified: 5,935 ( 6.6%) --31262-- tt/tc: 12,290,349 tt lookups requiring 16,791,039 probes --31262-- tt/tc: 12,290,349 fast-cache updates, 4 flushes --31262-- transtab: new 35,977 (971,341 -> 16,555,463; ratio 170:10) [0 scs] --31262-- transtab: dumped 0 (0 -> ??) --31262-- transtab: discarded 126 (2,146 -> ??) --31262-- scheduler: 2,077,949,628 jumps (bb entries). --31262-- scheduler: 21,178/16,657,478 major/minor sched events. --31262-- sanity: 21179 cheap, 848 expensive checks. --31262-- exectx: 30,011 lists, 1,671 contexts (avg 0 per list) --31262-- exectx: 1,315,481 searches, 1,335,477 full compares (1,015 per 1000) --31262-- exectx: 19 cmp2, 2,068 cmp4, 0 cmpAll [sbester@box1 mysql-enterprise-gpl-5.0.66a-linux-i686-glibc23]$ q