Buy Percona ServicesBuy Now!

Announcing Percona XtraBackup 2.0.2

 | August 14, 2012 |  Posted In: Percona Software

Percona is glad to announce the release of Percona XtraBackup 2.0.2 on August 13th, 2012. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. Bugs Fixed: Fixed false positive test suite failures with grep 2.10. Bug fixed #996483 (Alexey Kopytov). Incremental backup would […]

Read More

European and North American Training Schedule Announced

 | August 13, 2012 |  Posted In: Events and Announcements, MySQL

Ensuring that everyone has a chance to attend Percona’s training for MySQL, we are announcing the following dates for Europe. The dates for Europe are: Live Virtual Training: Developer Training for MySQL Begins Monday, August 27, 2012 , 9am – 11am, Greenwich Mean Time Madrid, España Begins Monday, September 3, 2012 The class will be conducted in Spanish. […]

Read More

Recovery deleted ibdata1

 | August 10, 2012 |  Posted In: Insight for DBAs, MySQL

Recently I had a case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time. The following recovery technique is based on this fact and it allowed to salvage the database. Actually, the files were deleted long time ago – […]

Read More

Dagstuhl Seminar on Database Workload Management

 | August 7, 2012 |  Posted In: Tokutek, TokuView

A few weeks ago Bradley Kuszmaul and I attended the Dagstuhl Seminar on Database Workload Management. The Dagstuhl computer science research center is (remotely) located in the countryside in Saarland, Germany. The actual building is an 18th Century Manor House, first retooled as an old-age home, and then a computer science research center. Workshop participants […]

Read More

MySQL Indexing: Best Practices Webinar

 | August 7, 2012 |  Posted In: Events and Announcements, MySQL

I’m hosting MySQL Indexes: Best Practices Webinar next week, Wednesday August 15. In which I will talk about how MySQL indexes are structured and how they can be used, as well as go over the best practices in selecting correct indexes for your database workloads. Indexing looks like a very basic topic, but it is […]

Read More

Filling the tmp partition with persistent connections

 | August 6, 2012 |  Posted In: MySQL

The use of tmpfs/ramfs as /tmp partition is a common trick to improve the performance of on-disk temporary tables. Servers usually have less RAM than disk space so those kind of partitions are very limited in size and there are some cases were we can run out of space. Let’s see one example. We’re running […]

Read More

Real World Compression

 | August 1, 2012 |  Posted In: Tokutek, TokuView

Benchmarking is a tricky thing, especially when it comes to compression. Some data compresses quite well while other data does not compress at all. Storing jpeg images in a BLOB column produces 0% compression, but storing the string “AAAAAAAAAAAAAAAAAAAA” in a VARCHAR(20) column produces extremely high (and unrealistic) compression numbers. This week I was assisting […]

Read More