我正在尝试设置一个MySQL副本服务器,但是,由于数据库的大小相当大,所以我使用xtrabackup。server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/tmp/mysql.sock/undo003.ibu'.
Using undo tablespace './undo<
define variable mysql-db as character no-undo.define variable mysql-port as integer no-undo.define variable mysql-user as character no-undo.define variable err-msg as character no-undo.
define variable mysql_err as mempt
MySQL撤销日志不断增长到180 g,没有回滚记录,我只是不知道原因。据我所知,当到达设置为innodb_max_undo_log_size的1GB时,它将自动截断。有什么好的解决办法吗?INFORMATION_SCHEMA.INNODB_TABLESPACES ORDER BY file_size DESC LIMIT 1;|innodb_undo重启MySQL服务会减少撤消日志大小吗?请帮帮忙。