学习笔记：

发现在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???????? |

...........................

?

?