Monthly Archives - November 2008

Adaptive checkpointing

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

Read more

More patches

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

Read more

New Presentations published (Meetup and Highload)

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

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

Shell

–log

1

–log

(or

Shell

–general-log

1

–general-log

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

Read more

Election night

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

Read more