Oracle
1Z0-888 · Question #15
1Z0-888 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Monitoring
Question
Consider these global status variables:
mysql> SELECT *
FROM performance_schema.global_status
WHERE VARIABLE_NAME LIKE '%connection%'
OR VARIABLE_NAME LIKE '%thread%';
+---------------------------------------+---------------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+---------------------------------------+---------------------+
| Connection_errors_accept | 0 |
| Connection_errors_internal | 6 |
| Connection_errors_max_connections | 0 |
| Connections_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap | 0 |
| Connections | 510 |
| Delayed_insert_threads | 0 |
| Max_used_connections | 145 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Slow_launch_threads | 0 |
| Threads_cached | 6 |
| Threads_connected | 140 |
| Threads_created | 155 |
| Threads_running | 14 |
+---------------------------------------+---------------------+
17 rows in set (0.00 sec)
Which two conclusions can be made from the output?
Options
- AThere are 140 Performance Schema threads at the time of the output.
- BThere are 510 connections to MySQL at the time of the output.
- CThe thread cache has been configured with thread_cache_size set to at least 6.
- DThere are more connections being idle than executing queries.
- EAll max_connections were in use at 2018-03-22 14:54:06
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Connection Management#Thread Monitoring#Status Variables#System Performance