The configuration community:
join_buffer_size
Information
The size of the buffer that is used for joins that do not use indexes and thus perform full table scans. Normally the best way to get fast joins is to add indexes. Increase the value of join_buffer_size to get a faster full join when adding indexes is not possible. One join buffer is allocated for each full join between two tables. For a complex join between several tables for which indexes are not used multiple join buffers might be necessary.
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
