1Z0-908: MySQL 8.0 Database AdministratorDemo

Question

Review these two reports collected 100 seconds apart:

GLOBAL STATUS 1:

Question Image

GLOBAL STATUS 2:

Question Image

Your MySQL system normally supports 50–75 concurrent connections.

Which configuration change would improve performance?

A increase table_open_cache
B increase max_connections
C decrease table_definition_cache
D decrease open_files_limit

Explanation

Opened_tables increases by 3,500 in 100 seconds while Open_tables is at 1,024, indicating frequent table-cache churn. A rapidly increasing Opened_tables value means the table_open_cache is likely too small; increasing it can reduce repeated table opens and improve performance. The observed connection usage does not demonstrate a need to raise max_connections.

Learn more

1Z0-908: MySQL 8.0 Database AdministratorDemo

AstroTutor

Notes

Readiness

QuestionQ189

Community Discussion