by Vadim Tkachenko | Jun 19, 2012 | MySQL, Percona Software
Contrary to initial reports here and here, further investigation has revealed that under some specific and limited circumstances, Percona Server and Percona XtraDB Cluster binaries, similar to other MySQL variants, are susceptible to the security vulnerability in...
by Peter Zaitsev | Jun 19, 2012 | Benchmarks, Insight for DBAs, MySQL
Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them through insertion, especially for tables much larger than memory and large uncorrelated indexes you might be looking at 10x difference or more. Yet for some...
by Martin.FarachColton | Jun 18, 2012 | MySQL
Next week, a couple of us at Tokutek will be heading to Buenos Aires for the MySQL / MariaDB Conference & Expo LA. Gerry Narvaja actually grew up in Buenos Aires. My own family is Argentinian. I spent several years there as a child, and my childhood home in South...
by Peter Zaitsev | Jun 18, 2012 | MySQL, Percona Events
Upgrading MySQL is boring topic, upgrading MySQL is something we would rather to be done with and get benefits from new cool features or be done with bugs and limitations which haunted us for years. Yet if you’re not careful performing MySQL upgrade you can get...
by Peter Zaitsev | Jun 15, 2012 | Insight for DBAs, MySQL
I was playing with Percona Server today and found fast_index_creation does not work quite exactly like described in the manual. The point I’m looking to make though it would be very hard to catch this problem without additional information_schema tables we added...
by Baron Schwartz | Jun 15, 2012 | MySQL, Percona Events, Percona Software
Version 1.0.1 of the Percona Monitoring Plugins is released. This is a routine bug-fix release that addresses several minor issues. The Percona Monitoring Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your...
by Rich.Prohaska | Jun 14, 2012 | MySQL
As ones data model evolves changing the database schema becomes painful, especially for big databases where the table must be taken offline. Fortunately, Tokutek introduced online schema changes starting in TokuDB v5.0. A typical schema change involves adding or...
by Jay Janssen | Jun 14, 2012 | Benchmarks, MySQL, Percona Software
I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment. They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other. Test Environment The test environment included...
by Baron Schwartz | Jun 12, 2012 | MySQL, Percona Events, Percona Software
The Percona Toolkit team is happy to announce the release of Percona Toolkit versions 2.0.5 and 2.1.2. These are bug-fix releases in the 2.0 and 2.1 series, respectively. These releases fix many dozens of bugs, and we suggest that users upgrade to the latest versions...
by Vadim Tkachenko | Jun 11, 2012 | MySQL, Percona Software
Many of you heard of this nasty security vulnerability in MySQL, and as we are getting a lot of inquiries how does it affect Percona Server, I decided to address it in this post. The issue exists in the source code of MySQL 5.5.23 or earlier and MySQL 5.1.62 or...
by Leif.Walsh | Jun 11, 2012 | MySQL
Modern file systems are well equipped to deal with large writes. One area that remains challenging however is to efficiently write out “microdata”, such as metadata and small portions of large files, while showing good I/O utilization when the data is read...
by Yves Trudeau | Jun 8, 2012 | MySQL
Since the new MySQL Pacemaker resource agent supporting PRM is now included in version 3.9.3 of the official Pacemaker resource agents package and things have stabilized a bit, I have been able to write some documentation. I wrote a first draft of the PRM...
by Vadim Tkachenko | Jun 7, 2012 | MySQL, Percona Software
I am happy to announce next version Percona XtraDB Cluster 5.5.24, which is mostly jump to the current version of Percona Server. It includes an important bug fix: table with no PK but still having UK, can cause crash in slave using PA Binaries are available from...
by Baron Schwartz | Jun 7, 2012 | MySQL, Percona Events
Percona will be at Southeast Linux Fest tomorrow and Saturday. We’re supporting the event, and we hope to meet you there. If you’ve never been, this is a great regional show that’s grown enormously in the last few years. Peter and I will both be...
by Martin.FarachColton | Jun 6, 2012 | MySQL
Executive Summary Fast indexing requires the leaves of a Fractal Tree® Index to be big. But some queries require the leaves to be small in order to get any reasonable performance. Basements nodes are our way to achieve these conflicting goals, and here I’ll...
by Miguel Angel Nieto | Jun 6, 2012 | MySQL
There are some variables that can affect the replication behavior and sometimes cause some big troubles. In this post I’m going to talk about read_buffer_size and how this variable together with max_allowed_packet can break your replication. The setup is a...
by Jay Janssen | Jun 6, 2012 | MySQL, Percona Software
Thanks to all who attended my webinar today. The session was recorded and will be available to watch for free soon here. There were a lot of great questions asked during the session, so I’d like to take this opportunity to try to answer a few of them: Q: Is...
by Tim.Callaghan | Jun 5, 2012 | MySQL
I’ll be attending this year’s US based Open Database Camp from June 8-10 in Charlotte, NC. The conference is co-located with SouthEast LinuxFest 2012. It appears that OpenSQL Camp was renamed Open Database Camp since I see many database technologies listed...
by Martin.FarachColton | Jun 4, 2012 | MySQL
The signal-to-noise ratio in the NoSQL world has made it hard to figure out what’s going on, or even who has something new. For all the talk of performance in the NoSQL world, much of the most exciting part of what’s new is really not about performance at all. Take...
by Miguel Angel Nieto | Jun 4, 2012 | MySQL
Over the last months I’ve seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread_concurrency. Our advice is: stop wasting your time, it does nothing on GNU/Linux 🙂 Some of the biggest GNU/Linux distributions includes...
