Recently, an error was reported in a large table query as follows: error 1104 (42000): the select would examine more than max_ JOIN_ SIZE rows; check your WHERE and use SET SQL_ BIG_ SELECTS=1 or SET MAX_ JOIN_ SIZE=# if the SELECT is okay
Large table 2.8 million lines. The prompt is very clear
I query show variables like ‘% max’_ JOIN_ Size% ‘is 1 million
After modifying according to the prompt, you can query.
Similar Posts:
- How to Solve Mysql Error 1206: The total number of locks exceeds the lock table size
- [Solved] MYSQL5.6 Error: ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.
- MySQL Error: [Err] 1071 – Specified key was too long; max key length is 767 bytes
- Using join buffer (Block Nested Loop)
- The solution of the table is full in MySQL
- Prepared statement needs to be re prepared
- The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the documentation for …
- [Solved] MYSQL ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot e…
- ERROR 2006 (HY000): MySQL server has gone away No
- MYSQL Error: Out of sort memory, consider increasing server sort buffer size; nested exception is java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size