Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第24题

admin

Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第24题

本套题库是Mysql 8.0 OCP考试试题，由CUUG整理，如有报考OCP认证意向，可以联系cuug咨询老师。

24、

Choose the best answer.

Examine this partial report:

mysql> SHOW FULL PROCESSLIST;

Examine this query:

SELECT SUM (m.CURRENT_NUMBER_OF_BYTES_USED) AS TOTAL

FROM performance_schema.memory_summary_by_thread by_event_name m

INNER JOIN performance_schema.threads t

ON m.THREAD_ID = t.THREAD_ID

WHERE t.PROCESSLIST_ID = 10;

What information does this query provide?

A) total memory used by connection number 10

B) total memory used across all connections associated with the user on connection number 10

C) total memory used by the first 10 threads

D) total memory used by thread number 10

E) total memory used across all connections associated with the user on thread number 10

F) total memory used by the first 10 connections