Check this thread out
MySQL Statement choking performance.
What that query does is insert a row into the table every time someone views a story on your website. Now, since you were on digg and you had TONS of people viewing that page it was creating a row in your pageviews table for every view. This may have created too much load for your database.