Skip to main content

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.

More lessons in MySQL Performance Tuning