Oracle
1Z0-888 · Question #42
1Z0-888 Question #42: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
Performance Tuning
Question
A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the reverts 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?
Options
- AYes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.
- BYes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in my.cnf.
- CNo. The UNDO tablespaces must remain on the same file system as the system tablespaces.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#UNDO tablespaces#innodb_undo_directory#Tablespace relocation#InnoDB configuration