Comments on: Using AWS EC2 instance store vs EBS for MySQL: how to increase performance and decrease cost https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/ Fri, 15 Dec 2023 20:54:26 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Nils https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969616 Wed, 29 Aug 2018 10:14:56 +0000 https://www.percona.com/blog/?p=51664#comment-10969616 I have prepared a larger answer on the AWS forums but currently can’t post there. Here’s the gist: Since the local instance store devices are partitioned, you’ll only get a fraction of the throughput of a full device. On a c5d.9xlarge this will be a little less than 1600mb/s. The numbers you see are normal since you only get a slice of that full 900 GiB Device. You however get all the latency benefits.

]]> By: Nils https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969615 Wed, 29 Aug 2018 09:46:48 +0000 https://www.percona.com/blog/?p=51664#comment-10969615 That is quite surprising since ZFS doesn’t allow direct I/O (unless using a ZVOL). Anecdotally, having used ZFS on my workstation for quite a while, it seems any fsync() heavy workload – dpkg being a prime example – is significantly slower.

]]> By: Mark Callaghan https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969607 Mon, 27 Aug 2018 14:43:52 +0000 https://www.percona.com/blog/?p=51664#comment-10969607 Does anyone publish numbers on QoS — p99 response times, stall frequency?

]]> By: Joel Williams https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969583 Tue, 21 Aug 2018 16:02:41 +0000 https://www.percona.com/blog/?p=51664#comment-10969583 I see now where you define how you’re measuring these drops.

]]> By: Joel Williams https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969582 Tue, 21 Aug 2018 16:00:52 +0000 https://www.percona.com/blog/?p=51664#comment-10969582 “hitting such failure events can be common.”

I’m wondering what your definition of ‘common’ is…this seems a tad bit open-ended.

]]> By: Kuba https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969580 Tue, 21 Aug 2018 11:11:58 +0000 https://www.percona.com/blog/?p=51664#comment-10969580 How did you configure the OS to mount the nvme volume and get the expected characteristics?
I’m getting the same performance from nvme as from EBS, What has to be done? I’ve actually asked that already on EC2 group but no answer yet. https://forums.aws.amazon.com/thread.jspa?threadID=287515&tstart=0
Could you share that detail?

]]> By: Jonathan Levin https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969578 Tue, 21 Aug 2018 08:06:18 +0000 https://www.percona.com/blog/?p=51664#comment-10969578 Surprised you didn’t include Tokudb as one of the compression options. As it’s owned by Percona

]]> By: Nils https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969576 Mon, 20 Aug 2018 15:58:40 +0000 https://www.percona.com/blog/?p=51664#comment-10969576 FWIW, I have also seen I/O delay spikes on i3 type instances. It may be that the NVMe devices are doing some housekeeping every once in a while, but Amazon is pretty opaque when it comes to questions about their infrastructure so I haven’t gotten any real help from their support.

]]> By: Alexander Rubin https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969575 Mon, 20 Aug 2018 13:39:10 +0000 https://www.percona.com/blog/?p=51664#comment-10969575 From what I saw so far from that case (very limited test) both writes and selects are actually faster on ZFS compared to EXT4. But it needs to be further tested.

]]> By: Andrea Falco https://www.percona.com/blog/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/#comment-10969574 Mon, 20 Aug 2018 12:42:52 +0000 https://www.percona.com/blog/?p=51664#comment-10969574 How compression (InnoDB row, InnoDB page and ZFS respectively) affect query performance (INSERT, SELECT, etc.) on i3.4x instance?

]]>