… previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage… threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the hot test, the data fits in the buffer…. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…port. [Don’t try more than 2; the additional work that the kernel has to do in reordering …configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every …trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…: mysql_sandbox18676-relay-bin.000001 Relay_Log_Pos: 4 [...] As stated in the documentation, the connection parameters are still held in memory… MASTER_HOST=” trick no longer works: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql> change master to master_host… affected (0,04 sec) mysql> show slave status\G Empty set (0,00 sec) Very good! The command does work as expected without any…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this … run XtraBackup indefinitely when xtrabackup tmpdir was set up on tmpfs. Bug fixed #1086978 (Alex … been defined to throttle InnoDB access, and work load contained DDL statements, a cluster node…
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 …and Python clients when plugin-dir option was set in the [client] section of the my.cnf…has been optimized to make sure no additional work is done when userstat is disabled. Bug fixed …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…the graphs speak for themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, …time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…_commit != 1), or work around it with by fsyncing to memory (Battery or capacitor-…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL …_count % 100 == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where achievement = ‘killed_troll’”;…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc_factor=1.0″; Working with… fc_limit does however keep the certification index smaller in memory. It keeps the certification interval small, which minimizes replication conflicts…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… and feature-set comparison between vCache and FlashCache and also to conduct some benchmarks for the use case where the MySQL working set is… building a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and then further… be written to the backing store, whereas FlashCache has a setting called “fallow_delay”, defined in the documentation as the time…
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 …and Python clients when plugin-dir option was set in the [client] section of the my.cnf…has been optimized to make sure no additional work is done when userstat is disabled. Bug fixed …
