What Limits MySQL’s Performance?How to Select CPUs for MySQLWhich Is Better: Fast CPUs or Many CPUs?CPU ArchitectureScaling to Many CPUs and CoresBalancing Memory and Disk ResourcesRandom Versus Sequential I/OCaching, Reads, and WritesWhat’s Your Working Set?The working set and the cache unitFinding an Effective Memory-to-Disk RatioChoosing Hard DisksChoosing Hardware for a SlaveRAID Performance OptimizationRAID Failure, Recovery, and MonitoringBalancing Hardware RAID and Software RAIDRAID Configuration and CachingThe RAID stripe chunk sizeThe RAID cacheStorage Area Networks and Network-Attached StorageStorage Area NetworksNetwork-Attached StorageUsing Multiple Disk VolumesNetwork ConfigurationChoosing an Operating SystemChoosing a FilesystemThreadingSwappingOperating System StatusHow to Read vmstat OutputHow to Read iostat OutputA CPU-Bound MachineAn I/O-Bound MachineA Swapping MachineAn Idle Machine