SUM(byte sent in one hour) will only show how much data transferred, for example in one hour.
If you want average transfer speed, you need [ SUM(byte sent in one hour)/one hour ] , but it still does not really tell, how much bandwidth you really have, because you are measuring the average in one hour. but at least, that would be the nearest assumption for the real bandwidth. On Mon, Jul 5, 2010 at 5:18 PM, Azril Nazli Alias <[email protected]>wrote: > > Guys, > > I have a logfile generated by my CDN server in this format > client-ip uri bytes-sent obj-size bytes-recvd method status time-recvd > time-to-serve > 2.2.2.2 http://1.1.1.1 443 295 113 GET 403 [18/May/2010:07:00:31 +0800] > 705 > > So I have successfully inserted all the data in MySQL database > > So my assumptions, to calculate total bandwidth served will be > SUM(bytes-sent) ? Or do I need to factor it with time-to-serve ? > > Does bytes-sent in bytes or kb ? > > Thank you > > > -- > Join Open Source Developers Club Malaysia http://www.osdc.my/ > > Facebook Fan page > > http://www.facebook.com/group.php?gid=98685301577 > > http://www.facebook.com/OSDC.my > > You received this message because you are subscribed to the Google > > Groups "OSDC.my Mailing List" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<osdcmy-list%[email protected]> > For more options, visit this group at > http://groups.google.com/group/osdcmy-list?hl=en -- Sharuzzaman Ahmat Raslan -- Join Open Source Developers Club Malaysia http://www.osdc.my/ Facebook Fan page http://www.facebook.com/group.php?gid=98685301577 http://www.facebook.com/OSDC.my You received this message because you are subscribed to the Google Groups "OSDC.my Mailing List" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/osdcmy-list?hl=en
