4. mysql process connection, interaction, variable

<--Directory--

1) Process Connection

2) interaction

3) variables

"Process Connection"

Mysql> show Processlist; #查看MySQL当前所有进程连接

Interaction

mysql> system Ls/tmp #MySQL交互下查看tmp目录下内容

Variable

Mysql> Show variables; #查看变量

Mysql> Show status; #查看状态

Mysql> show global Stat; #查看全局状态

Mysql> Show status like ' wsrep% '

mysql> set global key_buffer_size=16k;

Mysql> Show variables like ' key_buffer% '

Mysql> set global autocommit=0 #关闭自动提交, 0 off, 1 for start

Mysql> set autocommit=0 #再设置多一次, global variables can take effect, exit re-login to see if the variable is valid

Mysql> Show variables like '%autocommit% '; #查看自动提交有没有成功

This article is from the "Wsyht blog" blog, make sure to keep this source http://wsyht2015.blog.51cto.com/9014030/1787637

4. mysql process connection, interaction, variable