2009-05-12

2009-05-12 Plurk訊息成長量週統計

前情提要:請先參閱
2009-02-18 Plurk一天產生多少則新訊息?
2009-04-05 Plurk一天產生多少則新訊息?(續)


為求有比較精確的Plurk 新增訊息數統計資料,拿個測試帳號 設定每小時整點自動發一則新訊息做定位的動作 ,並記錄下每一則訊息的plurk_id流水號,有了這資料以後就可以算出Plurk每個小時新增了多少筆訊息。
目前的蒐集到的資料從台灣時區(GMT +0800) 2009/5/4 12:00 開始,紀錄到2009/5/12 00:00為止,共計7天又12小時
把每小時新增加的訊息數統計後畫出新增數量走勢圖

詳細大圖請按此

上圖的時間軸是以台灣時區為基準,目前Plurk的台灣用戶數應該已經超過全球的1/2了(請參考此噗的推論),加上印尼/菲律賓也有為數不少的噗浪客(這前三名保守粗估超過總數80%以上),由畫出的整體走勢可以看出Plurk這個全球性的服務,基本上每小時新訊息增加的數量多寡完全是跟著GMT+8這個時區的作息在走的XD
從這個新訊息數量的走勢來看可以得到幾個推論:

  1. 每天新訊息數最少的時間區間是凌晨的3點~6點 (下圖紅粗線)
  2. 每天新訊息數最多的時間區間是晚上的20點~23點 (下圖藍粗線)
  3. 每天新訊息數都是從上午8點開始飛速成長,之後維持一個均值直到18點後開始快速增加,最後在0點後迅速下滑
  4. 每個工作天的中午12點會有個短暫的下滑,然後在13點後回復原有水平(下圖紅細線)


連中午12點午休吃飯時間都會小量下滑,這一整個看下來完全就是台灣上班族的打混摸魚趨勢圖

另外進行單日新訊息數總計
五月初統計:工作日一天約有35萬、週休假日一天約有29萬則新訊息
對照之前的紀錄
四月初統計:工作日一天約有26萬、週休假日一天約有22萬則新訊息
二月中統計:工作日一天約有19萬、週休假日一天約有17萬則新訊息
從二月中到五月中短短三個月,單日新訊息數幾乎倍增了,這樣的成長速度算是很驚人了。

另外主訊息平均每小時新增量是14101,換算下來平均每秒約新增4條新訊息,而且這算出的僅只是主訊息的新增的數量,還不包含每一則訊息底下的回應。這樣的資料量已經算是不小了,在後端資料庫處裡上的要求是個挺大的挑戰,也難怪Plurk的技術頭Amir會說:資料庫問題是絕大部分讓人沮喪的原因,我們有非常非常多的資料,對我們來說這真是個讓人洩氣的痛呀!

最後附上這一週的詳細資料

Datetimeplurk_idplurks/hplurks/d
2009/5/4 12:0046444396

2009/5/4 13:004646014515749
2009/5/4 14:004647617516030
2009/5/4 15:004649203415859
2009/5/4 16:004650781515781
2009/5/4 17:004652407416259
2009/5/4 18:004654164117567
2009/5/4 19:004655971218071
2009/5/4 20:004657867618964
2009/5/4 21:004659977621100
2009/5/4 22:004662262122845
2009/5/4 23:004664585823237
2009/5/5 00:0046667080212225/4(一)半天不統計
2009/5/5 01:004668352716447
2009/5/5 02:004669404010513
2009/5/5 03:00467009416901
2009/5/5 04:00467064015460
2009/5/5 05:00467109214520
2009/5/5 06:00467155344613
2009/5/5 07:00467208225288
2009/5/5 08:00467276676845
2009/5/5 09:004673886811201
2009/5/5 10:004675429615428
2009/5/5 11:004677062416328
2009/5/5 12:004678714816524
2009/5/5 13:004680303715889
2009/5/5 14:004681977416737
2009/5/5 15:004683605516281
2009/5/5 16:004685228516230
2009/5/5 17:004686888616601
2009/5/5 18:004688632417438
2009/5/5 19:004690403217708
2009/5/5 20:004692241618384
2009/5/5 21:004694289120475
2009/5/5 22:004696467621785
2009/5/5 23:004698749922823
2009/5/6 00:0047008764212655/5(二) 341684
2009/5/6 01:004702535016586
2009/5/6 02:004703624910899
2009/5/6 03:00470436257376
2009/5/6 04:00470492315606
2009/5/6 05:00470540654834
2009/5/6 06:00470586644599
2009/5/6 07:00470641205456
2009/5/6 08:00470709786858
2009/5/6 09:004708172610748
2009/5/6 10:004709711915393
2009/5/6 11:004711368516566
2009/5/6 12:004713010916424
2009/5/6 13:004714634716238
2009/5/6 14:004716292716580
2009/5/6 15:004717945716530
2009/5/6 16:004719567616219
2009/5/6 17:004721265116975
2009/5/6 18:004723047017819
2009/5/6 19:004724848218012
2009/5/6 20:004726719118709
2009/5/6 21:004728742720236
2009/5/6 22:004730987322446
2009/5/6 23:004733251322640
2009/5/7 00:0047353675211625/6(三) 344911
2009/5/7 01:004737070217027
2009/5/7 02:004738144810746
2009/5/7 03:00473887517303
2009/5/7 04:00473942725521
2009/5/7 05:00473995255253
2009/5/7 06:00474041844659
2009/5/7 07:00474096385454
2009/5/7 08:00474166757037
2009/5/7 09:004742777411099
2009/5/7 10:004744359115817
2009/5/7 11:004746054416953
2009/5/7 12:004747808817544
2009/5/7 13:004749497016882
2009/5/7 14:004751265917689
2009/5/7 15:004752976717108
2009/5/7 16:004754687917112
2009/5/7 17:004756422517346
2009/5/7 18:004758247318248
2009/5/7 19:004760014617673
2009/5/7 20:004761941619270
2009/5/7 21:004763966820252
2009/5/7 22:004766121521547
2009/5/7 23:004768373822523
2009/5/8 00:0047704836210985/7(四) 351161
2009/5/8 01:004772175216916
2009/5/8 02:004773236610614
2009/5/8 03:00477394717105
2009/5/8 04:00477450415570
2009/5/8 05:00477497394698
2009/5/8 06:00477544044665
2009/5/8 07:00477598725468
2009/5/8 08:00477670007128
2009/5/8 09:004777816011160
2009/5/8 10:004779438316223
2009/5/8 11:004781205217669
2009/5/8 12:004782935417302
2009/5/8 13:004784631916965
2009/5/8 14:004786369617377
2009/5/8 15:004788094817252
2009/5/8 16:004789791216964
2009/5/8 17:004791527717365
2009/5/8 18:004793304717770
2009/5/8 19:004795000016953
2009/5/8 20:004796690116901
2009/5/8 21:004798518718286
2009/5/8 22:004800518820001
2009/5/8 23:004802620021012
2009/5/9 00:0048046432202325/8(五) 341596
2009/5/9 01:004806358917157
2009/5/9 02:004807557711988
2009/5/9 03:00480834577880
2009/5/9 04:00Plurk維修

2009/5/9 05:00480886815224
2009/5/9 06:00480934404759
2009/5/9 07:00480984805040
2009/5/9 08:00481045616081
2009/5/9 09:00481128968335
2009/5/9 10:004812374510849
2009/5/9 11:004813658412839
2009/5/9 12:004815077714193
2009/5/9 13:004816523014453
2009/5/9 14:004817919013960
2009/5/9 15:004819278413594
2009/5/9 16:004820579013006
2009/5/9 17:004821851212722
2009/5/9 18:004823164813136
2009/5/9 19:004824507013422
2009/5/9 20:004825965214582
2009/5/9 21:004827586016208
2009/5/9 22:004829415618296
2009/5/9 23:004831364919493
2009/5/10 00:0048333240195915/9(六) 286808
2009/5/10 01:004835076417524
2009/5/10 02:004836218111417
2009/5/10 03:00483700497868
2009/5/10 04:00483754175368
2009/5/10 05:00483795344117
2009/5/10 06:00483833093775
2009/5/10 07:00483875854276
2009/5/10 08:00483927525167
2009/5/10 09:00484001447392
2009/5/10 10:00484099469802
2009/5/10 11:004842212712181
2009/5/10 12:004843531013183
2009/5/10 13:004844855413244
2009/5/10 14:004846206013506
2009/5/10 15:004847529413234
2009/5/10 16:004848858813294
2009/5/10 17:004850147712889
2009/5/10 18:004851481413337
2009/5/10 19:004852918114367
2009/5/10 20:004854488415703
2009/5/10 21:004856283217948
2009/5/10 22:004858443821606
2009/5/10 23:004860649922061
2009/5/11 00:0048627582210835/10(日) 294342
2009/5/11 01:004864491017328
2009/5/11 02:004865561310703
2009/5/11 03:00486626327019
2009/5/11 04:00486674414809
2009/5/11 05:00486714954054
2009/5/11 06:00486754113916
2009/5/11 07:00486802244813
2009/5/11 08:00486865146290
2009/5/11 09:004869691410400
2009/5/11 10:004871274715833
2009/5/11 11:004872994417197
2009/5/11 12:004874749517551
2009/5/11 13:004876490717412
2009/5/11 14:004878291318006
2009/5/11 15:004880041317500
2009/5/11 16:004881753317120
2009/5/11 17:004883463417101
2009/5/11 18:004885319118557
2009/5/11 19:004887176118570
2009/5/11 20:004889130319542
2009/5/11 21:004891229220989
2009/5/11 22:004893502622734
2009/5/11 23:004895825223226
2009/5/12 00:0048979753215015/11(一) 352171

沒有留言: