MySQL Performance Blog

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...]

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 internals in SHOW STATUS, more

Our patches (thanks Yasufumi!)

- innodb_check_defrag.patch, Show how sequential was execution of query, more
- innodb_io_patches.patch. This patch actually is more or less equal to innodb_io_tune.patch, but adds one important feature – adaptive flush process, so InnoDB does not get stuck during flushing process, more
- innodb_io_pattern.patch. The patch shows IO accesses to InnoDB tablespaces, more
- innodb_show_hashed_memory.patch. This adds more information into SHOW INNODB STATUS about internal InnoDB memory allocations, more
- microsec_process.patch – adds new table INFORMATION_SCHEMA.PROCESSLIST with information of time of query execution in milliseconds, more

We are preparing our binaries for RedHat / CentOS which will include some subset of patches, and also I think OurDelta will make builds available for wide range of platform.