多项选择题
Which two are correct steps in taking a binary backup of MyISAM tables?（）
A.Always stop the server prior to the backup
B.Stop the server or lock the tables prior to the backup
C.Stop the server or lock the databases prior to the backup
D.Make a copy of the .frm, .myd, and the .myi files
E.Make a copy of the binary log and tablespace files
相关考题
-
单项选择题
Which statement is true about FLUSH LOGS command?（）
A.It requires the RELOAD, FILE, and DROP privileges
B.It closes and reopens all log files
C.It closes and sends binary log files to slave servers
D.It flushes dirty pages in the buffer pool to the REDO logs -
单项选择题
Identify a performance impact when using the Performance Schema.（）
A.There is no impact on performance
B.The overhead depends on the settings of the Performance Schema
C.There is an overhead for querying the Performance Schema but not for having it enabled
D.There is a constant overhead regardless of settings and workload -
单项选择题
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）
A.A
B.B
C.C
D.D
