Help for very bad perf for MySQL

[Albert Shih]

 Le 26/11/2007 à 07:20:43-0500, Philip M. Gollucci a écrit
> Albert Shih wrote:
> > 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.
> Well -- we'll need more information, but as your say, if its not
> threading related what makes you think its FreeBSD.  You'd probably have
> better luck over on mysql at lists.mysql.com.

Thanks for this information.

> Also, your my.cnf is the next step.

[client]
port            = 3306
socket          = /tmp/mysql.sock
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
log-bin=mysql-bin
server-id       = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

Regards.

JAS

--

Albert SHIH
Observatoire de Paris Meudon
SIO batiment 15
Heure local/Local time:
Mar 27 nov 2007 14:02:31 CET