Please, mount your disks using "forcedirectio".
Regards,
Juan
On 7/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds.
The same statements on an equal testmachine take less than 1 second.
Server: CPU: 2 x 440 MHz sparcv9
RAM: 2GB
(top: Memory: 2048M real, 931M free, 732M swap in use, 2839M swap
free)
OS: SunOS 5.9
Database: Version: MySQL 4.0.20 (build from source)
Traffic: averaged 4985 Bytes/sec sent
averaged 41 questions/sec
averaged 0,3 connections/sec
Some options in my.cnf:
[mysqld]
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 96
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
query_cache_size = 16M
max_connections = 125
Is there just to much traffic on the machine or could help tuning some
parameters?
Thanks.
Best regards,
Spiker
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
