News for hackers. Stuff that matters.
Re:A Look at Enterprise Performance of Intel SSDs by misterbwong on Monday February 13, 2012 @02:18PM (#3586942)
What is a better solution for a high traffic site than tracking page view data into an RDB? Log files other than the built in server logs? NoSql? I'm genuinely curious because my work site is currently tracking into Sql.
Re:A Look at Enterprise Performance of Intel SSDs by jonknee on Monday February 13, 2012 @03:54PM (#3587296)
NoSQL would be what I would go for since this is the type of thing that Redis and similar excel at. Any way you can prevent writes per page view the better off you'll be. Redis gets you speeds similar to memcached but with some stuff you'd expect from a RDBS (durability, replication, etc). It's great for logging/analytics.

"Each drive in the first DB server has seen around 570GB of writes in 9 days, or roughly 63GB/day. The drives in the second DB server have gone through 1.03TB of writes in the same period of time or 114GB/day."

They're writing an incredible amount of data for what amounts to a fairly standard article/comment/forum site (which are typically very read heavy).