MySQL运维之--日常维护操作 - 数据库编程

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 --释放

MySQL运维之--日常维护操作(三)