« 算法:ORA-600 2252和SCN 最大值SCN_WRAP SCN_BASE | Blog首页 | MySQL 实践:制定 mysqldump 简单的备份策略 »
MySQL 实践:查询版本号、存储引擎、存储路径等信息
链接:https://www.eygle.com/archives/2019/08/mysql_storage_engines.html
1.获得 MySQL 版本号的方法
查询 MySQL 数据库的版本号,可以通过以下几种方法获取:
mysql> select version();
+------------+
| version() |
+------------+
| 5.1.63-log |
+------------+
1 row in set (0.00 sec)
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.1.63, for unknown-linux-gnu (x86_64) using EditLine wrapper
Connection id: 36144
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.63-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 5 days 17 hours 56 min 25 sec
Threads: 5 Questions: 1312540 Slow queries: 2 Opens: 2815 Flush tables: 1 Open tables: 512 Queries per second avg: 2.643
--------------
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.1.63, for unknown-linux-gnu (x86_64) using EditLine wrapper
Connection id: 36144
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.63-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 5 days 17 hours 56 min 26 sec
Threads: 5 Questions: 1312608 Slow queries: 2 Opens: 2815 Flush tables: 1 Open tables: 512 Queries per second avg: 2.643
--------------
[root@ var]# mysql -V
mysql Ver 14.14 Distrib 5.1.63, for unknown-linux-gnu (x86_64) using EditLine wrapper
2.查询当前使用的存储引擎
mysql> show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
5 rows in set (0.00 sec)
mysql> show variables like '%storage_engine%';
+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| storage_engine | MyISAM |
+----------------+--------+
1 row in set (0.00 sec)
3.查询端口、字符集、连接数、存储路径等信息
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> show variables like 'character%';
+--------------------------+----------------------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /mysql-5.1.57/share/mysql/charsets/ |
+--------------------------+----------------------------------------------------+
8 rows in set (0.00 sec)
mysql> show variables like 'collation%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> show variables like '%max_connections%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 2000 |
+-----------------+-------+
1 row in set (0.00 sec)
mysql> show status like 'Threads%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_cached | 2 |
| Threads_connected | 4 |
| Threads_created | 739 |
| Threads_running | 1 |
+-------------------+-------+
4 rows in set (0.00 sec)
mysql> show variables like '%datadir%';
+---------------+----------------------------+
| Variable_name | Value |
+---------------+----------------------------+
| datadir | /mysql/var/ |
+---------------+----------------------------+
1 row in set (0.00 sec)
记录。
历史上的今天...
>> 2014-08-15文章:
>> 2013-08-15文章:
>> 2007-08-15文章:
>> 2006-08-15文章:
>> 2005-08-15文章:
By eygle on 2019-08-15 11:10 | Comments (0) | FAQ | 3354 |