Help for very bad perf for MySQL
Albert.Shih at obspm.fr
Tue Nov 27 05:00:22 PST 2007
Le 26/11/2007 à 22:34:34-0800, Ted Mittelstaedt a écrit
Sorry yeasterday I don't have time to answer you.
> > 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 ?
> Start with the obvious stuff first. How big is the database? How
> big is system ram? If you have less ram than you have database then
> mysql will have to go to the hard disk for the select which will kill
> it's performance.
Database size ~ 180Mo
Ram of server = 4 Go
Nothing run on this server (charge is near zero).
The disk I/O is running very fast.
The make buildworld is fast too (I don't have measure but it's «fast» ;-))
Observatoire de Paris Meudon
SIO batiment 15
Heure local/Local time:
Mar 27 nov 2007 13:58:17 CET
More information about the freebsd-questions