… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… the flush operation will take some time to complete. Compression ZFS can compress data on the fly and it is surprisingly cheap… data that doesn’t compress well showed a compression ration of 1.70 with gzip-1. Real data will compress much more. That…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… so I was likely not hitting a bottleneck caused by compression. If I use SSD for L2ARC, I’ll need to… for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… difference easily makes up the difference. Add to that the compression gain from ZFS and there really no cost difference. ZFS… write buffering, so make sure these are turned off in InnoDB.
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the… of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… was able to get good results with InnoDB compression. Usually it was worse than without compression. So far I can say that I’ve seen only one specific use case useful with InnoDB compression: i.e… big performance hit. That’s why Facebook has their own InnoDB compression, which is available in MySQL 5.6. So we may…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
… InnoDB are limited to a few workloads. For pure-flash servers the advantages of TokuDB are universal — 2X better compression (compared to InnoDB compression…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… data compression on this dataset. We can easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance…_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
…’192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression‘ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts);…are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% …
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
Vadim, can you confirm negative scalability with InnoDB compression and multi value inserts ?
