Monthly Archives - November 2010

Data Corruption, DRBD and story of bug

Working with customer, I faced pretty nasty bug, which is actually not rare situation , but in this particular there are some lessons I would like to share.
The case is pretty much described in bug 55981, or
in pastebin.
Everything below is related to InnoDB-plugin/XtraDB, but not to regular InnoDB ( i.e in MySQL 5.0)
In […]

Read more

Speaking on San Francisco Meetup 14-Dec : What’s new in XtraDB/InnoDB-plugin 5.1+

Erin and Mike, organizers of SF Meetup generously invited me to talk on coming SF Meetup on Dec-14 about new features in InnoDB in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0.
Although I personally mostly in 5.1->5.5 upgrade area, Erin insured me that upgrade from MySQL […]

Read more

Percona Server 5.1.52-rel11.6

Percona Server version 5.1.52-rel11.6 is now available for download.
The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.
Functionality Added or Changed

 Percona Server 5.1.52-rel11.6 is now based on MySQL 5.1.52.
 New Features Added: None
 Other Changes: None

Bugs Fixed

Bug #671764 – innochecksum wasn’t distributed with RPM and […]

Read more

Percona XtraBackup 1.4

Percona XtraBackup 1.4 is now available for download.
Version 1.4 fixes problems related to incremental backups. If you do incremental backups, it’s strongly recommended that you upgrade to this release.
Functionality Added or Changed

Incremental backups have changed and now allow the restoration of full backups containing certain rollback transactions that previously caused problems. Please see Preparing […]

Read more

Is there benefit from having more memory ?

My post back in April, https://www.percona.com/blog/2010/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory.
That time I used fairy small dataset, so it caused more questions, like, should we have more then 128GB of memory?
If we use fast solid state drive, should we still be looking to increase memory, or that configuration provides best […]

Read more

Avoiding Fragmentation with Fractal Trees

Summary
B-trees suffer from fragmentation. Fragmentation causes headaches — in query performance and space used. Solutions, like dump and reload or OPTIMIZE TABLE are a pain and not always effective. Fractal trees don’t fragment. So if fragmentation is a problem, check out Tokutek
What is fragmentation?
What do I mean when I say […]

Read more

Percona white paper: Forecasting MySQL Scalability

Ewen and I have just published Percona’s latest white paper, Forecasting MySQL Scalability with the Universal Scalability Law. This is essentially a streamlined walk-through of Dr. Neil J. Gunther’s book Guerrilla Capacity Planning, with examples to show how you can apply it to MySQL servers.
One thing alluded to in the paper is […]

Read more

Percona is looking for a Support Engineer

As part of our growth process and with the introduction of our Support and Maintenance services, we’re looking for a new Support Engineer.
You would be a part of a unit that operates 24×7 and be the first line of contact for our customers.
Responsibilities include handling or dispatching emergencies and support requests, triaging incoming issues, […]

Read more