… Server 5.5.30-rel30.1-465. Each test was allowed to run for 7200 seconds, and the first 3600 seconds… the rest? My hypothesis here is that time-based flushing allows the backing store to be written to at a more… = 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
…_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads=32 –rand-type=pareto… = 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…
Comment: New variable slave_max_allowed_packet for slave servers
April 30, 2013 By 2 Comments
Seems to be a bug, if you have binlog_format=STATEMENT (and probably MIXED as well) MySQL still looking to max_allowed_packet but it report on slave_max_allowed_packet http://bugs.mysql.com/bug.php?id=69104
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… 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
… reconnect, it would report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… guide me, is it safe values ? or can i increase (max_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size = 128…/or max_heap_table_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not allow…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… approach with this sort of use case, I’m effectively allowing my database to run in memory (not actual RAM, that…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… Flexibility: Both solutions share many features here; both of them allow whitelisting and blacklisting of PIDs or simply running in a…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… writing it may be ok, but not if your HA allowed writes (however briefly) to hit multiple nodes during a writer…
