… and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and used the version available here. But I changed the table to use range partitioning. I defined a… concerned with write performance is using partitioning to reduce the size of the B+tree, having multiple buffer pool instances to reduce…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… limitation from previous versions where it was only possible to stream full backups. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed. Parallel compression (‘–compress-threads’) can be used…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… parallel way, thus utilizing multiple CPU cores if needed. In previous versions, compression was only possible… other limitations (e.g. could not be used with parallel file copying, it was required… the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…use Percona’s PAM plugin. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL…, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, …for MySQL users. Users now have more choice than ever — there are three great versions of MySQL…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…, at least we can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by…. Instead we could track versions for tables (increment each time table is updated) and check whenever version matches for all tables on… from Multiple Misses So you have item invalidated from query cache and there are multiple connection requesting the same item. What MySQL will…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… storage engines, but really this is not enough as MySQL allows you using multiple storage engines in the query you need to test… multiple storage engines very actively because of potential complications involved. Now lets think what we could have if we have a version of MySQL Server which drops everything but Innodb Storage engine (it…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… multiple instances of MySQL to gain better performance on Fusion-io ioDrive card. Full report is available in PDF For tests we used… workload on MySQL systems. Server hardware: Dell PowerEdge R815 Storage: Fusion-io ioDrive Duo 640GB MLC. Fusion-io driver version: 2.3… separate database into multiple instances you may try 2-4 instances setup to get better overall throughput from your MySQL setup Recently…
Post: Crashes while using MyISAM with multiple key caches
July 18, 2009 By Leave a Comment
… to multiple key caches but to online key cache resize. It is just this code most actively used in case you’re using multiple… so not all people using the feature will run into the bug – In my practice number of people using multiple key caches with… these versions still have it. Or may be have some special bug status to indicate it was fixed only in later MySQL versions…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads too, although using more… setting–multiple purge thread implementation at the moment seems to be the one in Percona Server 5.1. MySQL 5.6.2 multiple… solve them. However, MySQL 5.6.2 is experimental code and I am sure that next MySQL 5.6 versions will contain a…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… build indexes in parallel by running sorts in different threads – using multiple cores becomes increasingly important as their number per CPU just… MySQL 5.2 or even MySQL 5.1. I surely would like to see it sooner at least in more flexible community version… Mark Callaghan from Google released so many MySQL patches so we can call patched version GoogleSQL. Among them there are number of…
