宿州哪家做网站不做,页面设置标签wordpress,专门做捷径网站,电商是做什么的?MySQL和MariaDB哪个更快#xff1f;MySQL 8.0的版本和早期MySQL 5.6的版本哪个更快#xff1f;这儿有个第三方的测试报告回答了这两个大家关心的问题#xff0c;姚远来和大家一起解读一下。https://smalldatum.blogspot.com/2024/04/sysbench-on-small-server-mariadb-and.h…MySQL和MariaDB哪个更快MySQL 8.0的版本和早期MySQL 5.6的版本哪个更快这儿有个第三方的测试报告回答了这两个大家关心的问题姚远来和大家一起解读一下。https://smalldatum.blogspot.com/2024/04/sysbench-on-small-server-mariadb-and.html 关于号主姚远 Oracle ACEOracle和MySQL数据库方向华为云最有价值专家《MySQL 8.0运维与优化》的作者拥有 Oracle 10g、12c和19c OCM等数十项数据库认证曾任IBM公司数据库部门经理20年DBA经验服务2万客户精通C和Java发明两项计算机专利 MySQL VS MariaDB
直接说结果“Modern MariaDB is 13% to 22% faster than modern MySQL (on this setup)”
下面这个表是MariaDB 11.4.1 vs MySQL 8.0.36的测试结果5种测试场景大于1表示MariaDB 11.4.1比MySQL 8.0.36快。
point, part 1point, part 2range, part 1range, part 2writesaverage1.131.171.191.181.21median1.131.161.171.131.22min1.071.131.081.101.01max1.271.211.411.301.37stddev0.060.030.100.090.11
细节大家可以去看报告原文。
MySQL 8.0 VS MySQL 5.6
也直接上结论new MySQL (8.0.36) gets between 63% and 95% of the throughput relative to old MySQL (5.6.51) using the median relative throughput per microbenchmark group.
point, part 1point, part 2range, part 1range, part 2writesaverage0.760.800.690.930.69median0.760.750.690.950.63min0.670.700.640.680.55max0.840.940.731.141.04stddev0.050.110.040.200.14
上表中大于1表示MySQL 8.0.36比5.6.51快。现在测试结果8.0.36远逊于5.6.51的原因是新特性消耗了更多的CPU。
