网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题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?（）ATable_open_cacheBTable_open_cache_instancsCTable_definition_cacheDTmp_table_sizeEMax_heap_table_sizeFMax_tmp_tables” 相关考题
考题
多选题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）AFile system snapshotsBMysqldumpslowCMysqlhotcopyDMysqldump with – binary-data optionEMysql Enterprise Backup
考题
多选题What are three actions performed by the mysql_secure_installation tool?（）AIt prompts you to set the root user account passwordBIt checks whether file permissions are appropriate within datadirCIt asks to remove the test database, which is generated at installation timeDIt can delete any anonymous accountsEIt verifies that all users are configuration with the longer password hash
考题
单选题A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）A
It deletes all binary log files, except 'mysql-in.010'B
It deletes all binary log files up to and including 'mysql-bin.010'C
It deletes all binary log files before 'mysql-bin.010'D
It deletes all binary log files after 'mysql-bin.010'
考题
多选题Which three statements are true about memory buffer allocation by a MySQL Server?（）AGlobal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedBThread buffers are allocated when a client connects, and are freed when the client disconnectsCBuffers that are needed for certain operation are allocated when the operation starts, and freed when it endsDUser buffers are allocated at server startup and freed when the user is droppedEAll dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
考题
多选题Which three statements are characteristic of the MEMORY storage engine?（）AIt can support transactionsBTable contents are not saved if the server is restartedCIt cannot contain text or BLOB columnsDIt can support foreign keysEEach table is represented on disk as an.frm fileFEach table has a corresponding.MYI and .MYD file
考题
单选题Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?（）A
The attribute STATUS is set to the string EXTERNAL_AUTHB
The attribute PRIV_USER contains the usernameC
The event type that is given in the attribute NAME is EXTERNAL_AUTHD
There is no differentiation between native and external authentication eventsE
External authentication is managed through external auditing logsF
The PROXY_PRIV user shows a username if external authentication is used
考题
单选题A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）A
The Query Cache is pruning queries due to an increased number of requestsB
Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookupsC
Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded natureD
The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution
热门标签
最新试卷