Resource Utilization Analysis

Understanding the utilization of system resources is the key to effective analysis of MySQL performance. Hardware sets physical limits that cannot be overcome and even a well-designed query does not run efficiently if some resources are not available when it needs to run. Therefore knowledge of the extent of their use is required for a proper assessment of database performance.

What will be examined?

  • CPU utilization
  • Memory utilization
  • Disk I/O utilization
  • Swap activity