February 10, 2012

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

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 –log (or –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 information. [...]