查看MySQL状态的方法
学习笔记：
发现在JPA中执行SQL时无法执行 SHOW ** 的语句，找了一些资料发现还有另外的方法，留在此处作个笔记
?
?
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES --SHOW VARIABLES SELECT * FROM INFORMATION_SCHEMA.GLOBAL_STATUS --SHOW STATUS SELECT * FROM INFORMATION_SCHEMA.ENGINES --SHOW ENGINES
?
另外还可以通过命令行查看信息如：
?
查看MySQL版本等信息
root@simen-laptop:~# mysql -u*** -p*********-e status
————–
mysql? Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (x86_64) using? EditLine wrapper
Connection id:??? ??? 370
SSL:??? ??? ??? Not in use
Current pager:??? ??? stdout
Using outfile:??? ??? ”
Using delimiter:??? ;
Server version:??? ??? 5.1.37-1ubuntu5 (Ubuntu)
Protocol version:??? 10
Connection:??? ??? Localhost via UNIX socket
Client characterset:??? latin1
Server characterset:??? latin1
UNIX socket:??? ??? /var/run/mysqld/mysqld.sock
Uptime:??? ??? ??? 1 day 8 hours 37 min 1 sec
Threads: 9? Questions: 33009? Slow queries: 0? Opens: 224? Flush tables: 1? Open tables: 49? Queries per second avg: 0.281
————–
?
查看运行状态
root@simen-laptop:~# mysqladmin -u***** -p***** extended-status
+———————————–+———–+
| Variable_name???????????????????? | Value???? |
+———————————–+———–+
| Aborted_clients?????????????????? | 5???????? |
| Aborted_connects????????????????? | 5???????? |
| Binlog_cache_disk_use???????????? | 0???????? |
| Binlog_cache_use????????????????? | 0???????? |
| Bytes_received??????????????????? | 1126312?? |
| Bytes_sent??????????????????????? | 155498067 |
| Com_admin_commands??????????????? | 4???????? |
| Com_assign_to_keycache??????????? | 0???????? |
| Com_alter_db????????????????????? | 0???????? |
| Com_alter_db_upgrade????????????? | 0???????? |
| Com_alter_event?????????????????? | 0???????? |
………………………
?
?
