Question 106
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)
Question 107
To query two system variables, you execute this statement and get the results shown:
When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?
When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?
Question 108
Which statement best describes the purpose of the InnoDB buffer pool?
Question 109
Given these table definitions and the explain plan:
Which ALTER TABLE statement will improve the performance of the query?
Which ALTER TABLE statement will improve the performance of the query?
Question 110
Which three allocate memory per thread in MySQL?