一、問題描述
今日上午接到同僚的召喚,讓幫着給檢視一下生産資料Mysql資料庫軟體版本。呵呵,對于小白的我,當然是先答應後學習喽。并且漂亮的完成任務。
二、實驗(非生産環境)
1.登入mysql環境時,有服務版本号,此處為5.6.22
[root@suzzy ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 5.6.22-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
2.使用 mysql -V 來檢視版本資訊
[root@suzzy ~]# mysql -V
mysql Ver 14.14 Distrib 5.6.22, for Linux (x86_64) using EditLine wrapper
3.使用 mysql --help 來檢視版本資訊
[root@suzzy ~]# mysql --help |grep Distrib
[root@suzzy ~]#
4.進入mysql指令後,使用status指令
mysql> status
--------------
Connection id: 51
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.22-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
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: 45 days 23 hours 9 min 46 sec
Threads: 1 Questions: 124 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.000
5.使用系統函數
mysql> select version();
+---------------------------------------+
| version() |
| 5.6.22-enterprise-commercial-advanced |
1 row in set (0.00 sec)
mysql> select @@version;
| @@version |
6.檢視變量
mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name | Value |
| innodb_version | 5.6.22 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.22-enterprise-commercial-advanced |
| version_comment | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
7 rows in set (0.00 sec)
7.mysqladmin 指令方式
[root@suzzy ~]# mysqladmin -uroot -p -hlocalhost version;
Enter password:
mysqladmin Ver 8.42 Distrib 5.6.22, for Linux on x86_64
Server version 5.6.22-enterprise-commercial-advanced
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 46 days 7 min 45 sec
Threads: 1 Questions: 133 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.000
三、官方說明 2.1.1章節
The naming scheme in MySQL 5.6 uses release names that consist of three numbers and a suffix; for example, mysql-5.6.1-m1. The numbers within the release name are interpreted as follows:
The first number (5) is the major version and describes the file format. All MySQL 5 releases have the same file format.
The second number (6) is the release level. Taken together, the major version and release level constitute the release series number.
The third number (1) is the version number within the release series. This is incremented for each new release. Usually you want the latest version for the series you have chosen.
四、總結:
看似簡單的工作,如果沒有接觸過人還真是不曉得。是以DBA的大小朋友們,把你不會的東西提早學習一下,會受益匪淺的。想起來一句話(書到用時方恨少;事非經過不知難。)譯:知識總是在運用時才讓人感到太不夠了,許多事情如果不親身經曆過就不知道它有多難。