Hopefully you are caught up on the recommended reading from the
last post as today we will look at creating a simple benchmark
using a common tool to determine which option file to use. The
MySQL server will use default values if it can not find an option
file. Under the /usr/local/mysql/support-files for MySQL 5.6 are
sample configuration files that can be renamed and dropped in place as a staring point. See the Using Option File page for details.
But these files have not kept pace with hardware. For instance, a small system is listed as being under 64m of memory while huge is 1-2G. More modern settings will be covered in a later post but we can use these files in a simple test on a fairly simple test machine2.
So how do we know which configuration is the best for the environment? A simple test will be run that accesses the …[Read more]