Brad Fitzpatrick recently gave an overview of the way LiveJournal uses MySQL, some very interesting ideas and pictures.