by David Hildebrandt | Dec 13, 2011 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Software
Many of you have seen the announcement for our Percona Live in Washington, DC in January! But did you know we also have our highly rated MySQL Training coming to Washington, DC the week of January 16h? Full details can be found on the Percona website. If you would...
by Maciej Dobrzanski | Dec 8, 2011 | Insight for DBAs, MySQL
One of the more common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means I should advise something that is stable, reliable, easy to manage and has plenty of...
by Baron Schwartz | Dec 7, 2011 | MySQL, Percona Events
If you are close to Washington DC, you should plan to attend our Percona Live event on January 11th at the DC Convention Center. We have three tracks of expert speakers on core MySQL-related topics. This event will not be as large as some of the other events...
by Tim.Callaghan | Dec 5, 2011 | MySQL
At next month’s Boston MySQL Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use Cases.” The meetup is 7 pm Monday, January 9th, 2012, and will be held at MIT Building E51 Room 337e (corner of Ames & Amherst St,...
by Vadim Tkachenko | Dec 5, 2011 | MySQL, Percona Software
We are pleased to announce availability of an early access version of Percona’s PAM Authentication plugin for MySQL. This plugin supports MySQL-5.5.x, Percona Server 5.5.x and MariaDB 5.2.x. The PAM Authentication plugin can be used for: MySQL authentication...
by Vadim Tkachenko | Dec 2, 2011 | Benchmarks, MySQL
This is to follow up my previous post with kernel_mutex problem. First, I may have an explanation why the performance degrades to significantly and why innodb_sync_spin_loops may fix it. Second, if that is correct ( or not, but we can try anyway), than playing with...
by Vadim Tkachenko | Dec 2, 2011 | Benchmarks, Insight for DBAs, MySQL
Problem with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are some fixes that suppose to provide a solution, but MySQL 5.6 yet has long way ahead before production, and it is also not clear if the problem is really fixed....
by Baron Schwartz | Dec 2, 2011 | Insight for DBAs, MySQL
Over the last few years, Domas’s technique of using GDB as a profiler has become a key tool in helping us analyze MySQL when customers are having trouble. We have our own implementation of it in Percona Toolkit (pt-pmp) and we gather GDB backtraces from pt-stalk...
by Baron Schwartz | Nov 30, 2011 | MySQL, Percona Events
We announced a while back that we were going to continue the traditional MySQL conference in Santa Clara, because O’Reilly wasn’t doing it anymore. But we haven’t given an update in a while. Here’s the current status: We created a conference...
by Jay Janssen | Nov 29, 2011 | Insight for DBAs, MySQL
As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch error a customers found in their mysqld.err log to verify if the problem still existed. The Innodb Table Monitor has existed for basically forever in Innodb (the...
by Jay Janssen | Nov 29, 2011 | MySQL
I had a customer recently who a few strange errors in their mysqld.err log: [ERROR] Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL 1 [ERROR] Table database_name/table_name contains...
by Yves Trudeau | Nov 29, 2011 | MySQL
The content of this article is outdated, look here for more up to date information. Over the last year, the frustration of many of us at Percona regarding issues with MMM has grown to a level where we started looking at other ways of achieving higher availability...
by Miguel Angel Nieto | Nov 29, 2011 | MySQL
Are you using InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably have gaps in your auto-increment columns. A simple INSERT IGNORE query creates gaps for every ignored insert, but this is undocumented behavior. This documentation bug is already...
by Laurynas Biveinis | Nov 24, 2011 | MySQL
It is no secret that bugs related to multithreading–deadlocks, data races, starvations etc–have a big impact on application’s stability and are at the same time hard to find due to their nondeterministic nature. Any tool that makes finding such bugs easier,...
by Zardosht.Kasheff | Nov 21, 2011 | MySQL
As a storage engine developer, I am excited for MySQL 5.6. Looking at http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html, there has been plenty of work done to improve the performance of reads in MySQL for all storage engines (provided they take...
by Baron Schwartz | Nov 21, 2011 | Insight for DBAs, MySQL
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size) setting? In general, there are two settings that simply can’t be left at their historical defaults for a...
by Stewart Smith | Nov 21, 2011 | MySQL
or… “the case of Stewart recognizing parameters to the read() system call in strace output”. Last week, a colleague asked a question: I have an instance of MySQL with 100 tables and the table_definition_cache set to 1000. My understanding of this is...
by Stewart Smith | Nov 20, 2011 | MySQL
As Mark pointed out, there isn’t a lot of detail in the release notes about what could potentially be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full documentation from the release notes: “InnoDB Storage Engine: Data...
by Tokutek | Nov 19, 2011 | MySQL
With the release of TokuDB v5.0 last March, we delivered a powerful and agile storage engine that broke through traditional MySQL scalability and performance barriers. As deployments of TokuDB have grown more varied, one request we have repeatedly heard from...
by Stewart Smith | Nov 18, 2011 | Percona Software
Percona is glad to announce the release of Percona Server 5.5.17-22.1 on November 19th, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.17, including all the bug fixes in it, Percona Server 5.5.17-22.1 is now the...
