Summer Special Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: vce65

A MySQL server was initialized with separate UNDO tablespaces.

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.

Oracle 1z0-888 Summary

  • Vendor: Oracle
  • Product: 1z0-888
  • Update on: Jul 26, 2025
  • Questions: 124
Price: $52.5  $149.99
Buy Now 1z0-888 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method