1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
| show full processlist;
SHOW ENGINE INNODB STATUS;
select * from mysql.user
where user='root';
show status like '%CONNECT%';
show variables like 'max_connections';
show variables like 'max_user_connections';
show variables like 'max%';
show variables like 'wait_timeout';
show global variables like '%timeout%';
show variables like 'skip%';
show status like '%clients%';
show status like '%thread%';
show variables like '%partition%';
show plugins;
select user();
select current_user();
SET GLOBAL max_allowed_packet = 1024 * 1024 * 256;
|
