I like bbc.co.uk’s most popular stories facility – not least because you can get a sense of how the most popular stories change through the day, as well as the ones that people email to others.
And guess what – it’s a MySQL database that drives it. For those who are interested, more detail, go here: Download mysql-bbc-news.pdf