首页 试题详情
单选题


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?

Atotal memory used by connection number 10

Btotal memory used across all connections associated with the user on connection number 10

Ctotal memory used by the first 10 threads

Dtotal memory used by thread number 10

Etotal memory used across all connections associated with the user on thread number 10

Ftotal memory used by the first 10 connections

正确答案:A (备注:此答案有误)

相似试题

  • 判断题

    Employers often choose the best candidate.

    答案解析

  • 单选题

    [音频]Listen to the dialogue and choose the best answer to the question you hear.( )

    答案解析

  • 单选题

    Choose the best answer.Which statement is true about InnoDB persistent index statistics?

    答案解析

  • 单选题

    Choose the best answer.How can mysqld_multi be configured to allow MySQL instances to use the same port number?

    答案解析

  • 单选题

    Choose the best answer.Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

    答案解析

热门题库