« 算法:ORA-600 2252和SCN 最大值SCN_WRAP SCN_BASE | Blog首页 | MySQL 实践：制定 mysqldump 简单的备份策略 »

MySQL 实践：查询版本号、存储引擎、存储路径等信息

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)

记录。

By eygle on 2019-08-15 11:10 | Comments (0) | FAQ | 3354 |

Mysql