4 ms·
> we’re now pushing over 10,000 likes per second at peak These kinds of stats always sound so impressive, but let's imagine: - 8 byte timestamp - 8 by
by hosay123 14y ago
> we’re now pushing over 10,000 likes per second at peak
These kinds of stats always sound so impressive, but let's imagine:
- 8 byte timestamp
- 8 byte user ID
- 8 byte post ID
- 128 bytes DBMS overhead
- 128 bytes for user->like index
- 128 bytes for post->like index
= 3.96MiB/second, or ~1015 IOPs/second, or 342GB per day absolute worst case. A single economy machine with an even remotely decent SSD could handle a full day's data at these rates.
- brown9-2 14y agoThis would seem to assume that this is the only operation that hypothetical machine would need to handle.
- hosay123 14y agoGood point, although it's still within the remit of a cheap SSD, e.g. the Crucial M4 can push 40k+ IOPs. My remark was more geared towards silly but awesome sounding statistics than anything else, it really undermines otherwise decent content.
- rbranson 14y agoThe statistic is just to show the growth in our data volumes since last year. As with most social sites (and the web in general), the number of writes is a very tiny slice of the I/O pie.