… in the graph as the blue line – SSD config) which shows the most consistent performance. The others all have assorted performance… = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… stable, that is why I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and… = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… reconnect, it would report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… reconnect, it would report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
…, 4510080 rows affected (26.89 sec) After some time the SHOW SLAVE STATUS on MasterA gives us this output: Last_IO… when reading data from binary log: ‘log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event ‘mysql-bin.000002′ at… they are never larger than the max_allowed_packet 
Therefore, a read_buffer_size value larger than max_allowed_packet can break your replication while importing…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_allowed_packetblogpercona.commanual max_binlog_cache_sizeblogpercona.commanual max_binlog_dump_eventsblogpercona.commanual max_binlog_sizeblogpercona.commanual max_binlog_stmt_cache_sizeblogpercona.commanual max…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M… just describe few less interesting numbers first, then I’ll show graphs for more interesting results. Let me know if you…: Here’s same test with WB cache: And just to show you the difference between sequential writes with WT cache and…
Comment: How does MySQL Replication really work?
January 10, 2013 By 9 Comments
Akshay, – Replication uses its own protocol. “show binlog events” command is mostly to be used by DBAs. ….5.26 there’s a new variable slave_max_allowed_packet which takes precedence over max_allowed_packet for a single event. Binlog Dump is the…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime… ip” field is selected in the list of columns to show (click show/hide to change the columns) That the “public dns…-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #we value throughput over response…
Comment: What to tune in MySQL Server after installation
October 6, 2006 By 118 Comments
… ratio only between 40-50%). My current settings: [mysqld] max_connections = 300 max_user_connections = 300 key_buffer = 16M myisam_sort_buffer… interactive_timeout = 25 wait_timeout = 30 connect_timeout = 10 max_allowed_packet = 2M max_connect_errors = 1000 query_cache_limit = 1M query_cache_size = 12M query_cache_type = 1 tmp_table_size = 110M safe-show…
