Following the code, it seems that innodb returns DB_LOCK_TABLE_FULL when less than 1/4 of any buffer pool instance is free. We have 8 x 20 GB data buffer pools. 25% could have been a good value maybe 10 years ago.... unless I'm missing something...
Following the code, it seems that innodb returns DB_LOCK_TABLE_FULL when less than 1/4 of any buffer pool instance is free.
We have 8 x 20 GB data buffer pools. 25% could have been a good value maybe 10 years ago.... unless I'm missing something...