From: Nitin Mehta Date: May 20 2010 7:50am Subject: Re: Innodb buffer pool size List-Archive: http://lists.mysql.com/mysql/221624 Message-Id: <529316.61533.qm@web57008.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1495819394-1274341852=:61533" --0-1495819394-1274341852=:61533 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=0AFirst thing that comes to my mind is that it is probably the best = time to put your application server and database server on different hosts.= Having said that, in this case increasing buffer pool size is still advisa= ble as per my understanding. Your swap consumption will go up in that case = which is not very good either. But giving only 4 GB to Innodb is even worse= for the performance. It is subjective though. You should first check if My= SQL is actually using the allotted 4GB or not. If not, increasing the value= will not help.=0A=0AMaybe someone can correct me if I'm wrong. :-)=0A=0AHo= pe that helps!=0A=0ARegards,=0ANitin=0A=0A=0A=0A=0A________________________= ________=0AFrom: Machiel Richards =0ATo: mysql@stripped= sql.com=0ASent: Thu, May 20, 2010 1:07:43 PM=0ASubject: Innodb buffer pool = size=0A=0AHi Guys=0A=0A=0A=0A=A0 =A0 I just have a quick question.=0A=0A=0A= =0A=A0 =0A=0A=A0 I have done some research into how to determine the size o= f your Innodb=0Abuffer pool.=0A=0A=0A=0A=A0 All of the sources I used, spec= ified that the Innodb buffer pool size=0Ashould be the same size as your da= tabase + 10%.=0A=0A=0A=0A=0A=0A=A0 =A0 However, as far as I understand it, = the buffer size also relies on that=0Aamount of memory being available. Thu= s if you increase the buffer size, the=0Aamount of memory used will be incr= eased.=0A=0A=0A=0A=A0 My thinking however, is what happens when the databas= e size grows bigger=0Athan the amount of memory available to the hardware. = =0A=0A=0A=0A=A0 Say for instance,=A0 a server with MySQL also runs other ap= plications. The=0Aamount of memory on the server is 32Gb and about 31Gb is = already in use. =0A=0A=0A=0A=A0 =A0 The current Innodb buffer pool size is = at 4Gb for instance, and the=0Ainnodb tables then grow to be about 8Gb in s= ize.=0A=0A=0A=0A=A0 What would be the appropriate actions for this to ensur= e the buffers are=0Aset to the size to best suit the database needs?=0A=0A= =0A --0-1495819394-1274341852=:61533--