…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…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…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…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_binlog_cache_sizeblogpercona.commanual max_binlog_dump_eventsblogpercona.commanual max_binlog_sizeblogpercona.commanual max_binlog_stmt_cache_sizeblogpercona.commanual max_connect_errorsblogpercona.commanual max_connectionsblogpercona.commanual max_delayed_threadsblogpercona.commanual max…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_…innodb_io_capacity = 200 port = 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…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…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb…innodb_read_io_threads = 16 join_buffer_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_stmt_count=1000000 query_cache_size…
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…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Binlog_cache_disk_use’, ’145′ ‘Binlog_cache…mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…Binlog_cache_disk_use | 0 | 0 | | Binlog_cache…
