by Peter Zaitsev | Nov 18, 2011 | MySQL, Percona Software
When I started with MySQL 3.22 I would start running MySQL from early beta (if not alpha) and update MySQL the same date as release would hit the web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical...
by Bill Karwin | Nov 18, 2011 | Insight for DBAs, MySQL
We’re told that foreign key constraints are the best way to enforce logical referential integrity (RI) in SQL, preventing rows from becoming orphaned. But then we learn that the enforcement of foreign keys incurs a significant performance overhead.1,2 MySQL...
by Tokutek | Nov 17, 2011 | MySQL
Thanks to everyone who signed up and attended the webinar I gave this week with Tim Callaghan on Scaling MySQL. For those who missed it and are interested, the video and slides are now posted here. A brief description of the webinar is also below. MySQL...
by Stewart Smith | Nov 17, 2011 | MySQL
I’ve just arrived at ANU in Canberra for the Open Source Developers Conference 2011 (OSDC). I’ve spoken at several of the past OSDCs that have been held around Australia: 2005, 2007, 2008, 2010 and now 2011. It’s one of those conferences with great...
by Peter Zaitsev | Nov 17, 2011 | Cloud, MySQL
My friends at Sphinx Technologies have finally released new beta of Sphinx – Sphinx 2.0.2. It includes about 6 months of development and includes over 30 new features and tons of bug fixes. I’m happy to see how Sphinx 2.0 is shaping up a lot of rough...
by patrick.crews | Nov 16, 2011 | Benchmarks, MySQL
I tend to speak highly of the random query generator as a testing tool and thought I would share a story that shows how it can really shine. At our recent dev team meeting, we spent approximately 30 minutes of hack time to produce test cases for 3 rather hard to...
by patrick.crews | Nov 16, 2011 | Benchmarks
So I’m back from the Percona dev team’s recent meeting. While there, we spent a fair bit of time discussing Xtrabackup development. One of our challenges is that as we add richer features to the tool, we need equivalent testing capabilities. However, it seems a...
by Vadim Tkachenko | Nov 15, 2011 | Hardware and Storage, Insight for DBAs, MySQL
As MLC-based SSD cards are raising popularity, there is also a raising concern how long it can survive. As we know, a MLC NAND module can handle 5,000-10,000 erasing cycles, after which it gets unusable. And obviously the SSD card based on MLC NAND has a limited...
by Peter Zaitsev | Nov 13, 2011 | Benchmarks, Insight for DBAs, MySQL
When we’re looking at benchmarks we typically run some stable workload and we run it in isolation – nothing else is happening on the system. This is not however how things happen in real world when we have significant variance in the load and many things...
by Tim.Callaghan | Nov 11, 2011 | MySQL
This version includes support for “SELECT … FOR UPDATE” as well as displaying table “create time” and “last update time” via “SHOW TABLE STATUS”. The release also addresses a number of other bugs and fixes such as “point...
by Vadim Tkachenko | Nov 10, 2011 | Benchmarks, Hardware and Storage, MySQL
I have been following Virident for a long time (e.g. https://www.percona.com/blog/2010/06/15/virident-tachion-new-player-on-flash-pci-e-cards-market/). They have great PCIe Flash cards based on SLC NAND. I always thought that Virident needed to come up with an MLC...
by Peter Zaitsev | Nov 7, 2011 | MySQL, Percona Events
We had a lot of great technical presentations at Percona Live, London If you did not have a chance to attend or if you did but could not be at 5 rooms at the same time you can check out slides which have been just made available for download for most of the talks....
by Alexey Kopytov | Nov 6, 2011 | Benchmarks, Insight for DBAs, MySQL
One of the serious limitations in the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE or CREATE INDEX. Peter has already blogged about it before, here I’ll just briefly...
by kuszmaul | Nov 4, 2011 | MySQL
I’ll be talking about How Fractal Trees Work today at MIT in the Computational Research In Boston and Beyond (CRIBB) seminar (http://www-math.mit.edu/crib/2011/nov4.html). The talk is at 12:30 in the Stata Center room 32-141. Pizza available before. This talk...
by Baron Schwartz | Nov 4, 2011 | Insight for DBAs, MySQL
Global transaction IDs are being considered for a future version of MySQL. A global transaction ID lets you determine a server’s replication position reliably, among other benefits. This is great when you need to switch a replica to another master, or any number...
by Tokutek | Nov 3, 2011 | MySQL
MySQL implementations are often kept relatively small, often just a few hundred GB or less. Anything beyond this quickly leads to painful operational problems such as poor insertion rates, slow queries, hours to days offline for schema changes, prolonged downtime for...
by Tokutek | Nov 1, 2011 | MySQL
I had the pleasure of being invited to blog at the MassTLC unConference on Friday. The event was a full day of diverse topics and discussions ranging from the latest in recipe sharing sites, to entrepreneurial CEO war stories, to hot trends in venture...
by David Hildebrandt | Oct 31, 2011 | MySQL, Percona Events
If you have been waiting for Percona’s highly rated MySQL courses to be taught near you, your wait is over. We will be holding our Developer, DBA, InnoDB, and Operations training in the following cities: Dublin, Ireland – December 5 – 8, 2011 San...
by Vadim Tkachenko | Oct 25, 2011 | MySQL, Percona Software
We are happy to see that Percona Server/XtraDB and XtraBackup are raising popularity and to keep excitement we want to have more features and more performance fixes! If you are experienced software engineer and feel strong enough to hack InnoDB/XtraDB code we invite...
by kuszmaul | Oct 25, 2011 | MySQL
Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes; changing schemas without downtime; and supporting...
