… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will… spare drives per controller, I have 2 for the whole setup. A small but yet interesting saving. All put together, ZFS…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… sequential anymore, which is bad for InnoDB, but this is what I need for my setup (I still can have synthetic auto…_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush… #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark, I ran some batches… code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts…, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… our tests setup and clarifies the scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data…_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…, FlashCache still does quite well, massively outperforming the HDD-only setup, but it doesn’t even really come close to the…: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Sources, along with a very nice description of how to setup and run this benchmark, can be found here. We decided… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool… draw between vCache and FlashCache. Ease of basic installation. The setup process was simply a matter of installing two RPMs and… the vCache documentation is superior. Winner: vCache. Ease of post-setup modification / advanced installation. Many of the FlashCache device parameters can…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add “vm…, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of… few minutes, enough to cause serious issues to the pacemaker setup the server is one of the nodes. That caused resource…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs… addition as part of Percona’s Remote DBA installation and setup of these tools are included with our services. You can…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
… for now is support of InnoDB-plugin, which as we know performs much better than standard InnoDB ®. So what is so interesting… it will provide 
, but efforts on test setup and deployment should be comparable with MMM setup. – Scale Writes. Galera allows to write… independent, and it’s only matter of database drivers. For InnoDB currently it is set of patches, and I see it…
