… conducted on Percona‘s … hypothesis. vCache vs. FlashCache -…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m… = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as…. Oracle (and Percona, and lots of others) have done great work in the last couple of years making InnoDB scale and perform…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are … smaller vs compressed xtrabackup Typically we upload mydumper backups to s3 vs xtrabackup given… dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…InnoDB buffer pool to make sure the benchmark is IO bound. That said, benchmark was running on a Percona…= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover… difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…InnoDB FT index, I made sure to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM…where I announced the webinar: We evaluated MySQL vs Solr. I was able to index all …present the popular Percona Training in Salt Lake City, September 24-27. See http://www.percona.com/…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…queries). You can see details on our Percona Wikistat benchmark Wiki. I have next … that or another page was accessed yesterday vs today. Understand specific features and characteristic of…and run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB …
