1.查询源undo表空间目录

mysql> show variables like 'innodb_undo%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| innodb_undo_directory    | ./    |
| innodb_undo_log_truncate | OFF   |
| innodb_undo_logs         | 128   |
| innodb_undo_tablespaces  | 0     |
+--------------------------+-------+
4 rows in set (0.00 sec)

2.停止MySQL

[root@mysql57 ~]# service mysqld stop
Shutting down MySQL... SUCCESS!

3.创建新undo表空间目录http://www.cndba.cn/hbhe0316/article/22723

[root@mysql57 ~]# mkdir /data/undo
[root@mysql57 ~]# chown -R mysql.mysql /data/undo/

4.移动undo表空间到新目录下

5.修改undo表空间存储位置参数http://www.cndba.cn/hbhe0316/article/22723http://www.cndba.cn/hbhe0316/article/22723

[root@mysql57 data]# cat /etc/my.cnf | grep -i "innodb_undo_directory"
innodb_undo_directory = ./undo

6.启动MySQL再次查询undo表空间位置

[root@mysql57 ~]# service mysqld start
Starting MySQL... SUCCESS! 
[root@mysql57 ~]# mysql -uroot -pwwwwww -S /mysql/mysql.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 2
Server version: 5.7.36-log MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.

mysql> show variables like 'innodb_undo%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| innodb_undo_directory    | ./undo |
| innodb_undo_log_truncate | OFF    |
| innodb_undo_logs         | 128    |
| innodb_undo_tablespaces  | 0      |
+--------------------------+--------+
4 rows in set (0.00 sec)

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

MYSQL