Tag Archives: howto

On MySQL replication, again…

Posted on 2010/06/30 by

There are few things one is supposed to know about MySQL replication in production, as manual doesn’t always discuss things openly. This is small set of rules and advices I compiled (some apply to statement based replication only, but row … Continue reading →

Posted in mysql | Tagged , , | 9 Comments

MySQL processlist phrase book

Posted on 2009/09/27 by

For your convenience, a short phrase book, starting with explanation of process states where MySQL is mostly working to look up data from tables: “Sending data” – reading data from tables (or looking it up) “Copying to tmp table” – … Continue reading →

Posted in mysql | Tagged , , | 13 Comments

iostat -x

Posted on 2009/03/11 by

My favorite Linux tool in DB work is ‘iostat -x’ (and I really really want to see whenever I’m doing any kind of performance analysis), yet I had to learn its limitations and properties. For example, I took 1s snapshot … Continue reading →

Posted in mysql | Tagged , , | 18 Comments

Memcached for small objects

Posted on 2008/12/25 by

Memcached quite often ends up as a store for very small objects (small key and some integer value), though it isn’t really designed to do this kind of work by default. Current memory management is based on slabs (200 of … Continue reading →

Posted in mysql | Tagged , , , | 6 Comments

Five minutes of MediaWiki performance tuning

Posted on 2007/01/26 by

MediaWiki is quite complex package, and some even trivial features are not the ones that should be enabled on sites having more load. Though it is quite modular, still lots of code has to be executed, and some of it … Continue reading →

Posted in wikitech | Tagged , , | 3 Comments

TCP tuning for your database

Posted on 2006/09/12 by

Lately lots of new fascinating technologies are used to build even more fascinating new solutions, and solutions nowadays even run on distributed environments, not just on single server. These servers usually communicate using TCP – standard, that has been here … Continue reading →

Posted in mysql | Tagged , , , | 1 Comment