Help for very bad perf for MySQL

[Albert Shih]

 Le 26/11/2007 à 13:31:12+0100, Jan Catrysse a écrit
> > > > 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).
> 
> > > 6 seconds seem to be an awful lot. What kind of query are 
> > you running 
> > > on what kind of database / contents?
> 
> > I don't really known it's some scientifical data. But the 
> > problem is on a basic linux pc (with SATA disk) the time is 
> > 0.6 sec with same request and same data. And it's for web 
> > applications. At 6 sec for one request it's become very long 
> > for the visitor because the application make many requests.
> > 
> > Regards
> > --
> > Albert SHIH
> 
> Did you try pinpointing down the problem to make sure their is not another
> bottleneck? Is the system running in production environment for the moment
> or are you the sole user?

No the server is empty (only root can logging) and no service running
(other thant Mysql and apache). And when I try this test the load of the
server is near zero.

> 
> How did you install MySQL? I my experience (but I can be wrong) the default
> settings give the best performance on 5.x MySQL FreeBSD 6.2. So no Linux
> threads and stuff...

Directly from the ports.

Regards.
> 
JAS
--
Albert SHIH
Observatoire de Paris Meudon
SIO batiment 15
Heure local/Local time:
Mar 27 nov 2007 14:00:40 CET