我正在使用以下命令将 csv 文件导入到 mysql 数据库中的表中加载数据到文件中命令。 csv 文件相当大(大约 10 Gig)。在导入过程中,我收到以下错误:
撤消日志错误:系统表空间中没有剩余空间用于分配撤消日志页。请向表空间添加新的数据文件或检查文件系统是否已满或为表空间启用自动扩展
这个错误是做什么用的?
The MySQL system comes with a way to rollback changes using this "UNDO log file". It's also used for coherency. With large datasets, that log file may grow too fast and be filled up. Then you get that error. The idea is to be able to undo the last command. This is similar to going in a paint system, for example, making changes to an image and then clicking Ctrl-Z. That's what the UNDO log file is there for.
为了避免表运行,您可以将其标记为非活动状态:
ALTER UNDO TABLESPACE tablespace_name SET INACTIVE;
您还可以完全删除该表(不推荐)或允许自动截断,这可能会很慢。自动截断确保删除数据按要求.
欲了解更多信息,您可以see here https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)