… via crm_attribute on percona2 Stack: openais Current DC: percona1 – partition with quorum Version: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14 3… via crm_attribute on percona2 Stack: openais Current DC: percona3 – partition with quorum Version: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14 3…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… stripe the LV when we need to and align the partition correctly. We got decent tpcc performance, nearly 37k NoTPM using… gave all those drives to ZFS (30 mirrors + spares + OS partition mirror) and I limited the ARC size to 4GB. I…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… (to new schema name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… 20 partitions; they are PARTITION BY RANGE (to_days(…)). However, the ranges are uneven — older partitions cover larger timespans. The last few partitions are… similar in speed between PARTITIONed or non-PARTITIONed. When PARTITIONed, first it has to find and open the required partition, then it drills down…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… a normal table as against a partitioned table. 2. The Insert should be quicker on a partitioned table, as it will be… term to read from a partitioned table, as, depending on the size of the partitions, the whole partition can be cached, as opposed… dont do replace… ever)… if across partitions, will be slower, if in the same partition will be faster. 4. If you do…
Comment: MySQL Partitioning - can save you or kill you
April 25, 2013 By 45 Comments
Hello Peter, If i have a table with 20,000,000 rows around 50GB and if i made just simple querys like: select * from table where id = ’1549090′ Creating a partition by key(id) (30 partitions) will increase my performance for selects and inserts? Thanks
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
Mark thanks for the tip, this give me the motivation to put more efforts to explain what i saw. The same data load inside uncrompressed was good so PMP result need to follow, the only difference is the compression and range partitions. I’ll keep posting
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing_method…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking…
