Linux – IOPS write increased, Disk write latency decreased, Avg req size decreased – Page load speed decreased

hard driveiopslinuxperformance

I have noticed decrease in server performance (page load speed become lower), then I went to investigate and have found in munin graphs (which tracks server's resources) that there was big changes on disk IOPS, disk latency, MySQL queries quantity. It was happened without any changes by myself to system or to programs/websites code that runs on server.

What does it mean?
What trigger these changes?
How to fix?

More info about issue:
Order is by munin graphs sequence. Resource (approx. change in times to previous monitoring);

  1. Disk IOs per device (increased x10);
    enter link description here
  2. Average request size (decreased x2-4);
  3. Disk latency per device (avg. write IO wait time decreased x10);
    enter link description here
  4. MySQL queries (decreased x2);
    enter link description here
  5. CPU usage (increased x1.5);
    enter link description here
  6. Interrupts and context switches (increased x10).
    enter link description here

Thank you in advance for solving this out.

Best Answer

I was trying to find an answer and finally I've reached my point.

Solution was to change MySQL tmpdir parameter in my.cnf from /tmp/ (which is allocated on disk) to /dev/shm (this one is on RAM)

Because of 48.7% [Created_tmp_disk_tables / (Created_tmp_tables + Created_tmp_disk_tables) * 100] of all temporary tables are being written to disk and when tmpdir is allocated on disk, then IOPS increased.

Related Topic