[OpenCPS-infra] Fwd: Meeting note đội Hạ tầng + bảo mật ngày 13/04/2016

[Văn Thảo Vũ]

*Tâm xem lại dùm các VPS nhé, tốc độ ổ cứng quá thấp, rất khó để có thể làm
MySQL Cluster*
( test khi không tải )

[root at opencps-node1 ~]# dd if=/dev/zero of=1GB.tmp bs=1024 count=1M
conv=fdatasync
1048576+0 records in
1048576+0 records out
1073741824 bytes (1.1 GB) copied, 42.6399 s, *25.2 MB/s*

*Những chỗ khác* mình kiểm tra nó cao hơn nhiều
-bash-4.1$ dd if=/dev/zero of=1GB.tmp bs=1024 count=1M conv=fdatasync
1048576+0 records in
1048576+0 records out
1073741824 bytes (1.1 GB) copied, 11.06 s,
*97.1 MB/s*
[root at mail ~]# dd if=/dev/zero of=1GB.tmp bs=1024 count=1M conv=fdatasync
1048576+0 records in
1048576+0 records out
1073741824 bytes (1.1 GB) copied, 7.52945 s,


*143 MB/s-------------------------------------------------------------*

*Tốc độ ổ cứng quá thấp dẫn đến:*MariaDB [(none)]> SELECT count(*) FROM
nukeviet.nv4_vi_news_bodytext;
+----------+
| count(*) |
+----------+
|   815355 |
+----------+
1 row in set

*(1 min 25.76 sec)*
*Trong khi máy khác dữ liệu nhiều hơn nó chỉ chạy có *0.00 sec

mysql>  SELECT count(*) FROM mangvn_com.nv4_vi_news_bodytext
    -> ;
+----------+
| count(*) |
+----------+
|   836880 |
+----------+
1 row in set

* (0.00 sec)*

<https://www.avast.com/en-us/lp-safe-emailing-2109?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=oa-2109-v2-a>
Virus-free.
www.avast.com
<https://www.avast.com/en-us/lp-safe-emailing-2109?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=oa-2109-v2-a>
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencps.vn/pipermail/opencps-infra/attachments/20160416/cb735350/attachment.html>