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?
MySQL服务器使用单独的UNDO表空间初始化。用户抱怨说，当他们回滚事务时，处理请求的时间太长。DBA希望将MySQL InnoDB UNDO表空间移至固态驱动器（SSD），以获得更好的性能。这有可能吗？怎么做？
A. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.
可以，关闭mysqld进程，启用transportable_tablespace选项，并将UNDO目录移动到SSD。
B. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.
可以。关机，将UNDO表空间复制到新位置，然后更改my.cnf中的innodb_undo_directory值。
C. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.
不可以，UNDO表空间必须与系统表空间保留在同一文件系统上。
D. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.
不可以，现代SSD块设备不支持UNDO表空间的顺序写入模式
Answer: Bhttp://www.cndba.cn/hbhe0316/article/22801

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL