单项选择题

You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）

A.Include-master-info
B.Master-binlog
C.Include-log-file
D.Master-data

点击查看答案

上一题目录下一题

相关考题

单项选择题

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）

A.— quick
B.— skip-buffer
C.— single-transaction
D.— tab

多项选择题

Which three tasks can be performed by using the performance Schema?（）

A.Finding queries that are not using indexes
B.Finding rows that are locked by InnoDB
C.Finding client connection attributes
D.Finding the part of a code in which a single query is spending time
E.Finding the size of each table

多项选择题

Which three statements are true about memory buffer allocation by a MySQL Server?（）

A.Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed
B.Thread buffers are allocated when a client connects, and are freed when the client disconnects
C.Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends
D.User buffers are allocated at server startup and freed when the user is dropped
E.All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed

You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）

相关考题

You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）