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
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 […]
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 […]
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 […]
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 […]Read more
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 […]Read more
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
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 […]Read more
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.