SHOW GLOBAL VARIABLES LIKE "%buffer_pool%"
可以通过编辑/etc/my.cnf,添加下面的语句来修改缓存大小:
innodb_buffer_pool_size = 2G
The total number of locks exceeds the lock table s
原文:http://my.oschina.net/lhplj/blog/342776