Help for very bad perf for MySQL
ivoras at freebsd.org
Mon Nov 26 04:25:35 PST 2007
Albert Shih wrote:
> Hi all
> I've already send a message. But I don't receive any answer :-(. I try again
> and hope there more solution
> I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql
> 5.X on this server and the performance of MySQL is very bad. For some
> complexe select I've got ~6secondes (on some basic Linux it's take 0.6
> sec). And I think this is nothing about thead (that's mean I don't think
> FreeBSD 7.0 can solve my problem) because it's just for one select.
For starts, if you didn't do it already, copy
/usr/local/share/mysql/my-huge.cnf to /etc/my.cnf and try again. These
are just some general settings, they might or might not help you.
More information about the freebsd-questions