EmergencyEMERGENCY? Get 24/7 Help Now!

Adaptive checkpointing

 | November 13, 2008 |  Posted In: Benchmarks, Percona Software

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. — limit of “amount” — As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the […]

Read More

New SpecJAppServer results at MySQL and Sun.

 | November 12, 2008 |  Posted In: Benchmarks

As you likely have seen Sun has posted the new SpecJAppServer Results More information from Tom Daly can be found here These results are quite interesting for me as I worked on some of the previous SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, plus they can be relevant […]

Read More

Scaling to 256-way the Sun way

 | November 11, 2008 | 

As you may have recently seen there are some articles about scaling MySQL one 256-way system. I though wow did they really make it work, considering how many bottlenecks remain in MySQL. What article really tells us ?

Read More

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


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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! 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.