弹指神通MariaDB——MariaDB与MySQL各版本的区别

编程入门 行业动态 更新时间:2024-10-28 14:28:35

弹指<a href=https://www.elefans.com/category/jswz/34/1739063.html style=神通MariaDB——MariaDB与MySQL各版本的区别"/>

弹指神通MariaDB——MariaDB与MySQL各版本的区别

转载请注明出处:
本文出自【我是干勾鱼的博客】

Ingredients:

  • MariaDB:MariaDB 10.2.21 Stable(mariadb-10.2.21-linux-x86_64.tar.gz,MariaDB - All Releases)

1 MariaDB的性质

MariaDB从MySQL衍生而来,作为完全开源的一款数据库产品。关于MariaDB更详细的信息其实是在MariaDB中。在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 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版本之间的区别。

在System Variable Differences between MariaDB and MySQL中讲解了MariaDB与MySQL各版本之间的区别。里面赫然有一条System Variable Differences Between MariaDB 5.5 and MySQL 5.5,能感觉出MariaDB直到5.5版本均依照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 ServerCopyright (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.1Connection 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 secThreads: 1  Questions: 33739  Slow queries: 0  Opens: 142  Flush tables: 2  Open tables: 83  Queries per second avg: 0.027
--------------

参考

MariaDB

MariaDB

System Variable Differences between MariaDB and MySQL

MariaDB 版本

更多推荐

弹指神通MariaDB——MariaDB与MySQL各版本的区别

本文发布于:2024-02-26 09:39:26,感谢您对本站的认可!
本文链接:https://www.elefans.com/category/jswz/34/1702053.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
本文标签:神通   各版   区别   MySQL   MariaDB

发布评论

评论列表 (有 0 条评论)
草根站长

>www.elefans.com

编程频道|电子爱好者 - 技术资讯及电子产品介绍!