Measuring Performance through SHOW INNODB STATUS;

view story

http://serverfault.com – 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 (HowTos)