O'Reilly logo

Managing & Using MySQL, 2nd Edition by Hugh E. Williams, Randy Yarger, George Reese, Tim King

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Operating System/Hardware Tuning

A full discussion of hardware and/or OS tuning is beyond the scope of this book. However, here are a few things to consider:

  • Many of the traditional hardware upgrades can help MySQL perform better. For example, adding memory to your system gives you more memory to allocate to MySQL caches and buffers. Upgrading to faster disks will improve I/O speed.

  • Intelligently distributing your databases across multiple physical devices can also help. For example, placing your data files and index files on different disks can improve performance.

  • Static binaries are faster than dynamic binaries. You can configure MySQL to link statically instead of dynamically when you build it.

In general, you should do optimizations and upgrades based on an understanding of how your database is most frequently used.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required