by Aleksandr Kuzminsky | Mar 24, 2010 | MySQL, Percona Software
Dear Community, It is time to announce the next version of backup software from Percona – XtraBackup 1.1. The list of changes in version 1.1 includes: Changelog: XtraBackup is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0.6 Added –host option...
by Vadim Tkachenko | Mar 23, 2010 | MySQL
As soon as we get couple FusionIO cards, there is question how to join them in single space for database. FusionIO does not provide any mirroring/stripping solutions and totally relies on OS tools there. So for Linux we have software RAID and LVM, I tried to followup...
by Vadim Tkachenko | Mar 20, 2010 | MySQL, Percona Software
In Released and new coming features I did not mentioned two additional INFORMATION_SCHEMA tables available in XtraDB: It is INNODB_TABLE_STATS INNODB_INDEX_STATS These table show statistics about InnoDB tables ( taken from InnoDB data dictionary). INNODB_TABLE_STATS...
by Peter Zaitsev | Mar 19, 2010 | Benchmarks, Insight for DBAs, MySQL
So you’re running the benchmark/stress test – how do you tell if MySQL server is really loaded ? This looks like the trivial question but in fact, especially when workload consists of simple queries I see the load generation and network really putting a...
by Vadim Tkachenko | Mar 17, 2010 | MySQL, Percona Software
Recently Alexandr announced new Percona-XtraDB-9.1 release, and now it is good time to summarize features we have and what is expected soon. This release contains long waited features from 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS (...
by Baron Schwartz | Mar 15, 2010 | MySQL, Percona Events
Many Percona employees will be at the 2010 MySQL conference. We’ll be giving a lot of informative technical talks on various topics. Here’s a list: Morgan Tocker, Baron Schwartz: Diagnosing and Fixing MySQL Performance Problems Peter Zaitsev: Scaling...
by Aleksandr Kuzminsky | Mar 14, 2010 | MySQL, Percona Software
Dear Community, We are announcing today the new version 9.1 of XtraDB storage engine. The name of binaries has changed to Percona-XtraDB. It is applicable to all packages including RPM, DEB and tar.gz packages. New features in version 9.1: MySQL 5.1.43 is taken as the...
by John.Partridge | Mar 5, 2010 | MySQL
Matt Aslett over at The 451 Group has written a Market Development report entitled “Tokutek delivers ACID transaction support with TokuDB version 3.0.” Get the full report and you can try out The 451 Group’s services for free by visiting...
by Vadim Tkachenko | Mar 4, 2010 | Benchmarks, MySQL
I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on FusionIO card. It should be easy to test, let’s take sysbench fileio benchmark and run, the next command should make it: ./sysbench --test=fileio --file-num=1...
by John.Partridge | Mar 3, 2010 | MySQL
One of Profile Technology Ltd.’s most popular applications is their Advanced Search function for Facebook. Find out how TokuDB v3.0 dramatically increased their insertion speed performance in our new Case Study.
by Vadim Tkachenko | Feb 28, 2010 | Benchmarks, MySQL
I recently was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good questions, though not easy to answer, as it depends on: – durability setting (...
by Vadim Tkachenko | Feb 28, 2010 | MySQL
Oracle recently announcent MySQL-5.5.2-m2 milestone, and I have a predition that MySQL-5.5 will be announced as GA on MySQL UC 2010 in April. So let’s make quick on scalability characteristics we should expect from new release. I made sysbench oltp benchmarks on...
by Baron Schwartz | Feb 28, 2010 | Insight for DBAs, MySQL
I have not caused a fist fight in a while, so it’s time to take off the gloves. I claim that somewhere around of 99% of advice about tuning MySQL’s key cache hit ratio is wrong, even when you hear it from experts. There are two major problems with the key...
by Vadim Tkachenko | Feb 25, 2010 | MySQL
Running many benchmarks on fast storage (FusionIO, SSDs) and multi-cores CPUs system I constantly face two contention problems. So I suspect it’s going to be next biggest issues to make InnoDB scaling on high-end system. This is also reason why in benchmarks I...
by John.Partridge | Feb 23, 2010 | MySQL
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 3.0. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties. TokuDB v3.0 combines our...
by Peter Zaitsev | Feb 15, 2010 | Insight for DBAs, MySQL
As I wrote about 2 years ago the feature of Innodb to store copy of master’s position in Slave’s Innodb tablespace got broken. There is a lot of discussions at the corresponding bug report while outcome of the fix remained uncertain for me (the bug is...
by Vadim Tkachenko | Feb 11, 2010 | Benchmarks, MySQL
Question what is better isolation level is poping up again and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level ? and in Repeatable read versus read committed for InnoDB . Serge in his post explains...
by Peter Zaitsev | Feb 9, 2010 | Insight for DBAs, MySQL
I’m running in this misconception second time in a week or so, so it is time to blog about it. How blobs are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we look into how BLOBs are really stored lets...
by Vadim Tkachenko | Feb 9, 2010 | MySQL, Percona Software
Our patches for 5.0 have attracted significant interest. You can read about SecondLife’s experience here, as well as what Flickr had to say on their blog. The main improvements come in both performance gains and improvements to diagnostics (such as the...
by Vadim Tkachenko | Feb 8, 2010 | Benchmarks, MySQL
We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that’s just single workload. That’s why we are looking into different benchmarks, and one of them is TPCE. Yasufumi made some efforts to make TPCE...
