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 …[Read more...]