…_open_cache = 10240 max_allowed_packet = 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 = 0 query_cache_type = 0…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_open_cache = 2048 max_allowed_packet = 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 = 0 query_cache_type = 0…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… default linkbench dataset has 10M ids(after load of data size of datadir ~10GB). We used this dataset to check server… threads. Then we loaded 10x dataset – 100M ids (size of datadir ~100GB), size of the buffer pool is the same – 30GB. So…_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Binlog_cache_disk_useblogpercona.commanual binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_dbblogpercona.commanual binlog_formatblogpercona.commanual binlog_ignore_dbblogpercona.commanual binlog…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_freehold_binlog sync_binlog=1 relay-log=mdmp_freehold_relaylog max_relay_log_size… binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_boonton_binlog sync_binlog=1 relay-log=mdmp_boonton_relaylog max_relay_log_size…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…: Increase the size of the /tmp partition. Increase the size of the binary log cache. binlog_cache_size and binlog_stmt_cache_size. Before 5.5.9 binlog_cache_size was used for both transactional and no transactional statements. After 5.5.9 the cache…
Comment: Filling the tmp partition with persistent connections
August 7, 2012 By 14 Comments
On 5.5.9+ you might have to increase binlog_cache_size if you are using InnoDB, or binlog_cache_stmt_size if you are using MyISAM. binlog_cache_size is used for transactional tables, binlog_cache_stmt_size for non-transactional tables
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
… \ –table_cache=2048 \ –max_allowed_packet=1M \ –binlog_cache_size=1M \ –max_heap_table_size=64M \ –sort_buffer_size=64K \ –join_buffer_size=1M \ –thread_cache=16 \ –thread_concurrency=16 \ –thread_stack=196K \ –query_cache_size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…_open_cache = 2048 max_allowed_packet = 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 = 0 query_cache_type = 0…
