EmergencyEMERGENCY? Get 24/7 Help Now!

Getting History of Table Sizes in MySQL

 | December 8, 2010 |  Posted In: Insight for DBAs, MySQL

One data point which is very helpful but surprisingly few people have is the history of the table sizes. Projection of data growth is very important component for capacity planning and simply watching the growth of space used on partition is not very helpful. Now as MySQL 5.0+ has information schema collecting and keeping this […]

Read More

Data Corruption, DRBD and story of bug

 | November 29, 2010 |  Posted In: Hardware and Storage, MySQL

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 […]

Read More

Percona Server 5.1.52-rel11.6

 | November 23, 2010 |  Posted In: MySQL, Percona Software

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 – […]

Read More

Percona XtraBackup 1.4

 | November 22, 2010 |  Posted In: MySQL, Percona Software

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 […]

Read More