多项选择题
A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
B.Execute the PURGE BINARY LOGE NOT USED command
C.Remove all of the binary log files that have a modification date earlier than today
D.Edit the .index file to remove the files you want to delete
E.Ensure that none of the attached slaves are using any of the binary logs you want to delete
单项选择题 You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment. You execute this command: $mysql_config_editor print –login-path=adamlocal What is the expected output of this command?()
单项选择题 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?()
多项选择题 Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()