3
AWS Tutorial 5 - Aurora RDS Issues
source link: https://fuzzyblog.io/blog/aws/2016/08/29/aws-tutorial-5-aurora-rds-issues.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
AWS Tutorial 5 - Aurora RDS Issues
Aug 29, 2016
So I took the time to reload the data I described yesterday, that we had fed into Aurora RDS, into a local MariaDB installation and I also eliminated split/cat from the equation by just using a file that had come straight from a mysql dump via an aws s3 sync operation and the results are disturbing:
Source db (vanilla mysql on our own hardware)
mysql> select count(*) from a_big_table;
+----------+
| count(*) |
+----------+
| 2137447 |
+----------+
MariaDB on our own box
MariaDB [banks_production]> select count(*) from a_big_table;
+----------+
| count(*) |
+----------+
| 2137447 |
+----------+
RDS (from loading same file):
select count(*) from a_big_table;
+----------+
| count(*) |
+----------+
| 797121 |
+----------+
1 row in set (0.00 sec)
That's not encouraging at all.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK