Buy Percona ServicesBuy Now!

More patches

 | November 11, 2008 |  Posted In: Percona Software

After some pause we are going to announce bunch of patches we made and ported for last period. Ported patches (ported from Google V2 patch): – innodb_fsync_source.patch – Show information about callers of fsync, more info – innodb_io_tune.patch – Port of two patches InnodbIOTune and InnodbAsync, more info – innodb_extra_status.patch – Show more information about […]

Read More

Thoughs on Innodb Incremental Backups

 | November 10, 2008 |  Posted In: Insight for DBAs

For normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily. The answer is space – if you want to keep several generations to […]

Read More

Drilling down to the source of the problem

 | November 8, 2008 |  Posted In: Insight for Developers

I had an interesting tuning case few days ago. The system serving high traffic using Innodb tables would be stalling every so often causing even very simple queries both reads and writes taking long time to complete, with progress almost paused (dropping from thousands to tens of queries per second). On the surface the problem […]

Read More

New Presentations published (Meetup and Highload)

 | November 7, 2008 |  Posted In: Events and Announcements

We have finally found the time to update out presentation pages – we’ve added the presentation on MySQL Scaling by Sharding and Replication as well as Russian Language presentations I’ve given at HighLoad++ conference back in October. Innodb Scalability and New Features (Russian), Scaling MySQL-powered Web Sites by Sharding and Replication (Russian), Wonderful World of […]

Read More

Poor man’s query logging

 | November 7, 2008 |  Posted In: Insight for DBAs

Occasionally there is a need to see what queries reach MySQL. The database provides several ways to share that information with you. One is called general log activated with

(or

in MySQL 5.1+) start-up parameter. The log writes any query being executed by MySQL to a file with limited amount of additional information. […]

Read More

Living with backups

 | November 6, 2008 |  Posted In: Insight for DBAs

Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sentence, but it is not important right […]

Read More

Election night

 | November 5, 2008 |  Posted In: Insight for Developers

Today was epoch day in American history. Maybe even most important day this year, but it’s not what I’d like to write about here. What does it mean for US citizens and all other people around the world? We know, but what does it mean for us – IT professionals and/or internet portals serving news […]

Read More

MySQL, AIX5L and malloc()

 | November 3, 2008 |  Posted In: Insight for DBAs

Some time ago I get brand new IBM POWER6 server as the replacement for “old” P5 used to host Oracle database. Because we planed to use advanced virtualization with VIOS + LPAR/DLPAR I conceived the idea to use one spare partition for MySQL tests. Because I had no past experience with it and there is […]

Read More

OpenSQLCamp is comming close

 | November 2, 2008 |  Posted In: Events and Announcements

OpenSQLCamp is coming close and it is your last change to register. I’m very excited about this event as it looks to be marketing free community gathering, having much fewer attendees but many of them are well known MySQL Professionals. Besides hopefully in depth sessions this promises a lot of good informal chats. Also as […]

Read More
Subscribe to the Percona Database Performance Blog for open source database help, technical resources, Percona Live updates and upcoming webinars.
Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.