by Peter Boros | Oct 28, 2012 | MySQL, Percona Software
Thanks for all, who attended my webinar, I got many questions and I wanted to take this opportunity to answer them. Q: Even ntp has a delay of 0.3-0.4 between servers does that mean a 0.25 as from logs can be an issue ? A: My demo vms were running for a few hours...
by Ernie Souhrada | Oct 27, 2012 | Insight for DBAs, Insight for Developers, MySQL
A few weeks back, I was working on a customer issue wherein they were observing database performance that dropped through the floor (to the point of an outage) roughly every 4 weeks or so. Nothing special about the environment, the hardware, or the queries; really,...
by Hrvoje Matijakovic | Oct 26, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.1.66-14.1 on October 26th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14.1 is now the...
by Hrvoje Matijakovic | Oct 26, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.28-29.1 on October 26th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.1 is now the...
by Vadim Tkachenko | Oct 25, 2012 | Benchmarks, Hardware and Storage, MySQL, Percona Software
The idea to use SSD/Flash as a cache is not new, and there are different solutions for this, both OpenSource like L2ARC for ZFS and Flashcache from Facebook, and proprietary, like directCache from Fusion-io. They all however have some limitations, that’s why I...
by Miguel Angel Nieto | Oct 25, 2012 | Insight for DBAs, MySQL
If you are planning to upgrade or make any configuration change on your MySQL database the first advice usually is: – Benchmark! How should we do that benchmark? People usually run generic benchmark tools like sysbench, tpcc or mysqlslap that are good to know...
by Frederic Descamps | Oct 25, 2012 | MySQL, Percona Events
“devops” seems to be everywhere now, or at least everyone is talking about it. But what does that really mean? And how does the DBA integrate the movement ? During next week’s webinar, I will explain to you the big principles of the devops culture...
by Mike Benshoof | Oct 24, 2012 | Cloud, MySQL
Well, it happened again… Another lengthy EBS outage in the US-East region impacted several sites across the net. While failures like this are rare, they can be quite costly and translate into headaches for the operations team when impact production systems for...
by Terry Erisman | Oct 24, 2012 | MySQL, Percona Events
I’m pleased to announce special bundled hotel/conference pass packages for the Percona Live London MySQL Conference which is December 3-4, 2012 at The Millennium Gloucester Conference Centre in London. The conference features tutorials December 3rd and breakout...
by Roel Van de Paar | Oct 23, 2012 | Benchmarks, Insight for DBAs, Percona Events, Percona Software
Continuous integration of new features and bug fixes is great – but what if a small change in seemingly insignificant code causes a major performance regression in overall server performance? We need to ensure this does not happen. That said, performance...
by Tim.Callaghan | Oct 22, 2012 | MySQL
At tomorrow’s NoVA MySQL October Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use Cases.” The meetup is 7 pm Tuesday, October 23, 2012, and will be held at AOL Campus HQ in Dulles VA. Most databases employ B-trees...
by Michael Coburn | Oct 19, 2012 | Insight for DBAs, Insight for Developers, MySQL
Did you just run an UPDATE against your 10 million row users table without a WHERE clause? Did you know that in MySQL 5.5 that sometimes you can recover from a bad UPDATE statement? This is possible if you are running in binlog_format=ROW ! Imagine this scenario:...
by Peter Zaitsev | Oct 19, 2012 | MySQL
Percona has offered Training for years, and I have personally delivered my share of Public and Private training. Below are my thoughts on the different training delivery options and how to choose the one that fits your needs. The Onsite Public training is perhaps the...
by Tokutek | Oct 18, 2012 | MySQL
Next week I’ll be visiting Moscow to talk at Highload++. The conference will take place during Monday 22nd and Tuesday 23rd at the Radisson hotel. I will be giving my personal version of an indexing talk that my colleagues have given in meetups and conferences...
by Tim.Callaghan | Oct 16, 2012 | MySQL
I’ll be presenting “MongoDB and Fractal Tree Indexes” at MongoDB Boston 2012 on October 24th. My presentation covers the basics of B-trees and Fractal Tree Indexes, the benchmarks we’ve run so far, and the development road map going forward....
by Michael.Bender | Oct 15, 2012 | MySQL
Bradley and I (Michael) gave the tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference last month. The tutorial was organized as follows: Module 0: Tutorial overview and introductions. We describe an observed (but not necessary)...
by Daniel Nichter | Oct 15, 2012 | Insight for DBAs, Percona Software
As of Percona Toolkit v2.1.5, pt-table-checksum works correctly with Percona XtraDB Cluster, but it doesn’t work quite like a traditional replication setup because cluster nodes are not like traditional replicas. In this post I demonstrate how to use...
by Ovais Tariq | Oct 12, 2012 | MySQL
Solid State Drive (SSD) have made it big and have made their way not only in desktop computing but also in mission-critical servers. SSDs have proved to be a break-through in IO performance and leave HDD far far behind in terms of Random IO performance. Random IO is...
by Daniel Nichter | Oct 12, 2012 | Percona Events, Percona Software
Although Percona Toolkit 2.1.4 was recently released, we soon after found and fixed a couple of bugs concerning how pt-table-checksum works with Percona XtraDB Cluster: pt-table-checksum 2.1.4 doesn’t detect diffs on Percona XtraDB Cluster nodes...
by Tokutek | Oct 11, 2012 | MySQL
The core technology behind Tokutek is based on the academic research by our founders: Michael Bender, Bradley Kuszmaul and Martin Farach-Colton. They are all still in academia, in addition to their work at Tokutek. Back in March, the White House kicked off a new...
