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 <bi...@snb.it> wrote: > Grant <emailgr...@gmail.com> wrote: >> I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should >> change any settings. I'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. Everything else is default. >> Should I consider changing these or any other settings? >> > pt-variable-advisor from percona-toolkit > (http://www.percona.com/downloads/percona-toolkit/2.0.3/) > Giovanni > -- > /* > * SnB - Hosting and software solutions > * http://www.snb.it > */ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql