Record · corpus.blog/posts/01a0d08c-0553-7206-92e7-3dcd9e85d48a

Perf regressions in MySQL from 5.6.21 to 8.0.34 using sysbench and a small server

Small Datum · published 12 September 2023

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at smalldatum.blogspot.com Wayback capture

0blogs citing

First cited: —
Most recent: —
Rank this month: not ranked
External links: 27
Words captured: 1,091

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

https://bugs.mysql.com/bug.php?id=102037

bugs.mysql.com

https://twitter.com/MarkCallaghanDB/status/1700551813861449859

twitter.com

https://github.com/mdcallag/mytools/blob/master/bench/conf/nuc8i7.ub1804/my56/my.cnf.cy10a_bee

github.com

https://github.com/mdcallag/mytools/blob/master/bench/conf/nuc8i7.ub1804/my57/my.cnf.cy10a_bee

github.com

https://github.com/mdcallag/mytools/blob/master/bench/conf/nuc8i7.ub1804/my80/my.cnf.cy10a_bee

github.com

https://docs.google.com/spreadsheets/d/10C_MGdt6BMLKwvyRjx5au94CJiTwpj6VJJ0vBClJbjI/edit?usp=sharing

docs.google.com

https://docs.google.com/spreadsheets/d/10C_MGdt6BMLKwvyRjx5au94CJiTwpj6VJJ0vBClJbjI/edit

docs.google.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuv4LqzKSiG-Uv2dGnFEMq0IJYPAO-e4KjlB8bJvoRSL6Msla4mqU5ewKabQAsgQOJmhvKHUUvhCl0BNUfJDlisB4BujGIRQ1iIcuVU71ogXNO0t13sz9sp8sjsgy1-v167yos_tmfgtuVemcHAarBhrphL23Lsd_r5yfYPiZ7IB5I7zY64FPAx_rmqu8a/s600/point%20query,%20part%201_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpL-g-a-sQVY3junGKE-KpMRj6GZ_sfR2HVQjcC1bjbRqBWnlN7OAWwTw9bfLIUmM25HNRA-QX7K9yQT7IwhpgziQqWsbL6dOunWF8HecM060vJDHOpWGoGCmu99-bYkhOmSXpqszCgJoSAtoYisPJiZ-3oTh_Q8sdNL2HpNnls6z73I3vmyHIppRDLKDa/s600/point%20query,%20part%202_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxxkyErisemaVjO23h9i7pDmD7WThKtEyuVlvbIj5ZB6LPl9rMBHk8Q5zQHELyI_ybYgfOLQrjHYrt3ZlKmzgrHij5_p8jpoC25PDmba9x3JYoT6XK6HyqL5yug0C_BdwNsGLLg0z-NJ_coR8YJJOJ5FLZepOWEBFXVmsTDKcMUWjF5PZfB1auQXYHcw6K/s600/range%20query,%20part%201_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxT0u7uBfVA7IRAOdiEV0SQ7aoISCQ3LC75YqqusGkrLq596i5nYObTCW9i61AFFwzc8ppKkermyZZtiNfYXCIEqOoT23ncOeqegMisVBQxedvHZVvP7nmyYPOvfcoLs9RrvDre4HtcUwsCIDrt4OnoJOKg-KnWrZpYQK7oVrkyC08wjI4Az-G0jwSn2Nr/s600/range%20query,%20part%202_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEVo3X9dmYXFrxtS30lak83FDV7BvtVFSBuSo1a88L8Dwt_VrDwyIttx0hiADga1GU9OnfFHCxEakwuZTV28BK4EKodOC4UYzCD8cq95SY8O3_xTpOB1dQak9J8Aj-QrmmnIo1p6aaFA7S51bzXYazQfr5uGP82bgaz-DEsfhb0WZ6IOhFctcHkPA9u81m/s600/writes_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgq4_-xs_ICfwh-ZE9_ZbRJoU51eTpfF7Ji8mcTMUb_UHq2uOxofxrtI8AEH4uc4OlAvyyfECd18yL6Ide7kjXDyvvCBW-czFktUtgoMF5hi4O1GJADN-j6bQF3xwN4U2wc6BhMQHyHKIev3hF0joKAn_VNSexdALD73-KcGn5Nm9e6EXBAEtI_nY8TXebu/s600/point%20query,%20part%201_%20QPS%20relative%20to%208.0.13.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj86oNvdwfKUdUrr_RMBlCgyLxJqMZew3P0rCbatNtTWEcicqdYtflfG7pw-6ZoTpFMXEedtWguPP9Gve1jDw621r0aXITZhZDybEHbfaR_IjhpCdy59CY-UbryHRNm1l_-wP-G7LM2LZn_9VW_2DjVvRz1eqbZ_8cF-0jvQMTd42r7k39rguBFdM1habjU/s600/point%20query,%20part%202_%20QPS%20relative%20to%208.0.13.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDW-duijpa2xoDbCzyoEMbCAKtUc8xPVL-QbU2QkfoqvcU9NGzhhp4x58tq9dLUgOsQcSpUcml_ZotUDD4Ce6tNyXFU6AC8J_JQAaKuGYlsAPsVIQGRk8hzs3gt177y8KHcJdoakFiN3lBW3kapPwLZOOJ1a1dOmpLj6treVyeJluCKXTCCDynaLeNLf9p/s600/range%20query,%20part%201_%20QPS%20relative%20to%208.0.13.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRdUC07u4aPIueBGfwkFj0rG-0pAnX785mtxrtJeBU7tuBz4KTGuObLp-WC20xEQ-ZvS4P2q1FUX6RgKN3wpQeyvfXwCnxzviR4UOtFlrHP3pBBM-ntgyIFAVS_mYDneFXYiI3aVjVSyKEM5DskctRcxdMN_j1Ib9eutActmwKdBmN0gY1V0FJlVsEvG0D/s600/range%20query,%20part%202_%20QPS%20relative%20to%208.0.13.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy45-y0gdwuA8NeHWplfKeV-6SyQxKROHDH4W6UOPjb_gIxUxwBGU3wZmnjEb38P5cknEkY5Uz--yeArHxeS3CAjzoU_Cn5KWlxojPUdJVDt6h3Uq3FJVGWy9kLrw7xKBoyP90Od-Dg6r1uAHb3mok-zDsgQZ2dxKCIKiBeBYKtwuX59Vp3yhGjzDOv7Lg/s600/writes_%20QPS%20relative%20to%208.0.13.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9TC5TyjXQJukRCb48q8D2K9Ptd__W3UAahKFmYNtBC837anER3XTU3LetuSAH3bWSlnFtA4fd5ZoURC1LBih36GJDQsfeXuwEs79v1os9C--ZkSbNjfM8_luwLE25V28_DfSm5Yp6QyoYsAirb7JwdJ67N4bTrr5YLI-jKfpH6hK5ho9SjENRe6hSL2jP/s600/point%20query,%20part%201_%20QPS%20relative%20to%205.7.10.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivbGs-CyWslMrbzYzG3enueFwRXU1TyHIDWfdeUNYR9He3Fl9dj0cgFGGpHJ8-XYrc9Stu00MsPLJr92BkpeybiiXq775EQGiZ9iBGKwgZ4vw1nOT34p_TwQJNE9iKXmhrYmxUkW6qacc5lVabFHYp1pmK9NzZUxScHLkWM3OG9RXXwbaQ4ZrcOGOFfZQH/s600/point%20query,%20part%202_%20QPS%20relative%20to%205.7.10.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieGHbyqm0O9eUmvfcz054FPSSWVn_cu3zIEyGeA5oAx78iV8wQKRjvb0vkaDxtg1coN3KIjyV7QMI59NoXd3cynnQV5boukrewGE_YsA0h17PswaaH7EwObtxxUSe2xqQJ1M0-g1LEsxFd-WjOA5Q6VmN6Hf6HXJ6erefFx6E3kNOzqoM1UZqcJdZ6vPa_/s600/range%20query,%20part%201_%20QPS%20relative%20to%205.7.10.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMutwPN7-I-b9O00ywW8utdjvTuLN-XnlyvcojXTLNRCs_IM--8g6Hqp1mdnv49o8aFxre44mmKUGdM0KNEVxbbPH0rbCc1zAnp_6Z_T266_pYu0oq0E4gRDriUutA4h1poSR_vQqo92CQ89sj5MRUGfVevPbfkYduirWAMo7036RFqEYpzu790gbBpvat/s600/range%20query,%20part%202_%20QPS%20relative%20to%205.7.10.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRZEzcptdwV2WMc4GfOli-J0KPZg4pk2VFaNz2f4JWG14tcnC7HU_Rc-E9OSDJbkDaXp4lUgrGHou20bKOgZrZ6UKr7EvZ-ceVSta7SNgSm7MVZJWNu8XrSe6rz2AS4ldGTDyl_cpnEvlSvVyl8IU0R6nmEKstf5uVecBRYdKu8Hnkv_4JdoYs0ZNi5xgE/s600/writes_%20QPS%20relative%20to%205.7.10.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpuY50SOOS-jmHqvseZA_cRYqxddDZwH-98gzpigUt76-mBKl2yPKTYPkMgBh5iOCvhtQiYYFsq2DaJj7LJdujwGBTWxgLix5LAdt4-AlgOKEVP0q_kcaZGI1EuBHdjDOv3l0GuTJKAsdGBgDaSsmNUIbr3Xtjm0j5SY87AohMDw7mS2YK8ZjVgaPfeR-6/s600/point%20query,%20part%201_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIOhrCJ26eCFuXDa30r8JlrsJAsIXGslsS7Xx3pbSEkry6aLq8VtwWzM5AnCljzqvEW7RvkwcGG-p7QrTavSfXOmN65YjSnUkDj0fIr-lDgZqlB1z4J8Dtcy1frBaAHviaAsA0-lT51HR2CZxq0qfWbsp-JxmQDexfRrZcl7U6ixdVl9nekHaTZuQL2f-I/s673/point%20query,%20part%202_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo0vYuNeFZN81OYZeo-lxMxEH5B6PCwaZ14UdW0p9Xq90tW9ZiS4kHfKfHtG5hEMQWiMvQw7nbZGe8vrymYMHEVlPHfJ932V3k6Syek9q0w4x1JHdCXERABzksr82mKDI2T-kOJ5u37pg9I935jfqWDQWRbrAWfecdAFLSSrr-adPxsDTV7v6SF_cGLHGw/s600/range%20query,%20part%201_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMUXtyzhvOPPv7ljvppIB0yq5VsreaX61xjc_JM8ThDmpJIVyn06PqRaW4VpUt8PrYv3LJcuYECyfMCYjA8GBmXNn94WzgdH5NaqsaVtorSRsAjgDCEzDENEAiw5UeyZybC8ZsMMctMKI_nnjk2Ra2c4qFAydJSxte8pkd86S0g7z5_6jcD5hI1mac6Wmw/s600/range%20query,%20part%202_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigT833eGbzx-iDUk10WT3WNG8z0_mC75FuBIcYDJ8akQ3RtGiGyxXt1VBZD9pNBRAAAATh6o8uixT7jPyXjmCTq6jK8-B1-x85vc9le-HFlIKaoGii_-cmGewTuC-gKD5uwhcZb-vhn2uEc7yxG92e62y4EtddvC1VxeDfMZYB7bFTgyU67YOeb8bhhALa/s600/writes_%20QPS%20relative%20to%205.6.21.png

blogger.googleusercontent.com

Elsewhere on smalldatum.blogspot.com (9)

Perf regressions in MySQL/InnoDB, a big server & sysbench Read at the source ↗

smalldatum.blogspot.com

Searching for performance regressions in Postgres Read at the source ↗

smalldatum.blogspot.com

Revisiting perf regressions in Postgres, a larger server and sysbench Read at the source ↗

smalldatum.blogspot.com

Compiling MySQL 5.6 & 5.7 on Ubuntu 22.04 Read at the source ↗

smalldatum.blogspot.com

Compiling all MySQL 5.7 versions on modern Ubuntu Read at the source ↗

smalldatum.blogspot.com

Compiling all releases of MySQL 8.0 Read at the source ↗

smalldatum.blogspot.com

CMAKE_BUILD_TYPE: RelWithDebInfo vs Release for MySQL Read at the source ↗

smalldatum.blogspot.com

Using modern sysbench to compare MyRocks and InnoDB on a small server Read at the source ↗

smalldatum.blogspot.com

Small servers for performance testing, v4 Read at the source ↗

smalldatum.blogspot.com