1Z0-888 Exam Dumps | A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back

Valid 1Z0-888 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-888 Exam! ExamDiscuss.com now offer the newest 1Z0-888 exam dumps, the ExamDiscuss.com 1Z0-888 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-888 dumps with Test Engine here:

Access 1Z0-888 Dumps Premium Version
(155 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 2/15

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

B. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

C. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

D. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

Question 2/15

LEAVE A REPLY

Download PDF File