MySQL 逻辑架构
MySQL 物理组成
MySQL 物理组成的配置
log-bin = /mysql/log/mysql-bin
innodb_log_file_size = 1000M
innodb_log_files_in_group = 3
log-error = /mysql/log/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /mysql/log/mysql-slow.log
general_log = OFF
general_log_file = /mysql/data/mysql-general.log
innodb_file_per_table = 1
MySQL 存储引擎
MySQL 索引
MySQL锁
MySQL锁的操作
lock tables customer read;
lock tables customer write;
select sleep(30) from customer;
show processlist\G
flush tables with read lock;
select get_lock('user_1',20);
MySQL事务
MySQL 数据库的备份与恢复