Help us understand the problem. What is going on with this article?

【MySQL】ERROR 1206 (HY000): The total number of locks exceeds the lock table size

More than 1 year has passed since last update.

SELECTしてINSERTしようとした時に,下記のエラーが出た.
どうやらデータが多くバッファプールが足りなくなったようです.

ERROR 1206 (HY000): The total number of locks exceeds the lock table size

そのため,~/etc/my.conf
innodb_buffer_pool_size=404750336
を追記.sudo権限必要です.

~/etc/my.conf
innodb_buffer_pool_size=404750336

更新したら再起動.

$ mysql.server restart

確認すると

> show variables like 'innodb_buffer_pool_size';
+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| innodb_buffer_pool_size | 536870912 |
+-------------------------+-----------+
1 row in set (0.00 sec)

足される形になるんですね.

いろいろ調べてみると

https://qiita.com/mita2/items/8fd915164f0851c96e54
こちらの記事が参考になりました.

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away