…the database optimizer. The …mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size…buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? …_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer to optimize data retrieval – As data is … reading into read_rnd_buffer in the sorted order – it can be pretty much sequential if you’re lucky. The read_rnd_buffer_size is important (optimization …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and…commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona…sizeblogpercona.commanual read_buffer_sizeblogpercona.commanual read_onlyblogpercona.commanual read_rnd_buffer_sizeblogpercona.commanual…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…=on’ optimizer_switch=’mrr_sort_keys=on’ (only on MariaDB 5.5) optimizer_switch=’mrr_cost_based=off’ read_rnd_buffer_size=4M (only on MySQL 5.6) mrr_buffer_size=4M (only on MariaDB 5.5) We have turned off ICP optimization for the…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…buffer_size – Used by MyISAM tables only to optimize…read_buffer_size, read_rnd_buffer_size – Variables used as read buffer for MyISAM tables for Full Table Scan (read_buffer) and for reading rows in sorted order (read_rnd_buffer_size…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… not as well optimized with them as it could be which makes it better to disable them. The MySQL Settings are probably…_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size…buffer_size bytes of memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=… plan optimizer-prune-level=0 partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K …
