Re: MySQL 4.x performance tuning

2004-01-05 Thread Chuck Gadd
Reto Baumann wrote: Is there a way to see if the key buffer size was ever reached? It's not really an issue. You can determine how frequently it has the needed index data in memory, to judge the key buffer efficiency. Key read requests 3518220013 Key reads 94807 Key reads / Key

MySQL 4.x performance tuning

2004-01-05 Thread Reto Baumann
Hi all I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The database primarily uses MyISAM tables with 60% SELECT statements. The database is used as a backend for a PHP web application. Do the following values make any sense? set-variable= key_buffer=200M set-