From: Michael Dykman Date: February 9 2012 4:52pm Subject: Re: Tuning mysql List-Archive: http://lists.mysql.com/mysql/226773 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Good advice, all of it. What hasn't been said and should be noted: in most cases, the bottleneck is the queries themselves. You will generally get a lot more boost from tuning those than from any configuration tweaking (excepting the pathological cases). - michael dykman On Thu, Feb 9, 2012 at 10:52 AM, Giovanni Bechis wrote: > Grant wrote: >> I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should >> change any settings. =A0I'm using mysql with a website on the same >> server so I have skip-networking, and I increased key_buffer and >> innodb_buffer_pool_size from 16M to 256M. =A0Everything else is default. >> Should I consider changing these or any other settings? >> > pt-variable-advisor from percona-toolkit (http://www.percona.com/download= s/percona-toolkit/2.0.3/) > =A0Giovanni > -- > /* > =A0* SnB - Hosting and software solutions > =A0* http://www.snb.it > =A0*/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.