4 ms·
There is no explanation of why a filesystem is a bad place to store "binary blobs". If you're collapsing the metrics that you're storing IN SQL there is someth
by peterwwillis 17y ago
There is no explanation of why a filesystem is a bad place to store "binary blobs".
If you're collapsing the metrics that you're storing IN SQL there is something really wrong going on.
Logs are OK to store in SQL, assuming you're scraping your logs properly and are logging the proper things. Logging every clickthrough in a relational database is somewhat insane. Logging 10 minutes worth of aggregate clickthroughs is perfectly fine. If you think logs should be a ring buffer I challenge you to tell that to any admin of a system that is subject to laws governing the length of time you must store logs (which is pretty much all e-commerce?).
- dangrossman 17y agoMeh, I record a couple million page views to a MySQL database (as a new row for every page view) every day, for 6 years. Works fine. I don't expect a million new users to show up any time soon.
- peterwwillis 17y agosix billion five hundred seventy million rows?
- dangrossman 17y agoYes, I do actually have billions of rows. See http://www.w3counter.com http://www.w3counter.com
- deleted 17y ago[deleted]