Help for very bad perf for MySQL

[Jan Catrysse]

> -----Original Message-----
> From: owner-freebsd-questions at freebsd.org 
> [mailto:owner-freebsd-questions at freebsd.org] On Behalf Of Albert Shih
> Sent: Monday, November 26, 2007 12:50 PM
> To: freebsd-questions at freebsd.org
> Subject: Help for very bad perf for MySQL
> 
> 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.
> 
> The server have two SAS 10 000 tr/m disks.
> 
> Anyone have some advise to tunning FreeBSD or MySQL for 
> increase the perf ?
> 
> Regards
> --
> Albert SHIH
> Observatoire de Paris Meudon
> SIO batiment 15
> Heure local/Local time:
> Lun 26 nov 2007 12:46:06 CET

6 seconds seem to be an awful lot. What kind of query are you running on
what kind of database / contents?

Regs,
Jan