…’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With … Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the… doesn’t compress well showed a compression ration of 1.70 with gzip-1. Real data will compress much more… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if … in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…-tables and insert a few rows into an InnoDB table, but trying to run a simple …
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… is not an easy move for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to…
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… datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file…
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);…ms/op) InnoDB fetch operation was 20% higher (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 …
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… why Facebook has their own InnoDB compression, which is available in MySQL 5.6. So we may test MySQL 5.6 more to see…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…. Using InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case… innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot be compressed…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
… trying standard Innodb page size, 4KB page size as 16K page size compressed to 4. The data in this case compresses perfectly (all…. Compression results come as a huge disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed pages…, though I expect results for 16K and 16K Compressed to be very similar on MySQL 5.5 As a summary: If you…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this will report us… compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…
