14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→ERROR 1206: The total number of locks exceeds the lock table size
m (→references) |
|||
| Line 181: | Line 181: | ||
* [http://stackoverflow.com/questions/5696857/how-to-change-value-for-innodb-buffer-pool-size-in-mysql-on-mac-os innodb - How to change value for innodb_buffer_pool_size in MySQL on Mac OS? - Stack Overflow]. | * [http://stackoverflow.com/questions/5696857/how-to-change-value-for-innodb-buffer-pool-size-in-mysql-on-mac-os innodb - How to change value for innodb_buffer_pool_size in MySQL on Mac OS? - Stack Overflow]. | ||
* [https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html MySQL :: MySQL 5.7 Reference Manual :: 14.6.3.2 Configuring InnoDB Buffer Pool Size] | * [https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html MySQL :: MySQL 5.7 Reference Manual :: 14.6.3.2 Configuring InnoDB Buffer Pool Size] | ||
== ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' == | |||
Message: ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'. | |||
Solution: Change the syntax of subquery to {{kbd | key =column_name BETWEEN start_number to end_number}} | |||
Further reading: | |||
* [https://dev.mysql.com/doc/mysql-reslimits-excerpt/5.6/en/subquery-restrictions.html MySQL :: MySQL Restrictions and Limitations :: 4 Restrictions on Subqueries] | |||
* [https://blog.gslin.org/archives/2013/07/12/3377/mysql-subquery-%E7%9A%84%E9%99%90%E5%88%B6/ MySQL subquery 的限制… – Gea-Suan Lin's BLOG] | |||
== ERROR 1690 - BIGINT UNSIGNED value is out of range == | == ERROR 1690 - BIGINT UNSIGNED value is out of range == | ||