Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 26 Nov 2007 12:50:22 +0100
From:      Albert Shih <Albert.Shih@obspm.fr>
To:        freebsd-questions@freebsd.org
Subject:   Help for very bad perf for MySQL
Message-ID:  <20071126115022.GA70340@pcjas.obspm.fr>

next in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071126115022.GA70340>