> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Albert Shih > Sent: Monday, November 26, 2007 12:50 PM > To: freebsd-questions@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 _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"