Frage zu mysql #1104

[bobby]

Moin,

In der Doku steht:

[...] Do not permit statements that probably need to examine more than max_join_size rows (for single-table statements) or row combinations (for multiple-table statements) or that are likely to do more than max_join_size disk seeks. By setting this value, you can catch statements where keys are not used properly and that would probably take a long time. Set it if your users tend to perform joins that lack a WHERE clause, that take a long time, or that return millions of rows. [...]

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_join_size

Gruß Bobby