索引操作究竟发生了什么?

问题描述

我今天正在索引一个巨大的表，其中包含20亿条记录.我以为MySQL会吞噬我的2TB驱动器...磁盘消耗一直增加到400GB，然后增加到500GB，最后下降到180GB，MySQL说成功添加了索引.为什么空间增加了，到底发生了什么?有人可以给我一些指示吗?

I was indexing a huge table today containing 2 billion records. I thought MySQL would eat away my 2TB drive... The disk consumption kept increasing to 400GB and then 500GB and then finally drops to 180GB and MySQL says successfully added the index. Why the space increase and what happened in the end? Can someone please give me some pointers?

推荐答案

昨天我偶然地回答了，下面是我的研究:

Incidentally yesterday I answered a question on how to make index creation faster in MySQL, and the following came out from my research:

来源:快速概述索引创建

这篇关于索引操作究竟发生了什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！