5.4. 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.
| | | 5.3. Database Server Tuning | | 6. Security |
Copyright © 2003 O'Reilly & Associates. All rights reserved.
|
|