MySQL 体系

show variables like 'innodb_change_buffering';


innodb_doublewrite=0.


innodb_adaptive_hash_index




SET [GLOBAL|SESSION] innodb_strict_mode=mode,




table-level AUTO-INC lock
innodb_autoinc_lock_mode = 1 






SQL_MODE
ANSI  复合模式  同时启用ANSI_QUOTES PIPES_AS_CONCAT和另外几种模式值 使其更接近标准SQL


开发环境最好设置成严格模式
strict_all_tables  非事物性表 多行更新时错误发生在非首行 返回错误部分更新
strict_trans_tables   非事物性表 产生警告 插入调整值或不确定的默认值




Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=256M
innodb_additional_mem_pool_size=20M

ROW_FORMAT=DYNAMIC 
Store values within the clustered index page if they fit;if not, stores only a 20-byte pointer to an overflow page
ROW_FORMAT=COMPACT.      compressed implies
Stores a prefix of 768 bytes of long column values in the clustered index page, with the remaining bytes stored in an overflow page


For tables created in ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED,
TEXT and BLOB columns that are less than or equal to 40 bytes are always stored
in-line.


innodb_compression_level  0--9  default 6