MySql中的常用参数查询

mysql> show global variables like '%timeout%';
+-----------------------------+----------+
| Variable_name        | Value  |
+-----------------------------+----------+
| connect_timeout       | 10    |
| delayed_insert_timeout   | 300   |
| have_statement_timeout   | YES   |
| innodb_flush_log_at_timeout | 1    |
| innodb_lock_wait_timeout  | 50    |
| innodb_rollback_on_timeout | OFF   |
| interactive_timeout     | 28800  |
| lock_wait_timeout      | 31536000 |
| net_read_timeout      | 30    |
| net_write_timeout      | 60    |
| rpl_stop_slave_timeout   | 31536000 |
| slave_net_timeout      | 60    |
| wait_timeout        | 28800  |
+-----------------------------+----------+

mysql> show global status like 'Max_used_connections';
+----------------------+-------+
| Variable_name    | Value |
+----------------------+-------+
| Max_used_connections | 4   |
+----------------------+-------+
1 row in set (0.00 sec)

mysql> show variables like 'max_connections%';
+-----------------+-------+
| Variable_name  | Value |
+-----------------+-------+
| max_connections | 10000 |
+-----------------+-------+
1 row in set (0.01 sec)

mysql> status;
--------------
mysql Ver 14.14 Distrib 5.7.14, for linux-glibc2.5 (x86_64) using EditLine wrapper

Connection id:  17318
Current database: 
Current user:  root@localhost
SSL:   Not in use
Current pager:  stdout
Using outfile:  ''
Using delimiter: ;
Server version:  5.7.14-log MySQL CommUnity Server (GPL)
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:   20 hours 2 min 14 sec

Threads: 5 Questions: 118037 Slow queries: 0 Opens: 1743 Flush tables: 1 Open tables: 916 Queries per second avg: 1.636
--------------