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
CUUG 优技培训
金牌讲师
实操环境
院校合作
学校新闻
行业新闻
请输入您的手机号
申请试听