Ron Johnson wrote:
The readahead on the Woody box is 8, it is 256 on the sarge box. That's one difference. Are both boxes only MySQL servers, and are you *sure* that the Sarge box is quiescent when you run the test?
The sarge box is a production box, which runs the standard LAMP setup. So it might not be quiescent (nice word BTW).
Both my.cnf files are pretty much the same>How different are they?
Config files (sorry for the large post): Woody (Dev box that is running fine): [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] err-log = /var/log/mysql/mysql.err socket = /var/run/mysqld/mysqld.sock [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 log = /var/log/mysql/mysql.log basedir = /usr datadir = /mnt/raid/mysql #datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-locking #skip-networking key_buffer = 16M max_allowed_packet = 1M thread_stack = 128K query_cache_limit = 1048576 query_cache_size = 26214400 query_cache_type = 1 skip-innodb mysqldump] quick max_allowed_packet = 1M [mysql] #no-auto-rehash [isamchk] key_buffer = 16M Sarge (Prod box that runs slow queries): [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = -15 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr #datadir = /var/lib/mysql datadir = /mnt/raid/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K query_cache_limit = 1048576 query_cache_size = 26214400 query_cache_type = 1 skip-bdb skip-innodb [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #[isamchk] #key_buffer = 16M [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M