MySQL修改Undo表空间存储目录

最新推荐文章于 2023-01-09 18:24:16 发布

hbhe0316

最新推荐文章于 2023-01-09 18:24:16 发布

阅读量253

点赞数

文章标签： mysql python java 数据库大数据

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701182

版权

MySQL Undo表空间目录配置迁移

关键词由CSDN通过智能技术生成

1.查询源undo表空间目录

https://www.cndba.cn/hbhe0316/article/22723

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.停止MySQLhttps://www.cndba.cn/hbhe0316/article/22723

https://www.cndba.cn/hbhe0316/article/22723

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

3.创建新undo表空间目录

https://www.cndba.cn/hbhe0316/article/22723

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

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

https://www.cndba.cn/hbhe0316/article/22723

https://www.cndba.cn/hbhe0316/article/22723 https://www.cndba.cn/hbhe0316/article/22723 https://www.cndba.cn/hbhe0316/article/22723

5.修改undo表空间存储位置参数https://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表空间位置

https://www.cndba.cn/hbhe0316/article/22723

[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