by Baron Schwartz | Dec 16, 2009 | MySQL, Percona Events
We’re hiring. We are looking for the following qualifications: Expert knowledge of MySQL. Not just “certified” — years of production experience with it. You need to know server internals, for example. You need to be able to do anything from...
by Tokutek | Dec 16, 2009 | MySQL
Last week Tokutek released version 3.0.0 of TokuDB, adding ACID transactions to its list of features. This post discusses an experiment we ran to measure recovery time following a system crash. In summary, while actively inserting records into a MySQL database using...
by Peter Zaitsev | Dec 15, 2009 | Insight for Developers, MySQL
When we’re looking at mk-query-digest report we typically look at the Queries causing the most impact (sum of the query execution times) as well as queries having some longest samples. Why are we looking at these ? Queries with highest Impact are important...
by John.Partridge | Dec 15, 2009 | MySQL
Tokutek is pleased to announce the beta launch of TokuDB for MySQL, version 3.0. Many of our customers have asked for transaction capabilities to provide the data integrity their businesses require and in this release we provide: Full support for ACID compliant...
by Peter Zaitsev | Dec 13, 2009 | MySQL, Percona Events
As the deadline for EC to decide if Oracle can acquire Sun and hence MySQL is coming up the tensions seems to heat up. Monty posts his open letter calling for help lobbying EC to stop Oracle from buying MySQL .
by Baron Schwartz | Dec 11, 2009 | MySQL, Percona Events
Now that O’Reilly has announced they’re going to have a MySQL conference independently of Sun/MySQL, we have decided not to proceed with plans for our own Performance Conference. We are participating in the O’Reilly conference, and we will do...
by Ryan Lowe | Dec 10, 2009 | Benchmarks, Cloud, MySQL
Peter took a look at Redis some time ago; and now, with the impending 1.2 release and a slew of new features, I thought it time to look again. One of the more interesting features in 1.2 is the ability to operate in “append-only file persistence mode”,...
by Aleksandr Kuzminsky | Dec 9, 2009 | MySQL, Percona Software
Dear Community, As of today release 1.0 is available. In this release there are following changes: Changelog: XtraBackup is ported to Windows. The .MSI package as well as .tar.gz is available for 32 bit platform Be more verbose on reporting scp errors Fixed bugs: Bug...
by Baron Schwartz | Dec 9, 2009 | Insight for Developers, MySQL
I can think of at least two major reasons why systems delay flushing changes to durable storage: 1. So they can do the work when it’s more convenient. 2. So they can do less work in total. Let’s look at how the second property can be true. A commenter on...
by Vadim Tkachenko | Dec 8, 2009 | Benchmarks, MySQL
I posted about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The problem was that FusionIO did not provide durability or results were too bad in strict mode, so I lost interest FusionIO for couple month. But I should...
by Peter Zaitsev | Dec 5, 2009 | Benchmarks, Insight for DBAs, MySQL
I had an interesting case recently. The customer dealing with large MySQL data warehouse had the table which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance was extremely slow. I turned out it is caused by hundreds of daily...
by Devananda van der Veen | Dec 4, 2009 | Benchmarks, MySQL
I recently had the chance to witness the effects of innodb_adaptive_flushing on the performance of InnoDB Plugin 1.0.5 in the wild, which Yasufumi wrote about previously here and here. The server in question was Solaris 10 with 8 disk RAID10 and 2 32GB SSDs used for...
by Peter Zaitsev | Dec 4, 2009 | Insight for Developers
Sphinx 0.9.9 is finally released to General Availability. The previous version 0.9.9-rc2 was released back in April so there was quite a gap. This release fixes about 40 bugs which are mostly rare or insignificant. Fixing bugs in 0.9.9 was smaller portion of work done...
by Peter Zaitsev | Nov 30, 2009 | Percona Events
I thought I should praise Innodb team for all the work they have been doing recently. We see a lot of cool stuff happening, especially in the area of our interest which is Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and...
by Peter Zaitsev | Nov 26, 2009 | Benchmarks, Insight for DBAs, MySQL
In my previous post I looked into how large table_cache actually can decrease performance. The “miss” path is getting more expensive very quickly as table cache growths so if you’re going to have high miss ratio anyway you’re better off with...
by Peter Zaitsev | Nov 21, 2009 | MySQL, Percona Events
MySQL Performance Blog (and percona.com too) were down today because the switch in our rack died completely. It took a while to fix it using secondary switch we had. Provider was not willing to do it as remote hands so I had to drive to the data center to fix it. We...
by Morgan Tocker | Nov 20, 2009 | Insight for Developers, MySQL
Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul! What’s the “ideal” use case for the...
by Peter Zaitsev | Nov 20, 2009 | Insight for DBAs, MySQL
There is the rare bug which I ran into every so often. Last time I’ve seen it about 3 years ago on MySQL 4.1 and I hoped it is long fixed since… but it looks like it is not. I now get to see MySQL 5.4.2 in the funny state. When you see bug happening you...
by Peter Zaitsev | Nov 18, 2009 | Insight for DBAs, MySQL
Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in...
by Aleksandr Kuzminsky | Nov 18, 2009 | MySQL, Percona Software
Dear Community, We are pleased to present the 20th build of MySQL server with Percona patches. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible...
