…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: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…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_max_extra_sort_file_size…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…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 …
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…size = 192M max_heap_table_size = 192M max_allowed_packet = 64M #max_connect_errors = 10000 read_rnd_buffer_size = 8M bulk_insert_buffer_size…
Comment: What to tune in MySQL Server after installation
October 6, 2006 By 118 Comments
… tables created are disk based. (as compared to my key_buffer allocation, for instance, which only has 16mb assigned to it…_user_connections = 300 key_buffer = 16M myisam_sort_buffer_size = 16M read_rnd_buffer_size = 1M join_buffer_size = 2M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1000 thread_cache_size = 200 interactive_timeout…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-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…-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
…_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…buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M …
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… = 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-… = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb_flush_log_…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
… = 16M back_log = 200 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=30M key_buffer_size=129M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K #*** INNODB…
