select @@innodb_page_size;
select @@innodb_page_size/1024;
show variables like '%innodb_page_size%'; //查看page页大小
show variables like '%innodb_old%'; //查看Iru list中列表参数
show variables like '%innodb_buffer%'; //查看buffer pool参数
show variables like ‘%innodb_data_file_path%’;
show variables like ‘%innodb_file_per_table%’;
show variables like '%innodb_doublewrite%';
show variables like '%innodb_purge_thread%';
show variables like '%innodb_flush_method%'; // 建议设置成 O_DIRECT,直接写入,提高刷盘效率
show engine innodb status; //查看线程状态
show variables like '%innodb_io_capacity%';
show variables like '%innodb_max_dirty_pages_pct%'
show variables like '%innodb_purge_batch_size%'
select * from information_schema.innodb_sys_tables;
show variables like '%innodb_log%';
## MySQL隔离级别控制
show variables like 'tx_isolation'; 或 select @@tx_isolation;
set tx_isolation='READ-UNCOMMITTED';
set tx_isolation='READ-COMMITTED';
set tx_isolation='REPEATABLE-READ';
set tx_isolation='SERIALIZABLE';
# 查看死锁状态
- Innodb_row_lock_current_waits:当前正在等待锁的数量
- Innodb_row_lock_time:从系统启动到现在锁定总时间长度
- Innodb_row_lock_time_avg: 每次等待锁的平均时间
- Innodb_row_lock_time_max:从系统启动到现在等待最长的一次锁的时间
- Innodb_row_lock_waits:系统启动后到现在总共等待的次数