Sample Header Ad - 728x90

Amazon RDS MySQL - write throughput limited to 15 MB / s

0 votes
0 answers
205 views
We are duplicating the data inside a rather Amazon RDS MySQL big table, about 2 GB of data. We are doing that by having batches of 30 entries moved at a time (INSERT INTO etc SELECT FROM ... LIMIT x OFFSET y). The script is working correctly. However, on my local machine with similar anonymized data took about 4 minutes. In RDS it seems to be taking hours. When investigating seems that RAM and processor are not under stress. However, the write seems to be limited at 15 MB / s. The volume is a gp2, that should have at least 128 MB / s. What else can cap that speed? Database Write Throughput
Asked by zozo (101 rep)
Jun 6, 2023, 11:22 AM
Last activity: Jun 6, 2023, 04:56 PM