…MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as these are a…while with MySQL Replication you can use Maatkit to merge the changes after…queries…a database that you run off a DRBD LVM snapshot. Works on a…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…a while, so it’s time to take off the gloves. I claim that somewhere around of 99% of advice about tuning MySQL…after…work sometimes, simply because there is sometimes a correlation (but not a cause) relationship between the counter events and the query…
Post: Living with backups
November 6, 2008 By 28 Comments
…caching of whatever is being read from a storage. It allows to reduce I/O to such devices on frequently accessed information. After a…, while …a simple copy operation from MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries…working instance of MySQL…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… use in whatever segment. After that, a segment always reserves whole …they were not matched by query where clause when it … aspects of Innodb operations while I see it causing problems … TLB cache misses. huge pages along however do not stop …, for a recovery based on MySQL‘s binlog to work. Of course…
