Buy Percona ServicesBuy Now!

Best kept MySQLDump Secret

 | March 23, 2012 |  Posted In: Insight for DBAs, MySQL

Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works, but did you know there are some cases when you can get table entirely missing from the backup if you use this technique ? The problem comes from the fact how MySQL’s […]

Read More

BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo

 | March 22, 2012 |  Posted In: Cloud and NoSQL, Events and Announcements, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Software, XtraDB Cluster

The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities to engage with the community, and an enthusiastic crowd of MySQL users ensure this is going to be a great event. The conference features 72 breakout sessions, keynotes by leading industry luminaries, an optional day […]

Read More

Troubleshooting MySQL Memory Usage

 | March 21, 2012 |  Posted In: Insight for DBAs, MySQL

One of the most painful troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL takes much more memory than you would expect, causing swapping or other […]

Read More

Win Free MySQL Conference Tickets!

 | March 19, 2012 |  Posted In: Tokutek, TokuView

Tokutek and Percona are giving away free tickets to the Percona Live MySQL Conference and Expo (worth $995 each), and you can win them! We’re also giving away copies of High Performance MySQL, 3rd Edition (worth $55 each). This year’s event is the best ever, with a better lineup of talks and speakers than ever before.  It’s […]

Read More

Announcing Percona Server 5.5.21-25.0

 | March 19, 2012 |  Posted In: MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.5.21-25.0 on March 20th, 2012. Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can […]

Read More

Free ticket to MySQL User Conference on SF Meetup with talk “Percona XtraDB Cluster”

 | March 16, 2012 |  Posted In: Events and Announcements, MySQL

Just a reminder that I will be giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday, March-21, 2012. Along with talk I will give away one full ticket (tutorials + sessions + expo hall) to Percona Live MySQL User Conference 2012 and three copies our new book “High Performance MySQL, […]

Read More

ext4 vs xfs on SSD

 | March 15, 2012 |  Posted In: Benchmarks, MySQL

As ext4 is a standard de facto filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or something else (i.e. xfs) should be used. Traditionally our recommendation is xfs, and it comes to known problem in ext3, where IO gets serialized per i_node in O_DIRECT […]

Read More

Win Free MySQL Conference Tickets!

 | March 14, 2012 |  Posted In: Events and Announcements, MySQL

We’re giving away three full conference passes (worth $995 each) to the Percona Live MySQL Conference and Expo, and you can win one simply by sharing the conference with your friends and colleagues! Second prize is one of ten copies of the new High Performance MySQL, 3rd Edition (worth $55 each), the recently released update […]

Read More

Give feedback on a pt-online-schema-change update

 | March 14, 2012 |  Posted In: MySQL, Percona Software

I am writing a specification for updating pt-online-schema-change. The outline of the changes I want to make is here: The idea is to make the tool Do The Right Thing, with features such as automatically throttling its operation to avoid causing replicas to lag. Many of the features and improvements are similar to those […]

Read More