41.1. Choosing Hardware for MySQL Use


MySQL can benefit from improvements to several subsystems of your hardware configuration. The following list describes the significant factors, with the most important ones first:

  • Add more memory to allow larger buffers to be used. This improves caching so that disk activity can be minimized. The performance effect can be considerable because it's much faster to read information from memory than from disk. Adding memory also can reduce the amount of swapping the operating system needs to do.

  • Maximize on-board processing power:

    • Use a 64-bit CPU rather than a 32-bit CPU. A 64-bit CPU allows certain mathematical (and other) functions to complete faster. It also allows MySQL to support larger internal cache sizes.

    • Use a multiprocessor system. If MySQL uses kernel threads, it can take advantage of multiple processors.

    • A faster main logic board (motherboard) improves general system throughput.

  • Use a faster network, so that the server can transfer information to clients faster. This lets the server process queries faster, reducing resource contention.

  • Choose disks with better performance.

Network and disk issues to consider are discussed in more detail later in the chapter.



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net