The configuration community:
max_join_size
Information
Do not allow SELECT 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 SELECT 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.
Syntax
Example
Impartial web hosting comparison
tags in Configurations
Recent Configurations
| Configuration | Updated |
|---|---|
| php.ini default production configuration | 2010-03-08 09:12 |
| MySQL example config file for systems with 4GB of memory | 2009-04-12 14:35 |
| Apache HTTP server configuration file 2.2.8 | 2008-05-28 19:18 |
| Optimizing sysctl | 2008-01-10 22:19 |
| Sample IPTABLES configuration file for Linux workstations | 2007-08-27 18:33 |
Recent Directives
| Directive | Updated |
|---|---|
| base_url | 2007-07-08 21:42 |
| db_url | 2007-07-08 21:34 |
| session.use_trans_sid | 2007-07-01 18:37 |
| session.use_cookies | 2007-07-01 18:37 |
| session.bug_compat_warn | 2007-07-01 18:37 |
Highest rated nodes
Navigation
Syndicate
