- 14.1 Introduction to InnoDB【粗翻】
- 14.2 InnoDB和ACID模型【粗翻】
- 14.3 InnoDB与MVCC【粗翻】
- 14.4 InnoDB整体架构【已校对】
- 14.5 InnoDB在内存中的数据结构【粗翻】
- 14.6 InnoDB在磁盘上的存储结构【粗翻】
- 14.7 InnoDB的锁和事务模型【校对完成】
- 14.8 InnoDB Configuration
- 14.9 InnoDB Table and Page Compression
- 14.10 InnoDB File-Format Management
- 14.11 InnoDB Row Formats
- 14.12 InnoDB Disk I/O and File Space Management
- 14.13 InnoDB and Online DDL
- 14.14 InnoDB Data-at-Rest Encryption
- 14.15 InnoDB Startup Options and System Variables
- 14.16 InnoDB INFORMATION_SCHEMA Tables
- 14.17 InnoDB Integration with MySQL Performance Schema
- 14.18 InnoDB Monitors
- 14.19 InnoDB Backup and Recovery
- 14.20 InnoDB and MySQL Replication
- 14.21 InnoDB memcached Plugin
- 14.22 InnoDB Troubleshooting
- 14.23 InnoDB的极限限制【粗翻】
- 14.24 InnoDB Restrictions and Limitations
-- 查询客户端连接(服务器线程)
SHOW FULL PROCESSLIST;
-- 查询InnoDB状态
SHOW ENGINE INNODB STATUS;
-- 查询理论上的MySQL内存最大使用量
SELECT ( @@key_buffer_size
+ @@query_cache_size
+ @@innodb_buffer_pool_size
+ @@innodb_log_buffer_size
+ @@max_connections * (
@@read_buffer_size
+ @@read_rnd_buffer_size
+ @@sort_buffer_size
+ @@join_buffer_size
+ @@binlog_cache_size
+ @@thread_stack
+ @@tmp_table_size )
) / (1024 * 1024 * 1024) AS MAX_MEMORY_GB;