Which three tasks can be performed by using the performance Schema?
A.
Finding queries that are not using indexes
B.
Finding rows that are locked by InnoDB
C.
Finding client connection attributes
D.
Finding the part of a code in which a single query is spending time
E.
Finding the size of each table
Explanation:
ABC
B,C,D
b, c, d
http://dev.mysql.com/doc/refman/5.6/en/performance-schema-table-index.html
why D？
I feel ABC too
Mee too
A, C, D
“A” is not true . if log_queries_not_using_indexes=ON and log_output=table . We could find queries that are not using indexes in mysql.slow_log .
Obviously, “E” is incorrect
A: true, `event_statements_{current,history{,_long}}` and other tables get this
select table_name from information_schema.columns
where column_name like ‘%no_index_used’
and table_schema like ‘perf%’;
B: false, those rows are in INFORMATION_SCHEMA.INNODB%
C: true, show tables from performance_schema like ‘%attrib%’;
D: true, that’s what performance_schema does
E: false, that’s in INFORMATION_SCHEMA