Dear all, Two questions about server variables tuning.
1) key_buffer_size stores MyISAM indexes; innodb_buffer_pool_size stores InnoDB indexes and rows. So the innoDB buffer would need more space in general. It sounds like a good idea, if the number and size of MyISAM and InnoDB tables is roughly the same, to set innodb_buffer_pool_size larger than key_buffer_size. 2) Assume that there are many "LIKE '%...%'" queries being performed on the server. Variables to (carefully) tune in this case would be read_buffer_size and read_rnd_buffer_size. Does this make sense? Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
