Question 136
Multiversion Concurrency Control (MVCC) enables what type of backup?
Question 137
Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?
Question 138
Consider the key buffer in a MySQL server. Which two statements are true about this feature?
Question 139
Consider:
Which statement best describes the meaning of the values in the ref columns?
Which statement best describes the meaning of the values in the ref columns?
Question 140
Examine the mydatatable and SELECTstatements:
You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?
You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?