Shulou(Shulou.com)06/01 Report--

Recently, it was found that the production mysql database innodb_buffer_pool_size deployed by a customer development company is the default value and the physical memory is 32 gigabytes. The result is obvious and the performance problem is very big.

It is recommended that you set innodb_buffer_pool_size to 50% or 80% of physical memory.

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

-bash-4.1 $. / mysql-uroot-pEnter password: Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 3Server version: 5.7.19-log MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > mysql > show variables like 'innodb_buffer_pool_size' +-+-+ | Variable_name | Value | +-+-+ | innodb_buffer_pool_size | 67108864 | +-- -- +-+ 1 row in set (0.00 sec) mysql > use test Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changedmysql > insert into t select * from tactile error 1206 (HY000): The total number of locks exceeds the lock table sizemysql > mysql > set global innodb_buffer_pool_size=1024000*1024->; Query OK, 0 rows affected, 1 warning mysql > insert into t select * from tten query OK, 67108864 rows affected (8 min 53.81 sec) Records: 67108864 Duplicates: 0 Warnings: 0mysql >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.