Help for very bad perf for MySQL

[Ivan Voras]

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.