… # performance sort_buffer_size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M… # performance sort_buffer_size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_read_first’, ’1100773′ ‘Handler_read_key’, ’2491307870′ ‘Handler_read_next’, ’1266206297′ ‘Handler_read_prev’, ’0′ ‘Handler_read_rnd‘, ’234159075′ ‘Handler_read_rnd_…buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…’ optimizer_switch=’mrr_cost_based=off’ read_rnd_buffer_size=32M optimizer_switch=’batched_key_access=on’ join_buffer_size=32M MariaDB 5.5.20 Configuration…_buffer_size‘ controls the size of the join buffer allocated for each join in a query, MariaDB introduces another variable to control the size of…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-buffer-length=16K #we value throughput over response time, get a good 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 sql-mode=STRICT_TRANS…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… open_files_limit = 9216 tmp_table_size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048… #safe-updates [isamchk] 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 = 2M #[mysqlhotcopy] interactive…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options 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 = 10G myisam_repair…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory might be allocated. But they are only… example subqueries – each layer may need its own read_buffer,sort_buffer, tmp_table_size etc Many variabes can be set per connection. So…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size…/mysqld.pid [isamchk] 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 = 2M [mysqlhotcopy] interactive…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 log-bin=mysql-bin #innodb_buffer…
