…SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql…sort_buffer_size was decreased to 256K from 2M. This change should help many small sorts for which allocation of 2M for sort buffer…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… to provide as MySQL is typically protected by Firewall to begin with. open_files_limit = 5000 strangely enough this is where the smart… is probably well too small to be useful but leaves impression it does not need to be configured. sort_buffer_size = 256K Good choice for very small sorts…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…buffer pool. (There’s also an innodb_additional_mem_pool_size but it’s typically set pretty small…sort_buffer_size to 128K — I can quite well connect and say “set @@sort_buffer_size := 1 * 1024 * 1024 * 1024;” and my sort_buffer_size is…memory too….(2.34 sec) mysql> select get_lock(@a, 1); …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however configure it so it consumes too…sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…sorting the secondary key tuples. If the buffer size is large enough only a single range lookup will be needed, however if the buffer size is small…buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…too big. In practice we tend to see query cache sizes that are far too big more than ones that are too small…query rates. sort_buffer_size is much improved over the past 2M but still a bit too big for…oracle.com/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is quite low, and …
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row …6GB buffer pool which is large enough to fit complete table with index (but is a bit too small…any more. Creating Index by sort is great Creating index by sort can provide over 20x …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…mysql> set global key_buffer_size=8000000; Query OK, 0 rows affected (0.03 sec) mysql> set global max_heap_table_size…too many details for you to read through here is the summary: key_buffer_size is…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…sort_buffer_size = 32k – It is interested how much this was really investigated. Indeed this is…small sorts it is indeed better to have smaller sort buffer because allocating it will likely be faster. query_cache_size…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…buffer apply – if you have small data set and it is not going to grow dramatically do not oversize innodb_buffer_pool_size…is no reason to increase sort_buffer_size…
