…Ten” style charts. These charts are very popular and very process heavy on the database server. You decide to…because if a forked process crashes, you would need to recover it in some way. This is a …good way to preprocess the data then you just have to send the result as quickly as possible to the…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… from MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way to get … provide stronger guarantees against data loss if mysqld crashes. And you can use the standby (passive) …lookup ran in tens of milliseconds on the active master, but executed for up to dozens of …
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
…has become a key tool in helping us analyze MySQL when customers are having trouble. We have our …longer (I’ve seen tens of seconds, but heard reports of minutes). The server can crash. I haven’t …get stack traces less intrusively. I think we need to investigate some of those and see whether there …
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…my production application (storing billions of rows in tens of thousands tables) Innodb was better choice … not happen for all applications and there are ways to fight it but still watch out. Lack of…to disk, but it also comes at great danger if MySQL Server crashes or power goes down. In case crash…
