…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…size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…use for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used…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: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…MySQL versions or settings. Moreover, I have been running these benchmarks for a customer so I just used…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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…29 | 0 | | Binlog_cache_disk_use | 0 | 0 | | Binlog_cache_use | …disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…MySQL send the rows to the Binary Log Cache before writing it to the Binary Log Files. If that cache…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… improvement as it uses disk I/O anyway. …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…was MyISAM for disk tables and HEAP for in memory tables. So first MySQL versions did …related. expire_logs_days This is replication/binlogging related options – when to delete binary logs…be used for temporary tables. key_cache_age_threshold, key_cache_block_size, key_cache_division_limit Key Cache/…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Binlog_cache_disk_use‘, ’145′ ‘Binlog_cache_use…used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…binlog-ignore-db=dummyData #binlog-ignore-db=edmunds #binlog-ignore-db=evox #binlog-ignore-db=jato #binlog-ignore-db=kbb binlog-ignore-db=mysql binlog-ignore-db=test #binlog…mysql_tmp/:/tmp/ # Uncomment the following if you are using BDB tables #bdb_cache_size…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… than 16K – is exact size allocated or also segment based allocation is used. Q18: Innodb Q: … difference. If you have a battery-backed disk controller cache, then the commit returns in less …use) then you’ll get group commit again. HT: I do not think so. Sergei Golubchik serialized the MySQL binlog…
