By counter it could be pageviews, downloads, number of votes etc. Basically, not very 'critical' data.
What is the 'best' way to store those information? Mysql is not a good option. What do you guys use?
views:
1228answers:
4
A:
The famous view counters of the 1990s used simple files to store the number. If all you need is just to store one number, anything is good enough.
stesch
2010-01-10 02:27:01
If you get any sort of meaningful traffic, writing to a file on disk has concurrency issues. Unless you use file locking, but then you run the risk of lock contention. Projects like memcached exist for a reason.
Frank Farmer
2010-01-10 02:43:24
But if you are just using it for a simple(low traffic) site this could work and wwill be easy to implement
Alfred
2010-01-13 19:01:09
+7
A:
MongoDB with upserts is great for this.
If you're storing something like:
{ "url" : "www.example.com", "pageviews" : 0 }
you can atomically increment pageviews really quickly with the atomic operation $inc:
db.downloads.update({'url' : 'www.example.com'}, {'$inc' : {pageviews : 1}})
If you use upserts, you don't have to check whether a document exists before updating it. For example, if you say:
db.downloads.update({'url' : 'www.example.com'}, {'$inc' : {pageviews : 1}}, {"upsert" : true})
the document with the url www.example.com will be created if it doesn't exist (with pageviews set to 1) or, if it does exist, pageviews will be incremented. This means you don't have to worry about pre-populating the collection.
kristina
2010-01-11 22:28:53
+8
A:
I think I would go with Redis, because:
- Antirediz(his nickname) is really actively developing Redis. (Every time when I look at my github dashboard he has commited some new code). He now is developing redis fulltime thanks to VMware
- Redis is eventually persistent so the performance is kickass (first only uses memory which is fast).
- Redis has an atomic increment operation which you need.
- Redis has a a lot good PHP libraries. There is also one which is written as a C extension so it has really good performance. Redis website also has an overview off these extensions. Some are pure PHP code (run a litle but slower, but are easier to configure).
Alfred
2010-01-13 16:28:15
hands down I would say redis. I'm doing a counter sort of thing and I'm pushing 30k commands per minute on a $20 512MB VPS. :)
James Hartig
2010-01-18 05:56:57
We tried to use redis for a counters system. Redis' primary datastore is RAM, and our dataset was just too large for that to be effective. Something more like Tokyo Tyrant -- which doesn't have to keep the whole dataset in ram all the time -- probably would have been a better choice.
Frank Farmer
2010-03-25 02:19:36
A simple counter can not be kept in RAM? Twitter stores almost all active tweets in memory. If you want performance I think you should pay a little cash for a memory module. Beside you can get a couple gigs of ram cheap.
Alfred
2010-03-25 17:28:11