by Terry Erisman | Jan 22, 2013 | MySQL, Percona Events
I’m pleased to announce the first of the Percona Live MySQL Conference and Expo 2013 keynote speakers and new sponsors including Amazon Web Services, Google, Clustrix, Scalebase, PalominoDB, Database Trends & Applications, and Linux Journal. We are also now...
by Daniel Nichter | Jan 21, 2013 | Percona Software
Since we’re very busy working on Percona Toolkit 2.2 and other projects, I thought 2.1.8 (the current latest Percona Toolkit release) would be the last release in that series, but it introduced a new bug in pt-heartbeat (despite all the tool’s tests) that...
by Stephane Combaudon | Jan 21, 2013 | Insight for DBAs, MySQL
Last time I wrote about a few tips that can make you more efficient when using the command line on Unix. Today I want to focus more on pager. The most common usage of pager is to set it to a Unix pager such as less. It can be very useful to view the result of a...
by Peter Zaitsev | Jan 18, 2013 | MySQL, Percona Software
Percona Server has won a 2013 DeveloperWeek Best of Tech award, being named Top Innovator in the SQL Technologies category! We’re proud to accept this award, which is determined by a combination of peer voting and review from an independent panel of judges....
by Terry Erisman | Jan 18, 2013 | MySQL, Percona Events
I’m pleased to announce the initial list of keynote speakers for the Percona Live MySQL Conference & Expo, April 22-25 in Santa Clara, California. The conference promises great content with over 90 speakers in more than 110 sessions, 15 tutorials, and...
by Bill Karwin | Jan 17, 2013 | Insight for Developers, MySQL, Percona Events
I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair. Specifically, about the care we...
by Stephane Combaudon | Jan 17, 2013 | MySQL
Thanks to all attendees of the webinar yesterday! If you missed it, you can watch the video recording. Here are some questions that remained unanswered due to time constraints. Q: Are there any technical considerations or best practice tips to have a replicated slave...
by Kenny Gryp | Jan 16, 2013 | MySQL, Percona Events
Just like previous years, the ‘MySQL And Friends’ community is gathering to have a dinner on the Saturdaynight of FOSDEM. This time it is on February 2nd, 2013. This year, it will not be an Italian restaurant, but more a Belgian style restaurant, about 10...
by Aurimas Mikalauskas | Jan 16, 2013 | MySQL
Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16 disks, the maximum that is going to be used to process this query at any given point...
by Hrvoje Matijakovic | Jan 15, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.1.66-14.2 on January 15th, 2013 (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.2 is now the...
by Tokutek | Jan 15, 2013 | MySQL
We wanted to take a moment to say thanks to all of our customers and to the wider MySQL and MariaDB community. Today we announced a doubling of our customer base for the year ending December 31, 2012. Significant milestones over the last year included new technology...
by Aurimas Mikalauskas | Jan 15, 2013 | Insight for Developers, MySQL
One of the most common causes of a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes (which are normally used for filtering) work, when they are a good idea to use and what to do...
by Peter Zaitsev | Jan 14, 2013 | MySQL, Percona Events
Percona Live MySQL Conference and Expo 2013 – the largest MySQL Conference event of the year is getting close and we’re now announcing two community activities which are going to happen at this event. Call of DotOrg Pavilion exhibitors is open –...
by Peter Zaitsev | Jan 14, 2013 | MySQL, Percona Events
In a few hours I’m leaving for my “SouthEast Meetup Tour” first going to Charlotte where I’m speaking Today, Jan 14, about MySQL Indexing: Best practices on local MySQL Meetup and then going to Atlanta to give the same talk on Atlanta MySQL...
by Stewart Smith | Jan 13, 2013 | MySQL, Percona Software
In preparing Percona Server 5.5.29 (not yet released, but soon), I filed MySQL bug 68045 (is marked private as it’s a security bug). This bug is in relation to the Oracle fix for CVE-2012-4414 and a problem I found with it. The MariaDB fix (which we incorporated...
by Tokutek | Jan 11, 2013 | MySQL
TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, replication performance and online schema flexibility. Tokutek’s recently launched TokuDB v6.6 delivers all of these features and...
by Peter Zaitsev | Jan 10, 2013 | MySQL, Percona Events
At Percona we focus on education a lot, which we believe is critical for us to be successful with our mission of making businesses successful with their use of MySQL. The MySQL Performance Blog, our first effort in this space, by now contains over 1,000 technical...
by Roel Van de Paar | Jan 9, 2013 | Insight for DBAs, Insight for Developers, MySQL
There are times where you need to know exactly how much memory the mysqld server (or any other program) is using, where (i.e. for what function) it was allocated, how it got there (a backtrace, please!), and at what point in time the allocation happened. For example;...
by Tom Diederich | Jan 9, 2013 | MySQL, Percona Software
Percona Toolkit 2.1.8 was released today and the new version comes with some pretty cool news: Beta support for MySQL 5.6 (which as you might know is also in beta). In addition to various bug fixes, Percona Toolkit 2.1.8 also offers beta support for Percona XtraDB...
by Aurimas Mikalauskas | Jan 9, 2013 | Insight for DBAs, MySQL
While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication...
