Connections, Threads & Disk I/O
Learn Connections, Threads & Disk I/O (MySQL Performance Tuning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Each client connection uses a server thread and memory; the disk subsystem handles page flushes and redo/binlog writes. Tuning these three limits how much concurrency the server sustains.