Data Statistics (July 2014)

Well, here are some new statistics to reflect all of the recent changes done to our network and services.

Foolz Archive Database Statistics (July 2014)

NameRowsData SizeIndex SizeTotal Size
a10043541520.75G11.09G31.84G
a_daily2335144.00K0.00B144.00K
a_deleted1350675.70K188.92K864.61K
a_extra016.00K0.00B16.00K
a_images11251094716.80M493.54M1.18G
a_threads3008798175.67M318.41M494.08M
a_users17215110.52M20.73M31.25M
beta611165.09K69.30K234.39K
beta_daily7916.00K0.00B16.00K
beta_deleted7215.77K10.46K26.22K
beta_extra016.00K0.00B16.00K
beta_images232495.80K104.13K199.93K
beta_threads9716.00K96.00K112.00K
beta_users3216.00K48.00K64.00K
biz419027120.04M44.27M164.31M
biz_daily16016.00K0.00B16.00K
biz_deleted2356.00B252.00B608.00B
biz_extra016.00K0.00B16.00K
biz_images514473.62M2.26M5.88M
biz_threads167221.52M1.41M2.92M
biz_users3026224.00K288.00K512.00K
c38668575.03M53.13M128.17M
c_daily82664.00K0.00B64.00K
c_deleted225.40K3.33K8.73K
c_images28250819.95M12.39M32.35M
c_threads9252512.00K912.00K1.39M
c_users2907160.00K256.00K416.00K
co266823775.88G2.91G8.79G
co_daily77664.00K0.00B64.00K
co_deleted726193.77K95.96K289.74K
co_extra016.00K0.00B16.00K
co_images3871665275.30M144.00M419.30M
co_threads40857524.55M37.98M62.53M
co_users374252.45M3.02M5.47M
d840589207.59M105.14M312.73M
d_daily48848.00K0.00B48.00K
d_deleted19139.92K37.80K77.72K
d_extra016.00K0.00B16.00K
d_images35201224.92M15.44M40.36M
d_threads153581.52M736.00K2.23M
d_users5383288.00K448.00K736.00K
dev2535861.02K308.31K1.14M
dev_daily51864.00K0.00B64.00K
dev_deleted16769.74K25.21K94.95K
dev_extra016.00K0.00B16.00K
dev_images4618200.83K207.45K408.28K
dev_threads40748.00K96.00K144.00K
dev_users11616.00K48.00K64.00K
diy663856218.96M71.97M290.94M
diy_daily98780.00K0.00B80.00K
diy_deleted10.00B0.00B0.00B
diy_extra016.00K0.00B16.00K
diy_images1305889.22M5.73M14.95M
diy_threads470352.52M10.14M12.66M
diy_users8808464.00K2.47M2.92M
foolz1272102423.92M368.75M792.67M
foolz_daily89280.00K0.00B80.00K
foolz_deleted58662.52M2.14M4.66M
foolz_extra016.00K0.00B16.00K
foolz_images22500322.55M20.44M42.98M
foolz_threads6057352.00K656.00K1008.00K
foolz_users2981176.00K368.00K544.00K
g298605516.65G3.14G9.78G
g_daily1401112.00K0.00B112.00K
g_deleted10.00B0.00B0.00B
g_extra10.00B0.00B0.00B
g_images3318874238.05M145.53M383.58M
g_threads139414396.61M140.23M236.84M
g_users1190699.39M12.86M22.25M
gd16736742.04M18.82M60.86M
gd_daily47548.00K0.00B48.00K
gd_deleted122.76K1.62K4.38K
gd_extra016.00K0.00B16.00K
gd_images518463.60M2.27M5.87M
gd_threads123121.52M1.09M2.61M
gd_users2789144.00K256.00K400.00K
gold894384.00K352.00K736.00K
gold_daily11016.00K0.00B16.00K
gold_deleted135112.00K192.00K304.00K
gold_extra016.00K0.00B16.00K
gold_images1710144.00K176.00K320.00K
gold_threads5116.00K80.00K96.00K
gold_users4016.00K48.00K64.00K
h525412103.26M68.52M171.79M
h_daily87880.00K0.00B80.00K
h_deleted112.18K1.85K4.03K
h_extra016.00K0.00B16.00K
h_images26348518.57M11.56M30.13M
h_search00.00B1.00K1.00K
h_threads194641.52M1.77M3.28M
h_users5652272.00K400.00K672.00K
i157833.39M1.87M5.26M
i_daily78680.00K0.00B80.00K
i_deleted10.00B0.00B0.00B
i_extra016.00K0.00B16.00K
i_images8228557.41K369.62K927.02K
i_threads67964.00K96.00K160.00K
i_users44948.00K48.00K96.00K
index_counters5916.00K0.00B16.00K
int180640243.91G1.91G5.82G
int_daily53764.00K0.00B64.00K
int_deleted1539318.90K213.08K531.98K
int_images1957615139.62M85.87M225.49M
int_threads31198518.52M30.59M49.11M
int_users385522.52M4.25M6.77M
jp121896892.57G1.34G3.91G
jp_daily2324144.00K0.00B144.00K
jp_deleted693145.51K97.44K242.94K
jp_extra016.00K0.00B16.00K
jp_images1761865107.56M77.29M184.85M
jp_threads55553932.56M59.03M91.59M
jp_users406582.52M6.73M9.25M
kuku22138575.16M36.37M111.53M
kuku_daily72264.00K0.00B64.00K
kuku_deleted768316.96K132.60K449.57K
kuku_extra016.00K0.00B16.00K
kuku_images611234.31M2.68M6.99M
kuku_threads1411112.00K224.00K336.00K
kuku_users48264.00K48.00K112.00K
m80680791.96G984.82M2.92G
m_daily1927128.00K0.00B128.00K
m_deleted6817.42K10.75K28.17K
m_extra016.00K0.00B16.00K
m_images131584693.97M57.72M151.69M
m_threads23959813.52M26.08M39.59M
m_users242571.52M2.64M4.16M
mlp185302004.36G2.28G6.64G
mlp_daily87080.00K0.00B80.00K
mlp_deleted81.20K1.23K2.43K
mlp_extra016.00K0.00B16.00K
mlp_images2317034162.70M101.64M264.35M
mlp_threads34777120.55M36.09M56.64M
mlp_users987256.52M10.52M17.03M
neet239018.38M3.02M11.40M
neet_daily56064.00K0.00B64.00K
neet_deleted33301.51M529.07K2.02M
neet_images10462764.42K469.97K1.21M
neet_threads1564112.00K224.00K336.00K
neet_users40948.00K48.00K96.00K
out340621104.44M37.24M141.69M
out_daily47948.00K0.00B48.00K
out_deleted65.47K864.00B6.32K
out_images757755.29M3.32M8.62M
out_threads128401.52M1.20M2.72M
out_users2426144.00K240.00K384.00K
po4181410.53M4.82M15.35M
po_daily113780.00K0.00B80.00K
po_deleted82.43K1.10K3.53K
po_images148191.03M665.70K1.68M
po_threads4165256.00K512.00K768.00K
po_users1605112.00K176.00K288.00K
q782501234.17M82.59M316.76M
q_daily54264.00K0.00B64.00K
q_deleted14328.10K21.48K49.58K
q_extra016.00K0.00B16.00K
q_images1087447.62M4.77M12.39M
q_threads391232.52M6.59M9.11M
q_users25516.00K48.00K64.00K
s4s1073631217.16M122.46M339.62M
s4s_daily24716.00K0.00B16.00K
s4s_deleted10.00B0.00B0.00B
s4s_extra016.00K0.00B16.00K
s4s_images24367517.47M10.69M28.16M
s4s_threads1036646.52M11.09M17.61M
s4s_users168871.52M2.05M3.56M
sci56458521.53G602.41M2.11G
sci_daily1508112.00K0.00B112.00K
sci_deleted10.00B0.00B0.00B
sci_extra016.00K0.00B16.00K
sci_images60895143.74M26.71M70.46M
sci_threads36691821.55M202.14M223.69M
sci_users321412.42M17.94M20.36M
sp285183485.67G2.99G8.66G
sp_daily75564.00K0.00B64.00K
sp_deleted29797.47K47.09K144.56K
sp_extra016.00K0.00B16.00K
sp_images2221535158.84M97.47M256.31M
sp_threads46399627.55M47.00M74.55M
sp_users468174.28M6.25M10.53M
text15486.47K21.51K107.98K
text_daily3216.00K0.00B16.00K
text_deleted714.15K985.00B15.11K
text_extra016.00K0.00B16.00K
text_images127848.71K57.41K106.12K
text_threads3316.00K96.00K112.00K
text_users2116.00K48.00K64.00K
tg252011047.46G2.66G10.12G
tg_daily1594112.00K0.00B112.00K
tg_deleted18270.09K25.09K95.18K
tg_extra016.00K0.00B16.00K
tg_images2450490160.37M107.50M267.87M
tg_threads55626732.56M58.03M90.59M
tg_users907186.52M11.70M18.22M
tv393639428.32G4.25G12.56G
tv_daily1610112.00K0.00B112.00K
tv_deleted1696408.93K301.23K710.16K
tv_extra016.00K0.00B16.00K
tv_images4345084280.94M190.57M471.52M
tv_threads166181197.61M168.20M265.81M
tv_users755855.52M9.72M15.23M
u431210113.68M54.73M168.40M
u_daily109680.00K0.00B80.00K
u_deleted16231.33K27.54K58.87K
u_extra016.00K0.00B16.00K
u_images15222010.59M6.68M17.27M
u_threads7053416.00K752.00K1.14M
u_users2112128.00K256.00K384.00K
v11105713824.90G11.88G36.78G
v_daily87380.00K0.00B80.00K
v_deleted693138.07K98.97K237.04K
v_extra016.00K0.00B16.00K
v_images9271703653.00M406.59M1.03G
v_threads2437091150.64M253.45M404.09M
v_users15123610.52M16.66M27.17M
vg6698165514.47G7.05G21.51G
vg_daily87180.00K0.00B80.00K
vg_deleted8423.54K11.69K35.23K
vg_extra016.00K0.00B16.00K
vg_images6428436449.36M281.97M731.33M
vg_threads1385627.52M15.00M22.52M
vg_users1192318.52M14.52M23.03M
vp84057571.77G899.25M2.65G
vp_daily48048.00K0.00B48.00K
vp_deleted255.77K3.30K9.07K
vp_extra016.00K0.00B16.00K
vp_images84551460.46M37.09M97.56M
vp_threads18170910.52M17.95M28.47M
vp_users1079249.30M13.22M22.52M
vr1600913434.46M173.56M608.02M
vr_daily47548.00K0.00B48.00K
vr_deleted61.28K780.00B2.04K
vr_extra016.00K0.00B16.00K
vr_images27344519.37M12.00M31.37M
vr_threads436762.52M5.98M8.50M
vr_users5808320.00K512.00K832.00K
wsg46169193.13M53.60M146.74M
wsg_daily76164.00K0.00B64.00K
wsg_deleted3431.48K4.49K35.97K
wsg_extra016.00K0.00B16.00K
wsg_images1316339.26M5.77M15.03M
wsg_threads116591.52M1.13M2.64M
wsg_users4944272.00K352.00K624.00K
117.07G59.08G176.15G
This data is exported directly from the `INFORMATION_SCHEMA` table which is fairly accurate to an extent.

Flonne Storage Space

@????:~# df -h

Filesystem       Size  Used Avail Use% Mounted on
flonne:/var/data  11T  3.2T  7.1T  32% /storage/flonne

Revy’s Network Traffic

ethstatus-revy

@revy:~# vnstat -d

 eth0  /  daily

         day         rx      |     tx      |    total    |   avg. rate
     ------------------------+-------------+-------------+---------------
      07/05/14     11.36 GiB |   14.47 GiB |   25.83 GiB |    2.51 Mbit/s
      07/06/14    151.47 GiB |  187.74 GiB |  339.21 GiB |   32.93 Mbit/s
      07/07/14    207.21 GiB |  253.28 GiB |  460.49 GiB |   44.71 Mbit/s
      07/08/14    171.41 GiB |  229.71 GiB |  401.13 GiB |   38.95 Mbit/s
      07/09/14    169.07 GiB |  224.15 GiB |  393.21 GiB |   38.18 Mbit/s
      07/10/14    180.35 GiB |  241.88 GiB |  422.23 GiB |   40.99 Mbit/s
      07/11/14    185.16 GiB |  244.98 GiB |  430.14 GiB |   41.76 Mbit/s
      07/12/14    162.88 GiB |  209.32 GiB |  372.20 GiB |   36.14 Mbit/s
      07/13/14    166.61 GiB |  214.40 GiB |  381.00 GiB |   36.99 Mbit/s
      07/14/14    176.49 GiB |  235.14 GiB |  411.62 GiB |   39.96 Mbit/s
      07/15/14    171.52 GiB |  236.30 GiB |  407.81 GiB |   39.59 Mbit/s
      07/16/14    173.03 GiB |  216.47 GiB |  389.49 GiB |   37.82 Mbit/s
      07/17/14    163.47 GiB |  203.22 GiB |  366.69 GiB |   35.60 Mbit/s
      07/18/14    152.54 GiB |  205.14 GiB |  357.68 GiB |   34.73 Mbit/s
      07/19/14    165.00 GiB |  192.82 GiB |  357.82 GiB |   34.74 Mbit/s
      07/20/14    148.24 GiB |  186.43 GiB |  334.68 GiB |   32.49 Mbit/s
      07/21/14    175.79 GiB |  224.69 GiB |  400.48 GiB |   38.88 Mbit/s
      07/22/14    172.28 GiB |  205.64 GiB |  377.93 GiB |   40.51 Mbit/s
     ------------------------+-------------+-------------+---------------
     estimated    190.25 GiB |  227.09 GiB |  417.34 GiB |
@revy:~# vnstat -m

 eth0  /  monthly

       month        rx      |     tx      |    total    |   avg. rate
    ------------------------+-------------+-------------+---------------
      Jul '14      2.84 TiB |    3.64 TiB |    6.47 TiB |   29.38 Mbit/s
    ------------------------+-------------+-------------+---------------
    estimated      4.01 TiB |    5.15 TiB |    9.16 TiB |

Amaterasu’s Network Traffic

ethstatus-amaterasu

@amaterasu:~# vnstat -d

 eth0  /  daily

         day         rx      |     tx      |    total    |   avg. rate
     ------------------------+-------------+-------------+---------------
      06/23/14     65.89 GiB |  108.87 GiB |  174.76 GiB |   16.97 Mbit/s
      06/24/14     65.24 GiB |  103.72 GiB |  168.96 GiB |   16.40 Mbit/s
      06/25/14     65.44 GiB |  106.89 GiB |  172.32 GiB |   16.73 Mbit/s
      06/26/14     71.92 GiB |  111.97 GiB |  183.89 GiB |   17.85 Mbit/s
      06/27/14     72.78 GiB |  131.58 GiB |  204.35 GiB |   19.84 Mbit/s
      06/28/14     73.05 GiB |  121.74 GiB |  194.79 GiB |   18.91 Mbit/s
      06/29/14     69.84 GiB |  113.46 GiB |  183.30 GiB |   17.80 Mbit/s
      06/30/14     78.57 GiB |  123.45 GiB |  202.02 GiB |   19.61 Mbit/s
      07/01/14     85.22 GiB |  134.56 GiB |  219.78 GiB |   21.34 Mbit/s
      07/02/14     89.50 GiB |  335.31 GiB |  424.82 GiB |   41.25 Mbit/s
      07/03/14     82.20 GiB |  185.88 GiB |  268.08 GiB |   26.03 Mbit/s
      07/04/14     76.90 GiB |  133.38 GiB |  210.28 GiB |   20.42 Mbit/s
      07/05/14     80.18 GiB |  122.12 GiB |  202.30 GiB |   19.64 Mbit/s
      07/06/14     82.95 GiB |  124.56 GiB |  207.50 GiB |   20.15 Mbit/s
      07/07/14    101.85 GiB |  165.07 GiB |  266.92 GiB |   25.92 Mbit/s
      07/08/14     86.99 GiB |  130.81 GiB |  217.80 GiB |   21.15 Mbit/s
      07/09/14     95.12 GiB |  151.22 GiB |  246.34 GiB |   23.92 Mbit/s
      07/10/14    115.46 GiB |  160.81 GiB |  276.27 GiB |   26.82 Mbit/s
      07/11/14    109.71 GiB |  162.19 GiB |  271.90 GiB |   26.40 Mbit/s
      07/12/14     85.29 GiB |  131.52 GiB |  216.81 GiB |   21.05 Mbit/s
      07/13/14     91.76 GiB |  128.53 GiB |  220.30 GiB |   21.39 Mbit/s
      07/14/14     94.85 GiB |  143.48 GiB |  238.33 GiB |   23.14 Mbit/s
      07/15/14     99.52 GiB |  142.49 GiB |  242.01 GiB |   23.50 Mbit/s
      07/16/14     95.06 GiB |  133.21 GiB |  228.26 GiB |   22.16 Mbit/s
      07/17/14     95.43 GiB |  126.62 GiB |  222.05 GiB |   21.56 Mbit/s
      07/18/14     92.96 GiB |  131.83 GiB |  224.79 GiB |   21.83 Mbit/s
      07/19/14     90.20 GiB |  131.82 GiB |  222.02 GiB |   21.56 Mbit/s
      07/20/14     97.18 GiB |  252.87 GiB |  350.04 GiB |   33.99 Mbit/s
      07/21/14    114.14 GiB |  146.95 GiB |  261.09 GiB |   25.35 Mbit/s
      07/22/14     94.39 GiB |  121.27 GiB |  215.67 GiB |   23.18 Mbit/s
     ------------------------+-------------+-------------+---------------
     estimated    104.48 GiB |  134.23 GiB |  238.71 GiB |
@amaterasu:~# vnstat -m

 eth0  /  monthly

       month        rx      |     tx      |    total    |   avg. rate
    ------------------------+-------------+-------------+---------------
      Jun '14      1.32 TiB |    2.11 TiB |    3.43 TiB |   11.36 Mbit/s
      Jul '14      2.01 TiB |    3.32 TiB |    5.33 TiB |   24.17 Mbit/s
    ------------------------+-------------+-------------+---------------
    estimated      2.84 TiB |    4.69 TiB |    7.54 TiB |