Databases Reference
In-Depth Information
The most important options are these two, assuming that you use InnoDB, which most
people should:
•
innodb_buffer_pool_size
•
innodb_log_file_size
Congratulations—you just solved the vast majority of real-world configuration prob-
lems we've seen! If you use our configuration tool at
http://tools.percona.com
, you will
get good suggestions for a starting point on these and other configuration options.
We've also made a lot of suggestions about what not to do. The most important of
these are not to “tune” your server; not to use ratios, formulas, or “tuning scripts” as
a basis for setting the configuration variables; not to trust advice from unknown people
on the Internet; and not to go hunting in
SHOW STATUS
counters for things that look bad.
If something is actually wrong, it'll show up in your server profiling.
There are a few significant settings we didn't discuss in this chapter, which are impor-
tant for specific types of hardware and workloads. We delayed discussion of these
settings because we believe that any advice on settings needs to be paired with an
explanation of the internal processes at work. This brings us to the next chapter, which
will show you how to optimize your hardware and operating system for MySQL, and
vice versa.
