Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

Many Thanks...

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.