Mysql查询服务器信息

1.可以列出mysql服务器运行各种状态值
 show global status;
 查询mysql服务器配置信息语句：
 show variables;
 
如： 
mysql> show global status like '%slow%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| Slow_launch_threads | 0     |
| Slow_queries        | 12896 |
+---------------------+-------+
2 rows in set (0.00 sec)

mysql> show variables like '%slow%';   
+---------------------+--------------------------+
| Variable_name       | Value                    |
+---------------------+--------------------------+
| log_slow_queries    | ON                       |
| slow_launch_time    | 2                        |
| slow_query_log      | ON                       |
| slow_query_log_file | /data/mysqldata/slow.log |