How disk I/O is related with MySQL performance improvement. I have a MySQL-5.1.58 based Intranet application equipped with Windows 2008 server and 8 GB RAM. Even, When my application face performance hit, I see that theare are multiple instances (4-12) of mysqld in Disk I/O operation. These instances are basically using
MySql\MySQL Server 5.1\data\ibdata1 and
\MySql\MySQL Server 5.1\data\ib_logfile0 with
.MYD files of some tables in the selected database. Size of my ibdata1 file is 10.5GB and size of ib_logfile0 is 213MB. while logging is disabled in my system.
- Which system variables control this Disk I/O
- Which system variable should I check for Disk I/O during performance hit
- Why Disk I/O increases so much during performance hit
- Why these two files used by MySQL
- What is the role of Disk I/O in system performance. If yes, how can I achieve this?