mariadb mysql版本对应_弹指神通MariaDB——MariaDB与MySQL各版本的区别
1 MariaDB的性質
MariaDB從MySQL衍生而來,作為完全開源的一款數據庫產品。關于MariaDB更詳細的信息其實是在MariaDB.org中。在MariaDB download中也做了詳細的說明了MariaDB的性質:
MariaDB is free and open source software
The MariaDB database server is published as free and open source software under the General Public License version 2. You can download and use it as much as you want free of charge. All use of the binaries from mariadb.org is at your own risk as stated in the GPLv2. While we do our best to make the world’s best database software, the MariaDB Foundation does not provide any guarantees and cannot be hold liable for any issues you may encounter. The MariaDB Foundation does not provide any help or support.
If you intend to run MariaDB database server in production we recommend purchasing a subscription from MariaDB Corporation, or any of the other commercial support providers in the MariaDB ecosystem. There are many resources you can use to learn MariaDB and support yourself or get peer support online.
這里面說明了MariaDB遵循GPLv2協議,其實說的就是MariaDB完全開源,全部免費,但是不對使用者承擔任何責任。
2 MariaDB與MySQL各版本之間的對應關系
目前MariaDB最新的版本是MariaDB 10.3,里面的List of All MariaDB 10.3 Releases中則介紹了目前已有的MariaDB的版本,而Comparison with MySQL則簡單介紹了目前比較新的MariaDB與MySQL版本之間的區別。
3 查看MariaDB版本
3.1 方法1
[root@shizhi002 ~]# mysql -V
mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1
3.2 方法2
[root@shizhi002 ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 525
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
3.3 方法3
MariaDB [(none)]> status
--------------
mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1
Connection id:525
Current database:
Current user:root@localhost
SSL:Not in use
Current pager:stdout
Using outfile:''
Using delimiter:;
Server:MariaDB
Server version:5.5.60-MariaDB MariaDB Server
Protocol version:10
Connection:Localhost via UNIX socket
Server characterset:latin1
Db characterset:latin1
Client characterset:utf8
Conn. characterset:utf8
UNIX socket:/var/lib/mysql/mysql.sock
Uptime:13 days 23 hours 16 min 22 sec
Threads: 1 Questions: 33739 Slow queries: 0 Opens: 142 Flush tables: 2 Open tables: 83 Queries per second avg: 0.027
--------------
參考
總結
以上是生活随笔為你收集整理的mariadb mysql版本对应_弹指神通MariaDB——MariaDB与MySQL各版本的区别的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: FreeEIM 2.0 beta 发布
- 下一篇: systemtap mysql_使用sy