2018年9月11日 星期二

My SQL locks exceeds the lock table size




Error Code: 1206. The total number of locks exceeds the lock table size


show variables like 'innodb_buffer_pool_size';

innodb_buffer_pool_size 8388608


set global innodb_buffer_pool_size=4g;
Access Denied;


"C:\Program Files\MySQL\MySQL Router 8.0\bin\mysqlrouter.exe" -c "C:\ProgramData\MySQL\MySQL Router\mysqlrouter.conf" --service

C:\ProgramData\MySQL\MySQL Router\mysqlrouter.conf
innodb_buffer_pool_size=8M
innodb_buffer_pool_size=4G

沒有留言:

張貼留言

2007 to 2023 HP and Dell Servers Comparison

  HP Gen5 to Gen11  using ChatGPT HP ProLiant Gen Active Years CPU Socket Popular HP CPUs Cores Base Clock Max RAM Capacity Comparable Dell ...