http://www.iamcal.com/linklog/ All the links from iamcal.com 2010-09-28T23:08:25Z http://www.iamcal.com/images/logo.gif http://www.iamcal.com/linklog/ http://www.iamcal.com/linklog/1285740505/ jeremy cole has finally <a href="http://jcole.us/blog/archives/2010/09/28/mysql-swap-insanity-and-the-numa-architecture/">solved</a> the mysql swapping-for-no-reason issue. very nice work [via ph] 2010-09-28T23:08:25Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1282019447/ noting these down for later reference - two <a href="http://www.quora.com/Why-doesnt-Quora-use-PostgreSQL">excellent</a> <a href="http://www.quora.com/Why-does-Quora-use-MySQL-as-the-data-store-rather-than-NoSQLs-such-as-Cassandra-MongoDB-CouchDB-etc">answers</a> on quora from adam d'angelo on why quora uses mysql instead of postgres or a nosql solution. he says everything i've been saying for the last few years, but more eloquently 2010-08-16T21:30:47Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1256401090/ a couple of interesting alternatives to phpMyAdmin, both simpler: <a href="http://sqlbuddy.com/">sqlbuddy</a> looks like a really well done minimalist effort, while <a href="http://code.google.com/p/phpminiadmin/">phpMiniAdmin</a> like like PMA from 10 years ago. 2009-10-24T09:18:10Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1238092655/ <a href="http://www.mysqlperformanceblog.com/2009/03/13/xtrabackup-03-binaries-and-stream-backup/">xtrabackup</a> sounds like really good news for people backing up large innodb instances. streaming backups? yes pls 2009-03-26T11:37:35Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1154378853/ dathan's <a href="http://mysqldba.blogspot.com/">mysql blog</a> is full of useful tips for people using mysql on a large scale. a kind of "advanced mysql hacks" book done right. 2006-07-31T13:47:33Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1120333213/ mike b pointed me to this <a href="http://www.zdnet.com.au/news/software/0,2000061733,39193420,00.htm">bizarre article</a> from IBM's daniel sabbah describes lamp as "going to have to grow up at some point". err, right. because lamp clearly doesn't scale. it's not like the biggest websites in the world use it. ryan tomayko's <a href="http://naeblis.cx/rtomayko/2005/05/28/ibm-poop-heads">response</a> is on the mark. 2005-07-02T12:40:13Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1106349036/ backed up for later - the innodb <a href="http://www.innodb.com/manual.php#innobackup">hot backup script</a>. faster than restoring from a dump, but more prone to corruption. 2005-01-21T15:10:36Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1106293274/ gah. f was down for 5 hours after a routine database modification revealed massive innodb corruption which had somehow replicated to the slave. after splitting the cluster, our last backup was nine days old and a few million records short. eek. so a painstaking search and destroy for bad records was conducted. stupid mysql. 2005-01-20T23:41:14Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1105521834/ phpMyAdmin doesn't yet have support for NDB - looks like someone <a href="http://sourceforge.net/tracker/index.php?func=detail&aid=1001935&group_id=23067&atid=377411">dropped the ball</a>. 2005-01-12T01:23:54Z Cal Henderson (http://www.iamcal.com/) http://www.iamcal.com/linklog/1105521336/ this is a <a href="http://www.davz.net/static/howto/mysqlcluster/">good tutorial</a> on mysql clustering. maybe when the new hardware arrives in the office we can give it a trial. 2005-01-12T01:15:36Z Cal Henderson (http://www.iamcal.com/)