…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…memory workload. Also BKA relies on both the join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size and both of these buffers…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…=’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… entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections”. This was …memory for InnoDB: specifically, the buffer pool. (There’s also an innodb_additional_mem_pool_size…, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…key_buffer_sizeblogpercona.commanual key_cache_age_thresholdblogpercona.commanual key_cache_block_sizeblogpercona.commanual key_cache_division_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will … innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-…ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…MEMORY tables. preload_buffer_size – Buffer used for Key preloading, which works for MYISAM tables only. read_buffer_size, read_rnd_buffer_size – Variables used as read buffer…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… work as MySQL DBAs or be involved with MySQL Performance …key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer…. query_cache_size If your application is read intensive and… increase sort_buffer_size even if you have 64GB of memory to waste…
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
…sort_buffer_size – recently I worked with case which was running much faster with 32K sort_buffer_size, compared to 32M. The problem was memory allocation – sorting…read_buffer_size and read_rnd_buffer_size – These are buffers used by MyISAM to perform reads…
