by Vadim Tkachenko | Jan 13, 2010 | Benchmarks, MySQL
To continue fun with FusionIO cards, I wanted to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with 1000...
by Morgan Tocker | Nov 1, 2009 | MySQL, Percona Events
A recent photo from Highload.ru I said in my last post, that we’re interested in speaking at MySQL meetups, and I’m happy to say that the Los Angeles MySQL Meetup has taken us up on the offer. On November 18th, I’ll be giving an introductory talk on...
by Vadim Tkachenko | Oct 27, 2009 | Insight for DBAs, MySQL
First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the...
by Aleksandr Kuzminsky | Oct 25, 2009 | MySQL, Percona Software
For those who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How to use it. First make sure it is avaiable. $...
by Yasufumi Kinoshita | Oct 14, 2009 | Benchmarks, Insight for DBAs, MySQL
For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, <tuning...
by Baron Schwartz | Oct 8, 2009 | MySQL, Percona Events
I’m happy to extend a warm welcome to two new members of the Percona team. First is Yves Trudeau, about whom I can say many things: One of the top MySQL Cluster (NDB Cluster) experts in the world. An expert on all things High Availability, including DRBD and...
by Yasufumi Kinoshita | Sep 15, 2009 | Benchmarks, Percona Software
As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from physical size of the buffer pool. And the another one is oldness of the block which is from the capacity of transaction log files. In the case of heavy updating...
by Morgan Tocker | Sep 10, 2009 | Percona Events
Today’s the day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week. Our Montreal practice teach at Station-C went great – it was an opportunity to do a road test and...
by Morgan Tocker | Aug 13, 2009 | Percona Software
Note: This post is part 2 of 4 on building our training workshop. Last week I talked about why you don’t want to shard. This week I’m following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. ...
by Morgan Tocker | Aug 4, 2009 | Percona Events
Today, we are announcing that we’re ready to offer training for InnoDB and XtraDB in Santa Clara and San Francisco. The course was developed by Morgan Tocker with input from all our team – and covers a lot of the performance problems we run through in...
by Vadim Tkachenko | Aug 3, 2009 | Percona Software
If you do not follow MariaDB development, I want to head up XtraDB has been commited to MariaDB server and will be included in binary releases of MariaDB (scheduled on end of August – September) as replacement of InnoDB storage engine. MariaDB will also include...
by Vadim Tkachenko | Jul 31, 2009 | Percona Software
The feature I announced some time ago https://www.percona.com/blog/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show how to use it (the video will be...
by Aleksandr Kuzminsky | Jul 20, 2009 | Percona Software
Dear community, Today we are pleased to announce release 6 of XtraDB – the result of 2 months hard work. The release includes following new features: MySQL 5.1.36 as a base release New patch innodb_recovery_patches.patch 1 innodb_recovery_patches.patch...
by Vadim Tkachenko | Jul 14, 2009 | Benchmarks
There was small delay in our releases, part of this time we worked on features I mentioned before: – Moving InnoDB tables between servers – Improve InnoDB recovery time and rest time we played with performance trying to align XtraDB performance with MySQL...
by Vadim Tkachenko | Jul 7, 2009 | Percona Software
Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to start. Also it...
by Vadim Tkachenko | Jun 8, 2009 | Percona Software
This is probably the feature I missed most from early days when I started to use InnoDB instead of MyISAM. Since that I figured out how to survive without it, but this is first question I hear from customers who migrated from MyISAM to InnoDB – can I just copy...
by Vadim Tkachenko | May 12, 2009 | Benchmarks, Insight for DBAs
Last week we were busy to align XtraDB performance with 5.4, now we have some results. Currently it is available as “hacks” to XtraDB (available on Lauchpad lp:~percona-dev/percona-xtradb/hacks-porting-tune if you are interested). Basically we took...
by Vadim Tkachenko | May 1, 2009 | Benchmarks
As continue to my benchmarks https://www.percona.com/blog/2009/04/30/looking-on-54-io-bound-benchmarks/ on 5.4 I tried in-memory load (basically changed buffer pool from 3GB to 15GB, and database size is 10GB). The results are on the same spreadsheet...
by Vadim Tkachenko | Apr 30, 2009 | Benchmarks
With a lot of talks around 5.4 I decided to check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested it on our Dell PowerEdge R900 box (16 cores, 32GB of RAM, RAID 10 on 8 SAS...
by Peter Zaitsev | Apr 29, 2009 | Percona Events
MySQL 5.4 comes with Innodb engine which seems to have much better performance than MySQL 5.0 – this is due to locking and IO patches from Google integrated in this release (which are similar to appropriate Percona patches) as well as some unique fixes such as...
