![]() ![]() For the next 5 tests that are update-only.CPU/query overhead explains the change from My56 to My80 and write-amp (wKB/o) is much larger for MySQL than Postgres for the update-index test.CPU/query overhead explains the change from My56 to My80.The next 2 tests do range queries that are covering and not covering for the PK index.The next 2 tests are similar to the previous but use the secondary index.The next 2 tests do point queries via in-lists that are covering and not covering for the PK index.The next 3 tests have range scans from oltp_read_a with ranges of size 10, 100 & 10,000.CPU/query overhead explains the change from My56 to My80.For the first 4 tests that do point queries.MySQL 8.0 does worse than Postgres 13.1 for most tests because it uses more CPU/operation.MySQL 5.6 does better than Postgres 11.10 for most tests because it uses less CPU/operation.Context matters so be careful about projecting the conclusions here to your use case. The workload is in-memory & low-concurrency sysbench on a small server. I used MySQL 8.0.21 rather than 8.0.22 to avoid the impact from bug 102037. This post compares performance between MySQL 5.6.49 and Postgres 11.10 and then between MySQL 8.0.21 and Postgres 13.1 to document what has changed over the past 3 major versions: MySQL 5.6, 5.7, and 8.0 and then Postgres 11, 12 and 13. I also worry that Postgres is faster than MySQL for this workload gets truncated to Postgres is faster than MySQL when this post is discussed elsewhere. I hesitate to do direct comparisons because I like both DBMS and don't want to start pointless debates but I care about efficiency and hope that more is done to prevent regressions in MySQL going forward. This reuses the data from my previous posts ( here and here).įor this workload Postgres used to be slower than MySQL and now it is faster. I compare Postgres and MySQL using an in-memory and low-concurrency workload via sysbench. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |