…,1000,2000 –iterations=10 –number-int-cols=6 –number-char-cols=6 –auto-generate-sql-secondary-indexes=3 –auto-generate-sql –csv…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
(This is part one of a two part series) Over the past few weeks I have been looking at a preview release of Virident’s vCache software, which is a kernel module and set of utilities designed to provide functionality similar to that of FlashCache. In particular, Virident engaged Percona to do a …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… of threads started by XtraBackup when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup has implemented Encrypted Backups…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… in Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means typically on a single…
Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 14, 2013 By 5 Comments
… http://www.percona.com/doc/percona-xtradb-cluster/wsrep-system-index.html However, its value is checked only during SST, I…
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
Yasufumi – it is very nice to hear from you. Linkbench can also be a good test to find performance stalls from the index lock. I think the published version of linkbench partitions the link table. Remove that and the index lock limits performance for IO-bound workloads.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… 1 for some N. Eventually you change from having all index blocks for all tables in memory to not and then…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
…-data-recovery:start . The biggest challenge here is to find index_id for each table – http://www.percona.com/docs/wiki…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5.6.11 in this IO bound…-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… SELECT by PK or some range query by a secondary index? I heard that TokuDB is slower than InnoDB on SELECT…
