The configuration community:
tmp_table_size
Information
The maximum size of in-memory temporary tables. (The actual limit is determined as the smaller of max_heap_table_size and tmp_table_size.) If an in-memory temporary table exceeds the limit MySQL automatically converts it to an on-disk MyISAM table. Increase the value of tmp_table_size (and max_heap_table_size if necessary) if you do many advanced GROUP BY queries and you have lots of memory.
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
