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

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.