Please, mount your disks using "forcedirectio".
Regards,
Juan
On 7/3/07, spikerlion@stripped <spikerlion@stripped> 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/mysql?unsub=1
>
>
