多项选择题
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?（）
A.Table_open_cache
B.Table_open_cache_instancs
C.Table_definition_cache
D.Tmp_table_size
E.Max_heap_table_size
F.Max_tmp_tables
相关考题
-
多项选择题
Which three methods will show the storage engine for the Country table?（）
A.A
B.B
C.C
D.D
E.E -
多项选择题
Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?（）
A.FORCE_PLUS_PERMANENT is not valid for the audit-log option
B.The audit_log.so library does not exist
C.The audit_log.so library is in a location that is different from that defined by the plugin_dir option
D.The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
E.The audit log file does not exist in which to write audit events
F.The audit_log.so library is not an executable file -
单项选择题
You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）
A.All system users have access to the MySQL server via—login path local
B.login-path can be used only for MySQL servers running on a local machine
C.login-path allows you to provide login credentials without passing clear text passwords on the command line
D.When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
