First, some English. Estimation is not the same as measuring. If I wanted to measure, I would do so ;) (I might actually do that later). Also I have a dev question posed related to this post.
I would like to store data in a MySQL table, The data type of the table is date, long, long, long, long, short int , where i would have a composite key based on date, long, long.
There could be more indexes as well. (Edit) It seems that it would be 42 bytes of data plus the indexes. You can use 1 million records inserted every day for data growth. Should I just say 42 million bits would be added every day (I guess there is more, based on configuration)
So looking at this http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html it comes out to be
I can have lets say 1 million rows added every day. How much would I rack up in Diskspace? Any references would be greatly appreciated (I will try to find some and post it here as well)