Date: Thu, 17 May 2007 22:52:19 -0700 (PDT) From: Tom Samplonius <tom@samplonius.org> To: Albert Wong <ajwwong@gmail.com> Cc: freebsd-stable@freebsd.org Subject: Re: mysql frequently crash on 6.2 Message-ID: <18772539.2131179467539180.JavaMail.root@ly.sdf.com> In-Reply-To: <464cb7ee.47aeb6f6.546d.7849@mx.google.com>
next in thread | previous in thread | raw e-mail | index | archive | help
----- "Albert Wong" <ajwwong@gmail.com> wrote: > key_buffer = 32M key_buffer has the most influence over the performance of MyISAM database. You should increase it as much as possible. On a dedicated 2GB server, 1GB is good. But it only helps, if you actually have indexes. There is no point is increasing it bigger than the size of your indexes (*.MYI files). But if you can hold all of the indexes in RAM, everything gets really, really fast. BTW, I agree with the other comments about the MySQL query cache. It is more of a work around for two problems: * A poorly indexed database, so that queries that return small results don't use an index, so caching the results is required. * Dumb applications that send the same query over and over again, even though the database has not changed. Some e-mail servers do this. A query cache should be small (5MB or less), if you use it at all. And you should never cache large results (there is an option that sets the size threshold). But I use MySQL 5.0 on several FreeBSD 6 systems, and they are moderately busy (250 q/s & 450 q/s), and it works ok. MyISAM is the problem, and I need to switch to InnoDB. Tom
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?18772539.2131179467539180.JavaMail.root>