Error "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"
This error occurs when the database needs to search on more than 1 million rows to meet
he requirements of your query.
This limitation does not concern the number of records in a table,but rather how many records
will be read to satisfy a query, so in a table without proper optimization mysql can make multiple
queries to fit the result of a query, addition of indexes, causes mysql to scan fewer records.
- To solve the error in question:
Optimize your query and also create index in your tables, thus increasing the performance of your database.
Related Articles
How to check your hosting disk space
The use of your disk space adds up to all files and data in your hosting account, this includes databases, website files, and email accounts. Warning emails will automatically be sent when it is close to reaching 100% of disk capacity. Where to check ...
How to use the Setup Python App
How to use the Setup Python App 1. In cPanel, open Setup Python App. Click Create Application. Choose the Python version. Application Root: folder where your application will be located. Application URL: domain or subdomain that will run the app. ...
How to use the Google Public DNS
When your connection is bad or awkward, the problem is not found in the Domain Name System (DNS) server. It transforms websites with "beautiful" addresses, such as scriptcase.com, into their respective IP addresses to be read by your ISP. If the ...
Customize error pages
First you must access your cPanel: See how to obtain credentials and access cPanel through our article: Here Logged into your cPanel, locate the “Advanced” section and there locate the item “Error pages”; In step 1 you must select the domain you want ...
How to use File Manager and upload a file
If you don't want to use a 3rd party FTP Software, you can use the cPanel's inbuilt File Manager. 1. Log into your cPanel account. 2. In the "Files" section, click on the "File Manger" Icon. 3. Once in File Manager ...