mysql 优化技巧心得一(key_buffer_size设置).
1: 对于mysql来说,登录的时候,加一个参数
mysql> show global status like 'key_blocks_u%';+------------------------+-------------+| Variable_name | Value |+------------------------+-------------+| Key_blocks_unused | 0 || Key_blocks_used | 413543 |+------------------------+-------------+
Key_blocks_used / (Key_blocks_unused + Key_blocks_used) * 100% ≈ 80%