Received mail today, mysql3308, synchronization error, log as follows:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/58/C7/wKioL1S8l_KypZBfAAFoPmRUszU909.jpg "title=" Untitled. png "alt=" wkiol1s8l_kypzbfaafopmruszu909.jpg "/>
To modify the configuration file my.cnf, add:
Innodb_buffer_pool_size = 16M
Restart MySQL, resolve,
---------
Reference:
mysql resolves the total number of locks exceeds the lock table size error
The following error occurred while operating the MySQL database table.
650) this.width=650; "src=" http://blog.chinaunix.net/attachment/201207/31/25266990_1343698912z4O9.jpg "border=" 0 " height= "246" width= "530" style= "border:0px;" alt= "25266990_1343698912z4o9.jpg"/>
Google search on the internet related issues, found a foreign bull to explain this :
If you ' re running an operation on a large number of rows within a table that uses the InnoDB storage engine, you might see This error:
ERROR 1206 (HY000): The total number of locks exceeds the lock table size
MySQL is trying-to-tell-you-it doesn ' t have enough-to-store all of the row locks so it would need to execute Y Our query. The only-to-be-to-fix it for sure are to adjust innodb_buffer_pool_size and restart MySQL. By default, the is set to only 8MB, which are too small for anyone and who are using InnoDB to do anything.
If you need a temporary workaround, reduce the amount of rows to your ' re manipulating in one query. For example, if-need to delete-a million rows from a table, try-to-delete the records in chunks of 50,000 or 100,000 R oWS. If you ' re inserting many rows, try to insert portions of the data at a single time.
The original is innodb innodb global innodb_buffer_pool_size mysql service.
View the current database storage engine, when it is created the engine=innodb type.
the default innodb_buffer_pool_size =8m
650) this.width=650; "src=" http://blog.chinaunix.net/attachment/201207/31/25266990_1343698926Z3h3.png "border=" 0 " height= "292" width= "389" style= "border:0px;" alt= "25266990_1343698926z3h3.png"/>
To modify The value of the innodb_buffer_pool_size:
Click ( here ) to collapse or open
innodb_buffer_pool_size=64m
Restart the MySQL server again, perform the table operation, completed successfully.
This article is from the "Stone" blog, please be sure to keep this source http://dodowolf.blog.51cto.com/793581/1605647
MySQL Error from library