Record · corpus.blog/posts/01a0d08b-0427-7258-8583-a59a2dba9926

Sysbench on a (less) small server: MariaDB and MySQL

Small Datum · published 12 April 2024

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: 42
Words captured: 2,303

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

https://nyrkio.com/

nyrkio.com

https://smalldatum.github.io/

smalldatum.github.io

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

twitter.com

https://github.com/mdcallag/mytools/tree/master/bench/conf/arc/apr24.maria.ser4

github.com

https://github.com/mdcallag/mytools/tree/master/bench/conf/arc/apr24.maria.ser7

github.com

https://docs.google.com/spreadsheets/d/16yIzXKIjkWmAHNFN0J31P-oZEJhNKfXd_ihrT5Lsd9Q/edit?usp=sharing

docs.google.com

https://docs.google.com/spreadsheets/d/1fhWiO3XRBhK_pkYsfUdXxbEbYf2yUuE8Jxrn6ErSv4o/edit?usp=sharing

docs.google.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGz-sT2YFucFscH-R0EO7SGgR0cWOeTSYvmMF5EZxpFHA97t9vWFyXahHk9pbTbgBCvFE7ulsPxyg144NGFRkqg3WtOYrxAogSUzoo7qRFmouOyML9lq_Q3GnYu-W0pMUwNfF9l5gh1UqU-BQKdo0vNYkJkrMu7lx6itvUEYEqy0QlLVJZso77YTEbLwJn/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20point%20queries,%20part%201.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0JtXGhKstFNlkkflBBEcom7HsG9IYkZROpeEOTbzMWz218G0jHrmlcKYaSa_jwHiIZIeabwp5GgUicugMZmSZj8D8GZGYte5t82epxr3ilp3VMUdRtRInjJ0vIKF5c7Bh4tKJQF8ReVRxh-_n0MjiNb0t72PVDtJzwVyVt9RYiwGsgIUpk4RTbB6M2RBW/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20point%20queries,%20part%201%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEV1aTZs7NTgBk7n01cnr69Rk6EORlzaz74v8-swIp1ZacUnntkzp5HBbjISAckPe9jc6owPjaJhu3HBGw3qD13XNXPZ4Wya6xScKqwz1xFbPJoK5a673xFsiWlCjWmaZQn2SOV7F-mpnW8nNvChb9yq3mkgMpvpZIeaQMNcuejfitCVjti5WU5mMjVkR6/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20point%20queries,%20part%202.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih7h47UO2843HKMdrLldFbmdz4bOOdUM5sANUzXEhbnJ7OVUBG4DuG1Ath6Sv0VLwK9E55UYuo1jNRwSwiZxftxyFosc9R59ClcCn29OhHZUhtDlbjA4sWrJ6qSk1wpuk46n2M6iVRL_mfLui61JbosWdNPpmucGKQ0bqYGY61r1qmVvgg1zU13B-ZwuiT/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20point%20queries,%20part%202%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga80iiS9IE2fBRI7iVISdImNQtTOp2E6kK1yQ3-4TYjIQY2KjkJu_65aZRUNHqvzvgveOrXDpZxttxk4VwMAMGh67woHjkg_Tuu3PFYadlO9QhqfFSbs54D6Urvaqzc7LB3h3nscWU4jwwxL4g9IOroacLeYVU0dUKU2acO2zscBYEyfkN4w4e3ReUz3ZC/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20range%20queries,%20part%201.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh28vEZSsnYKP47VFMjJT8HxloWeEEvkQbmSdPFUDYuGCGbBTGH562rxCP6SSYE8dTxRYbL5hRs1yuKLW6SpGAfGm_oGNqrT5LK99IP-dSZqe5FwwcYBK1xnfmV_4QwAkZdLKXr0GTVsDv0YdgwbccNEofAxksLwyRT-XwoGESDC5_zXXrkUINzPP40nCw/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20range%20queries,%20part%201%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHbTiDHw3zeuAhWL6tuTqUm9-Si1XC_cziuFt4bIG5-JSudCdXkvDbKd8_ZLCVDYSI3pifedCn0kpuoKmbi6rsOhWnSCFh0-FZB_GFcV3BWBjAoeseb9C9E0Mdiv2lDcNBgBUYE5zsfzJlGnnu4SADTilzOVS3SqIXk5LABpEHteAEnyqO2w-yNGMh-r0p/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20range%20queries,%20part%202.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaQ9TQOAUdmZ0N77FvCbUGvMCNZjJyBWfpB8f1RESodlbPRWBtM0BcjYlWaC6RVGzoZ-GIwy_HRx3_QxMJdwPeEYNfGp5biRA8sVAIW1EiYeEYkb1bbKG8nWVORr70ZiN-NbPg5UZWS3uAzKGuYAq152NTVpLgjMghdIHgPKM6cMyu1esBzuzZh8J9r83E/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20range%20queries,%20part%202%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiTTdIrNzbIAH5rDv33GEcOStfjrFsnNPS1hnQoU-e2E5R9wu3mC1ZbntG1l3VBRd4Y3-vhpjtExeJ8wN6OEptCDrRTQZl5SD1GhQ-PZYlKYxl1xQPO2Sjauh6RgkXaO_-qHTirG4-TtH6gLGiDC8bWtz5Sl9ixDxjaPCgT8y-OyjshL9sHF1oqXs5gmZD/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20writes.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgrFe9zQ7mtvjoPOPftg1gJoWYqWYBvods3eaaJK1rcBZckWQggomqXY7CxatBG4ggUQ487abcxIZ-fCrdO__I0Jtj35huX3rAxCm9agVjsEHlxXz0kA_Kijfrx9FGQUAGdUK-9n0pb3JXbAvIqROU_HYJHqrsp3ehIEKehP_EnP3hHy6sF5gdRWZB9cmz/s600/QPS%20relative%20to%20MariaDB%2010.2.44_%20writes%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyBKND40dyq6W4LN_ujnvmfY_ICRHS_H6nZ5AZ2T70pAuMLpcLBfjY4PowG7vzWXJJixqoI8UEkRLCSxrWcmRvhMMC9iiKsqYa_ITUF4ISoQtZRUoILRUmE_Gm8Rp0-CP0NJaVUM_oT0G7jzYMuEErp3LKr68p9T_fG2qH8bsZPtM4yp8K6Ifs_Achig7U/s600/QPS%20relative%20to%20MySQL%205.6.51_%20point%20queries,%20part%201.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwJRC8A895OKeMp2NHCVOChZ53I9ml5Svn4KYp4ihSeH4nia3cxxmA1UIF_JJZSQkjb2p_kBjrl93G_m1VvIpvR8qBpBUgFB6MHAhlbWS4OQrlfGBfSI9Q5x2PWLJ1ak1mbmn3IBHrjDnbbgAnWFFFzWoJG34R14DYpEsGX4OUxhAbsbGZKvAnKn0FgY-s/s600/QPS%20relative%20to%20MySQL%205.6.51_%20point%20queries,%20part%201%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2DOHFfchUjvyzqJ113nNz9m5rPyoFvmWHfWMOrYJBBfLw8NXQs8MXbkk5_h_OJka4ELZGb0-J4pVhTAqc2BA1nC_nyZ8zoRMCgLDSL1TyuH_l7ThtwJIpsuRuXNSFXU-Q0RCsafBblFGt5WjcRaCjJX-a56xf6xgc9igUUh_OKqmsXY6hyphenhyphenayWKmr0RSFj/s600/QPS%20relative%20to%20MySQL%205.6.51_%20point%20queries,%20part%202.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3kKj2aPJrEwGCeWHtTievSRj3qw_U6Pqrv3PrdUJ3J81XhdrndtRm0j4kseARHyMRZHZjmYesrhzc2oa_75VlHSyFl8LjCdhbcU77GcW-euByPgmBDgZ0FRz11GqHxu42isVC-g9beLme1cvHaDdmcIcr1tyW1YF7BqkgZ04UYDZ-DHxhbbV3QEKai20o/s600/QPS%20relative%20to%20MySQL%205.6.51_%20point%20queries,%20part%202%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiu-BPMVDtdpRdQ9DyreyUCzRqkEQBlQpSOUoCCJ1NXNsATDUDiK42_QrsmDJbXH8REnx8zG8WecRregl-vxzEvjRjiKFw01VpsLjis8veztVo2RWq71sMqIUgt3_oTGha3uC-RJE5b4RudwKUO563spLTWY23HwwwAhHRg1YlqNbSYbkZsGzl9Nbf33t10/s600/QPS%20relative%20to%20MySQL%205.6.51_%20range%20queries,%20part%201%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIKdMVe1xn6VWsbzPnrdjDWcLTudslVaUqkJU4oQKYgcfpxXtbeGNUvTTYXSEImAGBuvKA-JtKxayR_muRp2c8ciBn9lPW5hVOUW18bX859MsXHBI45jrmVsW8Wif29G-gyCdvwvXLb-OZB9tepJj9MASXLe0W_wMhZdbu_gz-4wIlrTnlRk_mg2EiCOxI/s600/QPS%20relative%20to%20MySQL%205.6.51_%20range%20queries,%20part%201.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmeWE4JiKsaf915ObRR-snyxwkw4fpp12lKT7Y5_oevJnBXo2wxK8fbNUj1SFpPPEftAeCDWntn3K_rnxyCP0RQ51S_OWcscgmhdtzfHSTXoij9tsHXIwq4v9LIc_HrAxtmW_P21xCs7d-CFE4TKKtzxNwMsa9USOF2sY_3ffzIM2ZVmir9vqFPvRlpKjn/s600/QPS%20relative%20to%20MySQL%205.6.51_%20range%20queries,%20part%202.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYM-33uY1odz2mjNX77ZAS5AKoTeR5Nc8IICqTvKv5a2nuFuTsGHXjNfXnrWjb8zODpSKWt1g_Fcz0G9WlFhzqs00QjK6bcDD8M0aq6tm0tNqowHwqyC3JpSSQTbhD-tsnLv7UbV4ru-UHltihQV_C_btc47niLboc-0z9HsBipxEoshnw9iyeW2VkU5ue/s600/QPS%20relative%20to%20MySQL%205.6.51_%20range%20queries,%20part%202%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikZPKqEvgODI1UAWDgRhXO6VzjuhQmt-ov7XJQRwqEqiX0mGHeVaQf8gltLKS5G8gyJb-RpdUtEu3-5Cecl2Qe-A1i-gwQOBno2M_4-yUxORxgEAJdCGprhARyFBdTqiDB0lqLipxyNUgvUaclAFZPcooAg9bNeiSCD-8y0-BhbImtJ2DzsFSlS6CaRH8k/s600/QPS%20relative%20to%20MySQL%205.6.51_%20writes.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvuD3_kbgAUzMsCY-ueFB0dk50XRkp0scXimc8PhEwBIHQ0cQEtzEOBUiaNPqQID3rRlrzyJqIpUlu3xmsOlfH0eAG4Pcz7KqTNmqJsDo1HTXhcswtyIiM0-f_UHaedPm1wJUNXJ461iC2CAQTOZ6pWV2cf-1KeMFWKLE46F8ErXmu1NCnGU2tSXk3FthU/s600/QPS%20relative%20to%20MySQL%205.6.51_%20writes%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfQwyKE1il9TN0wbG7RzT9vSj27ruLgJVq51CXUDk918j0p6WoglSIDCz-ASSICZlX7sVMCWpq-HiKC3r5fpWLoIh38Ynbu0uuCVgmh4dxRqhlOl9t8WazlbIA0_HcB62qsNVdahTHiu3jbJpqzum0qIARl7vVgGeFs6SL_zm2IpTnDdfBtpPe8wVmzPB6/s600/QPS%20relative%20to%20MySQL%208.0.36_%20point%20queries,%20part%201.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYrJFrLztdzYyWalpSrAmsBgBEvWPcMSXxPFY5cIZeezF_vwSeDdgMIyPNFUX3G85u1r1dz04Hu9LdZKrgwav1AQSa4jSguL1-_jdxiqu6EMFKRW2JSnsoU4wlD7JpzbWhKzjihLegP1WL7aHA55HZ0WBMmCiLVcDLcYf2vlrJBrq2yE0ytsbwl8xdx0GU/s600/QPS%20relative%20to%20MySQL%208.0.36_%20point%20queries,%20part%201%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdvTAe9AqeoHS_UAy6Hyvc3CjSjCTaJhrLG9Sw9wfWgRvV0-odjd6EeOaWNz8NHOgTW8C_CkOlxtXb_-s4NxMnF4AFB_IoymasYoUl6e4iURi6rnfReZv4AhjHLy1TYyl8xSqhHbg4P2s6NDTkJsI0-DiBLhJjTYWECBE7c1E3YU2qQqp_r-vQDD3UWMum/s600/QPS%20relative%20to%20MySQL%208.0.36_%20point%20queries,%20part%202.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-g1wil1AfplctIH1Nsmi-uGeGvo-VzyYX39VNNGlR8RU23NVRJV6U7b6LKrWjfHsKbEA8wD7a6Gxx90zr-xYgbwSvAtYRNSzmd_s_O43hy9ImJZys2NUl51dd2-mgJtIHlcy0M-pko676krHSPiRlaEs-VuziuMYE70GAp0gBnk24pzweVJV83SRWoXZx/s600/QPS%20relative%20to%20MySQL%208.0.36_%20point%20queries,%20part%202%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj49qFcuRYx89k5bCqR7aFYN_C4XJb3VPHysKVpThnUIRMw5C57pipDVJdvB9sGJ2mrBC7wIzS4SuXGmt4f0dIx8KSUC8zLA6aSqRJM42Xcf1IknQTBEKsJTpT22Q-YmC53P4SgRSCfmYlgXPPuE_vdMXcvjBFljXEgrScA7rFqQaMf2dbIjmM-CZyhRnOx/s600/QPS%20relative%20to%20MySQL%208.0.36_%20range%20queries,%20part%201.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3NVEkQ4zp4U-MZSGfI0HmutBfjo07COXin6A67-eMV9za64KgrNu3DfYofPwdcVdpTiUQxHW3EK5RiCQZYlDW7L44p5dpe0rzz_mIDentvFwF_1pYjAqY1bYft6Vb9aZJWEdojS-ZtdCe6PEvoq8155V5quIjnTITbi36pxkmMSubBNtPbbHulNZJHlJw/s600/QPS%20relative%20to%20MySQL%208.0.36_%20range%20queries,%20part%201%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzkyNgnArh6D0tGZSCVBt-YtdTxnqy9-fzqqyjDWsZx3q0gnL42tjXuQpH0Gkk__ZFihw0EjQSv7ZL5A4VWkyJXqyNGKhxMej6uG1I5fM1xOZ6aC3QdpqHRjcBv6s1bCl_aBRKMD2LXdhpFX2Cb0wvayEjCazjDERO4ufml-1UOnPYiJNmzKWh9Fer2H2d/s600/QPS%20relative%20to%20MySQL%208.0.36_%20range%20queries,%20part%202.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiwZVpIM2nv1qaDN1qJcdi3_U025HidwJSCIzwDxdMF4kwoV-7agJSqabN7W0_0SnJI-X7GFOdeW6b5cDMLrB25_fZ2BFSnKCijv8yxZi6olp6BtS5cBIl4_9Y3WToxEDM1vpkSEUCA5yG2Q29n26y8ic7FgcAg3uy7u67EdicOtzVOP8vhKbPR4ENHcEu/s600/QPS%20relative%20to%20MySQL%208.0.36_%20range%20queries,%20part%202%20(1

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjNADAffuLLK0pX_yLDP-xeurvCSMasIBZsyHikqa8I-j31kjgrCALJtyyJu8YgWLRszh9p4Pt-M3I49qjTaUCrzdjA4OxBZrgmTyu2emINa4FI0dsb3r4Y6f1vyiC5lOCSW8VDjM8pEtkZ_1VmhFHclJunJslhoUbVazPkVzyBhdnXHrvQaXzA-oT23oa/s600/QPS%20relative%20to%20MySQL%208.0.36_%20writes.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYRkcZzcmxzqkgvV72g8yGWR9XIfhfn94ap2mdKNpfmNZiEZv-5PCBIrscd52vnaKCnsfMU5JElNzLbE3mb1f9PEVzpZ1MRhhtyUFLOOvo0pUmGtCdtcOgWBS3y9Csgoa62zXyvCeGgYSUl1BRz-2DJvnb21a5V8onYnyVF5ESw92QcfVKv_6XEvPZR92H/s600/QPS%20relative%20to%20MySQL%208.0.36_%20writes%20(1

blogger.googleusercontent.com

https://drive.google.com/file/d/1zqbPPxF0IrnDKY46VE3x3zvN5cIwSbM8/view?usp=sharing

drive.google.com

https://drive.google.com/file/d/1Q5ZIRQEWbh-vRSFCI7PGkvcCv4nocf30/view?usp=sharing

drive.google.com

https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html

dev.mysql.com

https://drive.google.com/file/d/1CbsRA8rGBkI2KQX-a4n0KuQpolky19-9/view?usp=sharing

drive.google.com

https://drive.google.com/file/d/1-E-4nLMm_9zcE9xxpj4_nRus3AIfz0T3/view?usp=sharing

drive.google.com

Elsewhere on smalldatum.blogspot.com (8)