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]