og.log
WAL: write ahead log,日志优先写
11、归档
flush logs;
show master status;
write ahead log. recover backup, duriably. undo acid m
vcc
12、参数和统计信息
show variables; ----参数
show variables like '%bin%';
show status; ----统计信息
show global status like'%insert%';
insert into test(name) values('xxxxx');
show variables like '%default%';
set global default_storage_engine=myisam; ---不影响当前会话的操作，影响新建立的连接
set session default_storage_engine=myisam; ---影响当前会话的操作
---连接池
max_connect
min_connect
max_idle
time_out
disconnect --释放
?
|