← Back to team overview

enterprise-support team mailing list archive

[Bug 1124242] Re: Memory leak with InnoDB temporary tables

 

Run above test on 5.6.15 but there too, no much difference in VSZ and
RSS. Even Dictionary memory allocation is also same and not noticeable
changes in massif output.

Before Test

root@Dell-XPS:~# ps aux | grep mysql
mysql    16055 11.2  2.5 599344 206804 pts/3   Sl   16:19   0:09 /usr/bin/valgrind.bin --tool=massif --massif-out-file=/tmp/massif.out /usr/sbin/mysqld

Dictionary memory allocated 138338


After Test

root@Dell-XPS:~# ps aux | grep mysqld
mysql    16055 20.8  2.6 599344 214984 pts/3   Sl   16:19   1:10 /usr/bin/valgrind.bin --tool=massif --massif-out-file=/tmp/massif.out /usr/sbin/mysqld

Dictionary memory allocated 138338

99.83% (139,535,953B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc.
->46.05% (64,355,920B) 0x907FA5: pfs_malloc(unsigned long, int) (in /usr/sbin/mysqld)
| ->11.33% (15,834,304B) 0x90DE93: init_table_share(unsigned int) (in /usr/sbin/mysqld)
| | ->11.33% (15,834,304B) 0x911792: initialize_performance_schema(PFS_global_param*) (in /usr/sbin/mysqld)
| |   ->11.33% (15,834,304B) 0x5D0CFB: mysqld_main(int, char**) (in /usr/sbin/mysqld)
| |     ->11.33% (15,834,304B) 0x6709EA3: (below main) (libc-start.c:260)

99.73% (121,100,513B) (heap allocation functions) malloc/new/new[], --alloc-fns, etc.
->53.00% (64,355,920B) 0x907FA5: pfs_malloc(unsigned long, int) (in /usr/sbin/mysqld)
| ->13.04% (15,834,304B) 0x90DE93: init_table_share(unsigned int) (in /usr/sbin/mysqld)
| | ->13.04% (15,834,304B) 0x911792: initialize_performance_schema(PFS_global_param*) (in /usr/sbin/mysqld)
| |   ->13.04% (15,834,304B) 0x5D0CFB: mysqld_main(int, char**) (in /usr/sbin/mysqld)
| |     ->13.04% (15,834,304B) 0x6709EA3: (below main) (libc-start.c:260)



** Changed in: percona-server/5.6
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1124242

Title:
  Memory leak with InnoDB temporary tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1124242/+subscriptions