my table size is about 9GB and I have 4GBs left of space
我的表大小约为9GB，剩下4GB的空间
When changing the table engine, the table is copied to a temp engine.
更改表引擎时，表将复制到临时引擎。
Would this process work if I'm low on space?
如果我的空间不足，这个过程会起作用吗？
1 个解决方案
#1
0
As far as I know, the temp table created during alter table is kept in the same location as the original file ( usually /var/lib/mysql/{db_name}/{table_name.XXX} ). And for the same reason the alter table should fail with out of disk error( error code: 28).
据我所知，alter table中创建的临时表与原始文件保持在同一位置（通常为/var/lib/mysql/{db_name}/{table_name.XXX}）。并且出于同样的原因，alter table应该因磁盘错误而失败（错误代码：28）。
#1
0
As far as I know, the temp table created during alter table is kept in the same location as the original file ( usually /var/lib/mysql/{db_name}/{table_name.XXX} ). And for the same reason the alter table should fail with out of disk error( error code: 28).
据我所知，alter table中创建的临时表与原始文件保持在同一位置（通常为/var/lib/mysql/{db_name}/{table_name.XXX}）。并且出于同样的原因，alter table应该因磁盘错误而失败（错误代码：28）。