by Peter Zaitsev | Dec 24, 2014 | Insight for DBAs, MySQL
It has been a while since I have looked at InnoDB crash recovery. A lot has change in the last few years – we have serious crash recovery performance improvements in MySQL 5.5 and MySQL 5.6, we have solid state drives raising as typical high performance IO...
by Karthik Appigatla | Dec 19, 2014 | MySQL
Please note, a more up-to-date follow-up post is here: Storing UUID and Generated Columns A few years ago Peter Zaitsev, in a post titled “”There is timestamp based part in UUID which has similar properties to auto_increment and which could be used to have...
by Peter Zaitsev | Dec 17, 2014 | Insight for DBAs, MySQL
I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post I’m going to talk about one important InnoDB limitation that...
by Tom Diederich | Dec 4, 2014 | MySQL, Percona Events, Percona Live
You know you’ll be there so why not save some $$ by registering now for the Percona Live MySQL Conference & Expo 2015 (April 13-16 in Santa Clara, Calif.). Super Saver registration discounts are available through Dec. 14 at 11:30 p.m. PST. (That’s just 10...
by Peter Zaitsev | Nov 26, 2014 | Benchmarks, MySQL
Often enough I find MySQL benchmark results where the difference between results is 1% or even less and some conclusions are drawn. Now it is not that 1% is not important – especially when you’re developing the product you should care about those 1%...
by Peter Zaitsev | Nov 18, 2014 | Benchmarks, MySQL
Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA. Too bad INNODB_METRICS was...
by Terry Erisman | Nov 11, 2014 | MySQL, Percona Events, Percona Live
The Percona Live MySQL Conference in Silicon Valley (April 13-16, 2015) features a full day of tutorial sessions and three full days with keynote talks and breakout sessions from leading MySQL experts from around the world. Birds of a Feather sessions, two networking...
by Peter Zaitsev | Nov 10, 2014 | MongoDB, MySQL
I visited MongoDB Day in London on November 6. Here are a few observations: App-Developer Centric. It is interesting to see how much MongoDB is about developers; the ops side is something which is a necessary evil developers have to deal with. The ops topics covered...
by Tom Diederich | Oct 22, 2014 | MySQL, Percona Live
The countdown is on for Europe’s largest annual MySQL event, Percona Live London 2014. The two days of technical tutorials and sessions, November 3-4, will focus on the latest MySQL industry trends, news, best practices – and a look at what’s on the...
by Peter Zaitsev | Oct 20, 2014 | Insight for DBAs, MySQL, Percona Events, Percona Live
Autumn is a season of MySQL-related conferences and I’m about to hit the road to speak and attend quite a few of them. This week I’ll participate in All Things Open, a local conference for me here in Raleigh, N.C. and therefore one I do not have to travel...
by Peter Zaitsev | Oct 17, 2014 | MySQL, Percona Software
In many write-intensive workloads Innodb/XtraDB storage engines you may see hidden and dangerous “debt” being accumulated – unpurged transaction “history” which if not kept in check over time will cause serve performance regression or...
by Peter Zaitsev | Oct 10, 2014 | MySQL, Percona Software
MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it...
by Peter Zaitsev | Sep 25, 2014 | MySQL, Percona Events
I’m excited to once again be heading to San Francisco next week for Oracle OpenWorld, and also very pleased to have a booth there this year along with some great speakers from Percona. The scope of Oracle OpenWorld 2014, which runs Sept. 28-Oct. 2, is enormous...
by Peter Zaitsev | Jul 30, 2014 | Insight for DBAs, MySQL
As we know different storage engines in MySQL have different file structures. Every table in MySQL 5.6 must have a .frm file in the database directory matching the table name. But where the rest of the data resides depends on the storage engine. For MyISAM we have...
by Peter Zaitsev | Jun 9, 2014 | Insight for Developers, MySQL, Webinars
The architecture of MySQL-powered applications is one of my favorite topics to talk about. It’s a very important topic because if you do not get the architecture right then you’re very likely to fail with your project – either from the standpoint of...
by Peter Zaitsev | Jun 3, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Software
I’ve been running a benchmark today on my old test box with conventional hard drives (no raid with BBU) and noticed something unusual in the CPU utilization statistics being reported. The benchmark was run like this: sysbench --num-threads=64 --max-requests=0...
by Peter Zaitsev | May 29, 2014 | Insight for DBAs, MySQL
MySQL has status variables “questions” and “queries” which are rather close but also a bit different, making it confusing for many people. The manual describing it might not be very easy to understand: Queries The number of statements executed...
by Peter Zaitsev | Apr 21, 2014 | MySQL
Later this week I’m excited to depart on a trip to South America. First I will stop in Montevideo, Uruguay, to meet with Percona’s team out there as well as to participate in our next Percona University event on April 29. For those who do not know, Percona...
by Peter Zaitsev | Apr 14, 2014 | MySQL
Over the last few days, the Percona team has spent a lot of time evaluating the impact of the Heartbleed bug (CVE-2014-0160) for our customers and for the users of our software. We published a formal disclosure a few days ago. However, I thought a quick summary and...
by Peter Zaitsev | Mar 24, 2014 | Insight for DBAs, MySQL, Webinars
I’m looking forward to Wednesday’s joint webinar on MySQL clustering technologies with Matt Aslett, research director of data management and analytics over at 451 Research. We’ll be participating in a live, in-depth discussion of MySQL Clustering for...
