Home / server / Questions / 302647
Accepted
pablo
Asked: 2011-08-19 08:59:45 +0800 CST

Measuring Performance through SHOW INNODB STATUS;

  • 772

When looking at the output of SHOW INNODB STATUS on mysql what are the most important values to be looking at, and what would be an indicator of poor performance?

Specifically under FILE I/O and BUFFER POOL AND MEMORY.

The DB server is:

High-CPU Medium Instance

1.7 GB of memory
5 EC2 Compute Units (2 virtual cores with 2.5 EC2 Compute Units each)
350 GB of instance storage
32-bit platform
I/O Performance: Moderate
API name: c1.medium

This is a follow up to this: Mysql InnoDB table size performance

performance mysql database innodb database-performance

1 Answers

  1. Best Answer

    Probably the most important value is "Buffer pool hit rate", it should be high enough. Next, you should check number of writes/sec and fsyncs/sec, number of fsyncs/sec should not be too high (if this number is lower than 1 it's OK, but this depends of implementation of your filesystem and/or underlying hardware, if you have a HW RAID w/BBU instructed to buffer fsync requests a high number of fsyncs won't affect performance much).

    • 1