MySQL – SQL_BIG_SELECTS

by

  1. MySQL determines whether or not a query is a ‘big select’ based on the value of ‘max_join_size’. If the query is likely to have to examine more than this number of rows, it will consider it a ‘big select’. Use ‘show variables’ to view the value of the max join size.

  2. I believe that indexing and particular a good where clause will prevent this problem from occuring.

  3. SQL_BIG_SELECTS is used to prevent users from accidentally executing excessively large queries. It is okay to set it to ON in mysql.cnf or using the command-line option at startup.

  4. You can set SQL_BIG_SELECTS in my.cnf or at server startup. It can also be set on a session basis with SET SESSION SQL_BIG_SELECTS=1.

  5. Not that I can think of. I would just check your query to make sure that you really need to use it. Our servers have it turned on by default, and max_join_size is very large.

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. SQL query return data from multiple tables
  3. Select all columns except one in MySQL?
  4. quick selection of a random row from a large table in mysql
  5. MySQL: is a SELECT statement case sensitive?
  6. MySQL SELECT only not null values
  7. What is MySQL row order for “SELECT * FROM table_name;”?
  8. Combine Multiple child rows into one row MYSQL
  9. MySQL SELECT increment counter
  10. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  11. How to get an age from a D.O.B field in MySQL?
  12. How does MySQL’s ORDER BY RAND() work?
  13. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  14. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  15. How do I get the first day of the week of a date in mysql?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. Mysql select distinct
  18. MySQL error 1241: Operand should contain 1 column(s)
  19. How to select one row randomly taking into account a weight?
  20. quick selection of a random row from a large table in mysql
  21. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  22. Compare only day and month with date field in mysql
  23. mysql select sum group by date
  24. MySQL INNER JOIN select only one row from second table
  25. MySQL Select Query – Get only first 10 characters of a value
  26. Using index, using temporary, using filesort – how to fix this?
  27. What is the default MySQL JOIN behaviour, INNER or OUTER?
  28. Insert data into table with result from another select query
  29. How to use Table output from stored MYSQL Procedure
  30. MySQL cartesian product between two SELECT statements

Leave a Comment