1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ37

Performance

You are experiencing performance problems with MySQL instances that are monitored by MySQL Enterprise Monitor.

Using Query Analyzer, where should you start looking for problematic queries?

  • A Sort the “Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.
  • B Look for queries with low total latency times in the Latency section in the times series graph.
  • C Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
  • D Sort the “Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.
Explanation

A low Query Response Time index (QRTi) indicates poor query response performance. A QRTi of 0 means every execution exceeded the acceptable response-time threshold, and MySQL recommends beginning query optimization with the lowest-QRTi queries. Prioritizing these among frequently executed statements focuses attention on recurring performance problems.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!