Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

A MySQL server was initialized with separate UNDO tablespaces.

Oracle 1z0-888 Full Course Access
Oracle 1z0-888 View All Questions

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.

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

B.

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

C.

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

D.

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

1z0-888 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now 1z0-888 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
A master-slave replication setup has the slave showing this error:On the master server, the binary...
While attempting to set up a new replication slave on host ‘192.
Previous