A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
您可能感兴趣的试卷
你可能感兴趣的试题
A.Tables with BLOB and TEXT columns cannot be partitioned
B.Partitioning allows easier management of smaller data sets for certain queries
C.Partitioning allows different columns to be stored in separate files
D.The partitioning expression is an integer or function that returns an integer value or NULL value
E.Partitioning is only available for those storage engines that implements it natively
A.RAID 5
B.iSCSI
C.SAN (Storage Area Network)
D.NFS (Networked File System)
A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup?()
A.Disabling connections from named pipes or socket files (depending on the operating system of the server)
B.Enabling and using SSL for connections to the Mysql database
C.Installing Mysql on the application server, and running the database and application on the same server
D.Starting the server with – bind- address=0.0.0.0 specified
E.Running the server with – skip-networking specified
F.Limiting logins to originate from the application server or the server's subnet'
The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?()
A.A primary key must exist for creation of a clustered index
B.A clustered index allows fulltext searching within InnoDB
C.The first unique index is always used as a clustered index and not a primary key
D.A clustered index provides direct access to a page containing row data
E.If no indexes exist, a hidden clustered index is generated based on row IDs
F.A primary key is used as a clustered index
G.A clustered index is a grouping of indexes from different tables into a global index for faster searching
A.Execution of the FLUSH LOGS statement
B.Starting of the SQL thread
C.Reaching the slave_pendign _jobs_size_max limit
D.Execution of FULSH TABLES WITH READ LOCK
E.Starting of the I/O thread
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.
Some details are as follows:
The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query:
SELECT TABLE_SCHEMA, 'ENGINE', COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= 'BASE TABLE' GROUP BY TABLE_SCHEMA, 'ENGINE' ;
Why is this query slow to execute?()
A.Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables
B.Aggregating details from various storage engine caches for the final output is time consuming
C.Collecting information requires various disk-level operations and is time consuming
D.Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming
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
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
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 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 replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()
Which two statements are true about setting the per-thread buffers higher than required?()
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.Which two changes would ensure that the temporary table does not propagate to the slave?()
A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true()。
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?()
What are three facts about backups with mysqldump?()
MySQL is installed on a Linux server and has the following configuration:What is the purpose of changing ownership of datadir to the ‘mysql’ user?()
Which three data components are needed for point-in-time recovery?()
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?()