RE: Troubleshoot excessive memory usage in InnoDB

2013-04-29 Thread Rick James
ARIABLES, I can look for other issues. > -Original Message- > From: Denis Jedig [mailto:d...@syneticon.net] > Sent: Saturday, April 20, 2013 2:16 AM > To: mysql@lists.mysql.com > Subject: Re: Troubleshoot excessive memory usage in InnoDB > > 19.04.2013 23:39, Ilya Kazakevic

Re: Troubleshoot excessive memory usage in InnoDB

2013-04-20 Thread Denis Jedig
19.04.2013 23:39, Ilya Kazakevich: Try to use "tuning-primer.sh": this scripts reads your variables and prints memory size you need for that. I tried that. The results are inconspicious: MEMORY USAGE Max Memory Ever Allocated : 5.27 G Configured Max Per-thread Buffers : 1.92 G Configured Max

RE: Troubleshoot excessive memory usage in InnoDB

2013-04-19 Thread Rick James
is Jedig'; mysql@lists.mysql.com > Subject: RE: Troubleshoot excessive memory usage in InnoDB > > Hello, > > Try to use "tuning-primer.sh": this scripts reads your variables and > prints memory size you need for that. > > Here is example of its output: > MEM

RE: Troubleshoot excessive memory usage in InnoDB

2013-04-19 Thread Ilya Kazakevich
igured Max Memory Limit : 3.91 G Physical Memory : 5.82 G I am not sure if it works correctly with 5.6 Ilya >-Original Message- >From: Denis Jedig [mailto:d...@syneticon.net] >Sent: Saturday, April 20, 2013 1:17 AM >To: mysql@lists.mysql.com >Subject: Troubleshoot excessive mem

Troubleshoot excessive memory usage in InnoDB

2013-04-19 Thread Denis Jedig
Hi all. In a specific MySQL installation of 5.6.10 using InnoDB tables, I am observing unusual memory consumption patterns. The memory usage is growing constantly - even beyond the physical memory limits. The entire on-disk storage is 41 GB (uncompressed), yet memory usage is happily growing