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
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: MEMORY USAGE Max Memory Ever Allocated : 2.86 G Configured Max Per-thread Buffers : 1.80 G Configured Max Global Buffers : 2.10 G Configured Max Memory