建站
咨詢(xún)
售后
建站咨詢(xún)
新聞中心
大家都知道MariaDB是MySQL源代碼的一個(gè)分支，但是他們兩個(gè)之間有什么不能呢？本篇文章重點(diǎn)為大家分享一下MYSQL5.7與MariaDB10.3區(qū)別。
創(chuàng)新互聯(lián)公司10多年企業(yè)網(wǎng)站制作服務(wù);為您提供網(wǎng)站建設(shè),網(wǎng)站制作,網(wǎng)頁(yè)設(shè)計(jì)及高端網(wǎng)站定制服務(wù),企業(yè)網(wǎng)站制作及推廣,對(duì)發(fā)電機(jī)維修等多個(gè)方面擁有多年的營(yíng)銷(xiāo)推廣經(jīng)驗(yàn)的網(wǎng)站建設(shè)公司。
二者基礎(chǔ)架構(gòu)是一樣的，默認(rèn)變量參數(shù)數(shù)據(jù)也大同小異
mysql> SHOW VARIABLES LIKE 'max_con%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_connect_errors | 100 |
| max_connections | 151 |
+--------------------+-------+
2 rows in set (0.01 sec)
因?yàn)槌跏歼B接值太低，不適合高并發(fā)能力，所以提高到2000來(lái)做測(cè)試，這時(shí)候就有差異了
差異一，修改max_connetctions方式
Mysql
必須修改linux系統(tǒng)本身的ulimit參數(shù) / 系統(tǒng)默認(rèn)參數(shù)
[root@Centos7 ~]# ulimit -a | grep open
open files (-n) 1024
/修改limit參數(shù)
vim /etc/security/limits.conf
* soft nofile 65535
* hard nofile 65535
/ 修改MYsql配置文件
vim /etc/my.cnf
[mysqld]
max_connections=2000
systemctl restart mysqld
/ 查看變量，修改成功
mysql> SHOW VARIABLES LIKE 'max_con%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_connect_errors | 100 |
| max_connections | 2000 |
+--------------------+-------+
2 rows in set (0.03 sec)
MariaDB
直接修改參數(shù)重啟即可 / 修改MYsql配置文件
vim /etc/my.cnf
[mysqld]
max_connections=2000
systemctl restart mysqld
/ 查看變量，修改成功
mysql> SHOW VARIABLES LIKE 'max_con%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_connect_errors | 100 |
| max_connections | 2000 |
+--------------------+-------+
2 rows in set (0.03 sec)
差異二，并發(fā)能力強(qiáng)度對(duì)比
測(cè)試環(huán)境
mysqlsap工具 同時(shí)并發(fā)1000個(gè)連接 分別并發(fā)1000個(gè)連接 同時(shí)并發(fā)1000個(gè)連接
/ mysql的并發(fā)
[root@Centos7 ~]# mysqlslap -a -c 1000
Benchmark
Average number of seconds to run all queries: 40.796 seconds
Minimum number of seconds to run all queries: 40.796 seconds
Maximum number of seconds to run all queries: 40.796 seconds
Number of clients running queries: 1000
Average number of queries per client: 0
/ MariaDB的并發(fā)
[root@Centos7 ~]# mysqlslap -a -c 1000
Benchmark
Average number of seconds to run all queries: 19.427 seconds
Minimum number of seconds to run all queries: 19.427 seconds
Maximum number of seconds to run all queries: 19.427 seconds
Number of clients running queries: 1000
Average number of queries per client: 0
分別并發(fā)1000個(gè)連接
/ Mysql先并發(fā)1000個(gè)連接
[root@Centos7 ~]# mysqlslap -a -c 1000
Benchmark
Average number of seconds to run all queries: 28.096 seconds
Minimum number of seconds to run all queries: 28.096 seconds
Maximum number of seconds to run all queries: 28.096 seconds
Number of clients running queries: 1000
Average number of queries per client: 0
/ MariaDB 后續(xù)并發(fā)1000個(gè)連接
[root@Centos7 ~]# mysqlslap -a -c 1000
Benchmark
Average number of seconds to run all queries: 14.042 seconds
Minimum number of seconds to run all queries: 14.042 seconds
Maximum number of seconds to run all queries: 14.042 seconds
Number of clients running queries: 1000
Average number of queries per client: 0
總結(jié)：由此比對(duì)得出同時(shí)并發(fā)時(shí)，mysql跟MariaDB差距太大，可以達(dá)到2倍差距，分開(kāi)并發(fā)MariaDB比mysql提高60%性能
網(wǎng)站標(biāo)題：MYSQL5.7與MariaDB10.3區(qū)別
文章路徑：http://fisionsoft.com.cn/article/dhpgpie.html
