网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）
A

The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

B

The table definition on the slave -litters from the master

C

Multi-threaded replication slaves can have temporary errors occurring for cross database updates

D

The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

参考答案

参考解析
解析： 暂无解析
更多 “单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）A The slave SQL thread does not have DELETE privileges to execute on test.t1 table.sB The table definition on the slave -litters from the masterC Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist” 相关考题
考题 多选题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
查看答案
考题 单选题Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A 12; only top-level statements and stored procedure events are loggedB 111; top-level statements and all lower-level statements are loggedC 3; only the top-level statements are loggedD 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
查看答案
考题 单选题Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （　） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）A Convert the column to TEXT and add a fulltext index to the tableB Create multiple prefix indexes of differing lengthsC Convert their column to BINARYD Redesign the table so that the most commonly searched for string patterns are in their own columns
查看答案
考题 单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A A syntax error will result as you cannot specify more than one partition in the same statementB All data in p1 and p3 partitions are removed and the table definition is changedC All data in p1 and p3 partitions are removed, but the table definition remains unchangedD Only the first partition (p1) will be dropped as only one can be dropped at any time
查看答案
考题 单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）A The slave SQL thread does not have DELETE privileges to execute on test.t1 table.sB The table definition on the slave -litters from the masterC Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
查看答案
考题 单选题You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）A STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVEB STOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVEC STOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVED STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
查看答案
热门标签
最新试卷