将移动数据从EBS到临时存储改善MySQL查询的性能？ [英] Will moving data from EBS to ephemeral storage improve MySQL query performance?

问题描述

我使用EBS卷来存储MySQL数据。我也有短暂的设备有足够的空间为好。我将移动数据/根/，只要它会提高查询性能。

I am using EBS volume to store MySQL data. I do have enough space on ephemeral device as well. I will move the data to /root/, provided it will improve the query performance.

时的临时存储比EBS卷快？

Is ephemeral storage faster than EBS volumes?

推荐答案

大安的答案指向埃里克·哈蒙德的极好的总结已经全部EBS利益（+1），但要强调一点再次前期：

Daan's answer is pointing to Eric Hammond's excellent summary of all EBS benefits already (+1), but to stress one point again upfront:

短暂存储将在停止丢失/启动循环和一般可自行消失，所以你绝对不希望把持久的价值存在，即什么< STRONG>只是把临时数据那里你能承受的损失或重建轻松，如在计算过程中使用的一个交换文件或严格的临时数据。当然，你可以存储大量的索引那里的例子，但必须ppared重建这些$ P $后存储已被清除无论出于何种原因（例如重启，硬件故障，...）。

Ephemeral storage will be lost on stop/start cycles and can generally go away, so you definitely don't want to put anything of lasting value there, i.e. only put temporary data there you can afford to lose or rebuild easily, like a swap file or strictly temporary data in use during computations. Of course you might store huge indexes there for example, but must be prepared to rebuild these after the storage has been cleared for whatever reason (instance reboot, hardware failure, ...).

那么存储在临时存储MySQL数据库是不是摆在首位是个好主意，但如果你确切地知道自己在做什么，并ppared总是有时间点的备份$ P $等。

So storing a MySQL database on ephemeral storage isn't a good idea in the first place, except if you exactly know what you are doing and are prepared to always have point in time backups etc.

这是说，这确实属于服务器故障，并出现了要求颇有些类似或相关的问题，并已回答 - 我通常唐T链接到搜索结果，但实际上这里有帮助，请参见 EBS短暂的效果;我认为最相关的临时判决的答案是：

That said, this indeed belongs to Server Fault, and there have been quite some similar or related questions asked and answered already - I usually don't link to a search result, but that's actually helpful here, see ebs ephemeral performance; the answers I consider most relevant for an ad hoc judgement are:

• 埃里克·哈蒙德对 EC2实例微，EBS，I / O和速度。如何提高性能？​​
  • Eric是你应该使用EBS引导实例在Amazon EC2上的作者，其中包括许多一般在AWS上其他优秀的文章和EC2 / EBS尤其
  • Eric Hammond's on Ec2 micro instance, EBS, I/O and speed. How can I improve performance?
    • Eric is the author of You Should Use EBS Boot Instances on Amazon EC2, amongst many other excellent articles on AWS in general and EC2/EBS in particular
    • 链接，以进一步文章有关的话题

    这篇关于将移动数据从EBS到临时存储改善MySQL查询的性能？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！