WordPress database error: [Table 'wcblog_postmeta' is marked as crashed and should be repaired]
SELECT meta_key FROM wcblog_postmeta WHERE meta_key = 'views' AND post_id = '26'

WordPress database error: [Incorrect key file for table './blogs2/wcblog_postmeta.MYI'; try to repair it]
INSERT INTO wcblog_postmeta (post_id,meta_key,meta_value) VALUES ('26','views','1')

Amazon S3 changes prices

Email This Post To A Friend  • Print This Post

Effective June 1, 2007, Amazon S3 service will change it’s pricing model, decreasing the bandwidth cost, and introducing charge for PUT/GET operations.

New bandwidth price (effective June 1, 2007)
$0.10 per GB - all data uploaded

$0.18 per GB - first 10 TB / month data downloaded
$0.16 per GB - next 40 TB / month data downloaded
$0.13 per GB - data downloaded / month over 50 TB
Data transferred between Amazon S3 and Amazon EC2 will remain free of charge

New request-based price (effective June 1, 2007)
$0.01 per 1,000 PUT or LIST requests
$0.01 per 10,000 GET and all other requests*
* No charge for delete requests

Those are good and bad news. For those who host their web-site or small images to offset the bandwidth costs from their shared hosting, that is bad; for big guys who host video and photos, that is good.

If you think about it and read the Amazon S3 newsletter, you can clearly say that they are just trying to reduce the amount of small file hosting, because it stresses their system more then serving big files (and that’s try, small files require more connections/second, thus more CPU, if KeepALive is not enabled).

We made some calculations for a Small Guy and a Big Guy:
1) Small Guy usage pattern:
Average Visits per moth: 100,000
Average files per visit: 50 (html and images)
Average Gb per visit: 0.0001 (100,000Kb)
Total GETs: 5,000,000
Total BW used per month: 10Gb
New S3 cost: $6.80
Old S3 cost: $2.00

As you can see, the total cost is x3 time higher now then if we just pay $0.2/Gb, and not $0.18/Gb plus $0.01/10,000GETs. Now, if your site gets popular and you get 2,000,000 unique visitors per month then with the new pricing you would pay about $135 and with the old pricing you would pay only $60. Sad, isn’t it?

2) Big Guy usage pattern:
Average Visits per moth: 2,500,000
Average files per visit: 50 (html and images) + 3 videos
Average Gb per visit: 0.0001 (100,000Kb) + 0.09 (90 Mb, avg video is 30Mb)
Total GETs: 132,500,000
Total BW used per month: ~687,500 Tb (now $0.13/Gb)
New S3 cost: ~$90,000
Old S3 cost: ~$138,000

The Big Guy saves almost 50% on total costs, which is sweet.

Tags:

    Relevant articles:

    WordPress database error: [Can't create/write to file '/tmp/#sql_907_0.MYI' (Errcode: 30)]
    SELECT DISTINCT p.*, count(p2t.post_id) as cnt FROM wcblog_post2tag p2t, wcblog_tags t, wcblog_posts p WHERE p2t.tag_id = t.tag_id AND p2t.post_id = p.ID AND (t.tag IN ('amazon', 'bandwidth', 's3', '')) AND post_date_gmt < '2008-11-21 01:44:58' AND (post_type = 'post') AND p.ID != 26 GROUP BY p2t.post_id ORDER BY cnt DESC, post_date_gmt DESC

  • No Related Posts

Bookmark Post: Add to del.icio.us  Add to Furl  Add to Reddit  Add to BlinkList  Add to blogmarks  Add to Ma.gnolia  Add to Netscape  Add to Socializer  Add to Spurl  Add to StumbleUpon  Add to Technorati