The configuration community:
read_rnd_buffer_size
Information
When reading rows in sorted order following a key-sorting operation the rows are read through this buffer to avoid disk seeks. Setting the variable to a large value can improve ORDER BY performance by a lot. However this is a buffer allocated for each client so you should not set the global variable to a large value. Instead change the session variable only from within those clients that need to run large queries.
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.cookie_secure | 2007-07-01 18:37 |
| session.use_trans_sid | 2007-07-01 18:37 |
| session.use_cookies | 2007-07-01 18:37 |
Highest rated nodes
Navigation
Syndicate
