Percona Server version 5.1.55-12.6 is now available for download. It is now the current stable release version.

Changes

• Fixed compiler warnings in both the core server and in XtraDB. (Alxey Kopytov, Yasufumi Kinoshita)

Bugs Fixed

• Bug #602047 – The ROWS_READ columns of TABLE_STATISTICS and INDEX_STATISTICS were not properly updated when a query involved index lookups on an InnoDB table. (Yasufumi Kinoshita)
• Bug #707742 – The server could crash when trying to import a table which had not been previously prepared using xtrabackup --prepare --export. Also, on servers with huge buffer pools, adding or removing an index even on an empty InnoDB table could take a long time due to excessive locking when …

Yesterday I wrote down the approach used in the MepSQL build system to parameterize the TAR package name produced. Today I will follow up with how the same was done for building DEBs. The motivation is to create a system that can be used flexibly to create packages of any MySQL fork, with any brand name: mepsql-server-*.deb, percona-server-server-*.deb, mariadb-server-*.deb or even just mysql-server-*.deb (which I might do some day).

While yesterday's tricks with the TAR files were rather straightforward, with the process of building DEBs this turns out to be much more challenging. But not to worry, like my former collague Bernhard Ocklin used to say: This is software, anything …

As I mentioned before, it seems that thanks to Git and Bzr introducing distributed version control workflows, the open source community is now living in a phase where forking is easy and happens frequently - referred to by Brian Aker as the Cambrian Explosion of open source. We certainly see that happening in the MySQL Community.

Assuming you have the competence and know your way around a codebase, forking a proper open source project isn't that hard. You create your own project on GitHub or Launchpad and copy the source code. 1 But one …

It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights:

• Performance and scalability improvements throughout the server and storage engine
• Optimizations for flash storage such as SSD, Virident, and FusionIO
• Optimizations for cloud computing
• The HandlerSocket plugin for NoSQL access
• There’s an Amazon OS repository, as well as Yum and Apt repositories
• Improvements to replication, partitioning, stored procedures
• More diagnostics and tunability
• More pluggability, including pluggable authentication

In addition to building on MySQL 5.5, here are the changes we’ve made from previous Percona Server releases:

New Features

• InnoDB adaptive hash function searches can now …

On Thursday, February 10, at 10am PST, there is a free webinar about Managing Big Data with Percona Server, XtraBackup and Tungsten. Quoting from the announcement:

Big data is a big problem for growing SaaS businesses and large web applications. In this webinar, we'll teach you how to set up Percona Server, XtraBackup, and Tungsten to manage Terabyte+ databases and scale to millions of transactions a day. We'll discuss the latest features for high transaction performance like InnoDB buffer pool dump/restore and HandlerSocket, our favorite tricks for backup, restore, and provisioning of large data sets, and how to replicate scalably and safely using Tungsten Replicator with parallel apply.

The presenters are representatives of both Percona and …

I wish I could be at this: Percona Live San Francisco. It is on February 16th. Cost is minimal, and content is maximal. The topic is on what’s new in MySQL these days beyond 5.1: the new 5.5 release, HandlerSocket, MariaDB, and of course Percona Server.

This is a follow-up to the enormously successful Percona Performance Conference in 2009.

Related posts:

1. Sessions of interest at the Percona Performance Conference
2. Schedule for MySQL-and-beyond conference is live
3. …

Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version.

Functionality Added or Changed

• Percona Server 5.1.54-12.5 is based on MySQL 5.1.54.
• New Features Added: None
• Other Changes:
  • Added system variable innodb_log_block_size and new value “keep_average” to system variable adaptive_checkpoint in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita)
  • Added new value “ALL_O_DIRECT” to system variable …

Today we're announcing Percona Live - a one day event to be held at the Bently Reserve on February 16th in San Francisco.  Live is our way of showcasing some of the awesome work that has been going into MySQL recently - and the theme of this event is Beyond MySQL 5.1.

Our first guest speaker is none other than Jeremy Zawodny.  Jeremy is well known in the MySQL community having been the original author of High Performance MySQL 1st Ed.  He will be presenting on how Craigslist has already upgraded to MySQL 5.5 - and are running on Fusion-io SSDs in production.

Tickets are available for early bird registration at $50.  To signup, or for more information please visit the percona website.

Entry posted by Morgan Tocker | …

Percona is pleased to officially (and belatedly) welcome Sasha Pachev to our team of consultants.

Before joining Percona, Sasha worked as an independent MySQL consultant. Sasha was the original implementer and maintainer of MySQL replication from 3.23 to 4.02. He is also the author of MySQL Enterprise Solutions and Understanding MySQL Internals.

Sasha, a big welcome – we are fortunate indeed you’re working with us!

Entry posted by Ryan Lowe | No comment

Add to: …

Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version.

Functionality Added or Changed

•  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.
•  New Features Added:
  • Precompiled UDFs for Maatkit (FNV and MurmurHash hash functions to provide faster checksums) are now included in distributions. Fixes feature request #689992. (Aleksandr Kuzminsky)
•  Other Changes:
  • innodb_doublewrite_file - It's no longer necessary to recreate your database and InnoDB …