Bug #102206 | Using double write buffer is 8x slower in SSD (compared with 2x~3x in HDD) | ||
---|---|---|---|
Submitted: | 10 Jan 2021 4:13 | Modified: | 14 Jan 2021 2:22 |
Reporter: | haochen he | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 8.0.22 | OS: | Ubuntu (20.10-Desktop) |
Assigned to: | CPU Architecture: | x86 | |
Tags: | performance, SSD |
[10 Jan 2021 4:13]
haochen he
[11 Jan 2021 15:10]
MySQL Verification Team
Hi Mr. he, Thank you for your bug report. It is to be expected that activating double-write will lead to the slowdown. But, we can not repeat the drastic slowdown on the Samsung SSDs, since we do not have those available to us ........ You could try contacting Samsung, or running normal disk benchmarking tools versus the SSDs of the other makes ....... In short, this is not our bug .......
[14 Jan 2021 2:22]
haochen he
Thanks for the reply. I will try then.
[14 Jan 2021 13:23]
MySQL Verification Team
You are welcome ..... You can try to copy very large file to SSD and from SSD to some other disk. You can also use `dd` program on Linux and try to fill the entire partition with, for example, simple letter 'a'. You can then try to read the entire partition to e.g. /dev/null. Measure all the times for different SSDs.