1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ195

Performance

You need to determine the number of rows examined for queries that have finished.

All relevant configurations are enabled to record this information.

Which two sources contain the number of examined rows?

Choose two
  • A the slow query log
  • B the error log
  • C the Performance Schema
  • D the Information Schema
  • E the general query log
Explanation

The slow query log includes a Rows_examined field for each logged statement. Performance Schema statement-history tables retain completed statement events and expose ROWS_EXAMINED, the number of rows examined by the server layer. Completed-query data is therefore available from these two sources when the applicable logging and instrumentation are enabled.

Learn more

Community Discussion

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