…/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size=6M MariaDB 5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… query_cache_type=1 query_cache_size=32M thread_cache_size=30 table_cache=4096 join_buffer_size=6M key_buffer_size=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the variable read_rnd_buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in… lookups as well. But this works only with joins and specifically with Block Access Join Algorithms. So I am not going to…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… “max size” and the corresponding buffers are allocated only as big as needed (key_buffer_size). There are many examples of this. What about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size the other…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Innodb_buffer_pool_read_requestsblogpercona.commanual Innodb_buffer_pool_readsblogpercona.commanual innodb_buffer_pool_sizeblogpercona.commanual Innodb_buffer_pool_wait_freeblogpercona.commanual Innodb_buffer_pool…_write_io_threadsblogpercona.commanual insert_idblogpercona.commanual interactive_timeoutblogpercona.commanual join_buffer_sizeblogpercona.commanual keep_files_on_createblogpercona.commanual Key_blocks_not…
Comment: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…*(thread_stack + join_buffer_size + sort_buffer_size + binlog_cache_size…) is so much misleading. In particular, the join_buffer_size, sort_buffer_size are interesting to note: sort_buffer_size is only used when sorting without index join_buffer_size is only used when joining without index…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… currently works with MyISAM tables these are MyISAM related. join_buffer_size Buffer used for joins without indexes and few other cases. It is used by SQL layer so applies to all storage engines. key_buffer_size Key Buffer…. 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 for MyISAM…
Comment: MySQL: what read_buffer_size value is optimal ?
September 21, 2008 By 25 Comments
… in my my.cnf: key_buffer_size = 256M sort_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K join_buffer_size = 128K myisam_sort_buffer_size = 128K and restarted the… the my.cnf): key_buffer_size 268435456 sort_buffer_size 131064 read_buffer_size 126976 read_rnd_buffer_size 126976 join_buffer_size 126976 myisam_sort_buffer_size 131072 The key_buff shows…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-xtrabackup=1 innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum…-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log… partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… join_buffer_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size=64M transaction…
