ืขืก ืืื ืึทืืื ืคืืึทื ืืืขื ืึทืืข ืื ื ืืืืืง ืืืกื ืืืื ืืขื ืขื ืืื ืืึทื ื: ืึท ืืื ืคืขืืขืจ ืืื ื ืึธืืขืคึผืึทื, ืึท ืฉืึทืจืคึผืึทื ื ืืืืึทืขืจ, ืึท ืืึทืงืืืขื ืืืื, ืึท ืคึผืึธืจ ืคืื ืขืงืกืืจืข ืืืืจืขืก, ืืื"ื ื. ื ื ืืืืืืืขืจืงืืื ืข ืืื ื ืฆืื ื ื ืืฉ ื ืืืืคืืขืจืงืืืืงืฒื , ื ื ืจ ืืฒื ื ืืจืื ื ืฆื ื ืืขืื . ืื ืืขืืืข ืืขืฉืืืืข ืืื ืืื ืคืึทืจืฉืืื ืจืืจืขืืืืืง ืืื ืืขืกืงืืึทืคึผ ืึทืคึผืืึทืงืืืฉืึทื ื: ืคึฟืึทืจ ืืึทื ื ืกืงืจืขืขื ืฉืึธืฅ, ืคึฟืึทืจ ืจืืืืกืื ื ืื ืืจืืืก ืคืื ืึท ืืืื, ืคึฟืึทืจ ืงืึทืืงืืึทืืืืืื ื ืคืขืจืืขื ืืขืืข ืคืื ืึทื ืกืขืก, ืืืงืฉืึทื ืขืจืื, ืืืืขืจืืขืฆืขืจ, ืงืึทื ืืืขืจืืขืจื, ืขืืง. ืฆื ืืืจ ืืึธืื ืืืื?
ืงืืืื ืืื ืืื ืื ืืขืงืืืขื, ืืืจืื.
ืขืจ ืืื ืึทืืื - ืืื ืืืขืจ ืืืคึผืก ืคึฟืึทืจ ืืจืืึทืกืืง
ืืืจ ืืึธืื ืืืืขื ืขื ืึท ืคึผืืึทืฅ ืคืื ืึทืจืืืงืืขื ืคืื ืงืึธืืคึผืขืืืืึธืจืก ืืื ืืืืขืจื ืืืึธืก ืืึธืื ืืขืฉืจืืื 3-4 ืืึธืจ ืฆืืจืืง ืืืขืื ืืืึธืก ืึท ืืืืืง VPS ืืื ื ืื ืืืจืฃ. ื ื, ืืึธืก ืืื ืจืขืื, ืืขืืึธืื VPS "ืคึฟืึทืจ ืึท ืคึผืขื ื" ืืื ืืขืืืขื ืจืืื ืคึฟืึทืจืงืืืฃ ืืื ืงืขื ื ืืฉื ืคืึธืจืฉืืึธืื ื ืึธืจืืึทื ืึทืจืืขื ืึทืคึผืขืจืืื ืึทืืื. ืึธืืขืจ ืื ืฆืืื ืืื ืืฉืึทื ืืื ื, ืื ืคึผืจืืึทื ืคืื ืืืืจืืืึทื ืจืขืกืืจืกื ืืืขืจื ื ืืืขืจืืงืขืจ ืืื ื ืืืขืจืืงืขืจ, ืืื ืคึฟืึทืจ 30 ืจืืื ืคึผืขืจ ืืืืฉ ืืืจ ืืขื ืขื ืืจืืื ืฆื ืคืึธืจืฉืืึธืื ืืขื:
- ืคึผืจืึทืกืขืกืขืจ: Intel Xeon 2 GHz (1 ืืึทืจืฅ)
- ืืื ืืงืก ืกืืกืืขื (ืืขืืืึทื, ืืืื ืื, ืกืขื ืืึธืก ืฆื ืงืืืึทืื ืคืื)
- 1 ืืขืืึทืงืืืืึทื IPv4 ืึทืืจืขืก
- 10 ืืืืืืืื ืคืื ืืึทืื ืกืืึธืจืืืืฉ ืืืืฃ ืฉื ืขื ืขื ืืขืจืคึผืจืืื ืงืืึทืก ืกืกื ืืจืืืืื
- ืืึทืจืึทื: 512 ืืขืืืืืืื
- ืคึผืขืจ ืจืืข ืืืืื ื
- ืื ืืืืืืขื ืคืึทืจืงืขืจ
ืืขืจ ืฆืึธื ืืื ืืื ืืขืจืืขื ืืง ืฆื ื ืึธื ืืขืื ืืฉ ืจืืกืืจืืงืฉืึทื ื, ืืขืืึทืืืก ืืืืฃ
ืคึฟืึทืจ ืืืขืืขื ืืื ืืขืจ ืืืืจืืืขื ืกืขืจืืืขืจ ืคึผืึทืกืืง? ืืึธ ืฆื ืึผืืขื ืึทืืขืืขื: ืืืืื ืขืจื, ืขื ืืืืืึทืกืฅ, ืืงืกืคึผืืจืืึทื ืกื ืืขืืืขืืึธืคึผืขืจืก, ืืื ืคืึทื ืก ืืื ืืคืืื ืขืืืขืืข ืงืึธืืคึผืึทื ืืขืก.
ืืืึธืก ืืื ืืขื VPS ืคึผืึทืกืืง ืคึฟืึทืจ?
ืืืจ ืืจืึทืืื ืึทื ืื ืืืืขื ืขืจ ืคืื Habr ืืืขืื ืืืฉืืืื ืืขืคึฟืื ืขื ืืืืขืจ ืืืืืขื ืข ืืืขื ืฆื ื ืืฆื ืืขื ืงืึทื ืคืืืืขืจืืืฉืึทื, ืึธืืขืจ ืืืจ ืืึทืฉืืึธืกื ืฆื ืืึทืืืขื ืืื ืืืขืจ ืืืืืขื ืข ืกืขืืขืงืฆืืข ืคืื โโโโืืืืขืขืก - ืืืึธืก ืืืื ืขืืขืฆืขืจ ืืึทืจืฃ ืขืก, ืึธืืขืจ ืื ืืขื ืืฉื ืืึธื ื ืื ืืืืกื?
- ืฉืืขืื ืืืื ืคึผืฉืื ืืืขืืืืืื, ืคึผืึธืจืืคืขื, ื ืขืืขื ืืื ืืืืืขืจ ืืื ืงืึธื, ืขืืง. ืคืื ืงืืจืก, ืืืื ืืืืืขื ืข ืืืืืื ื ืืืขืืืืืื ืืืื ืึท positive ืจืืฉื ืืืืฃ ืืขืจ ืืึทืืขืืึธืก. ืฉืืขืื ืขืก ืืืืฃ ืืืื VPS ืืื ืืืื ืคืึทืจืึทื ืืืืึธืจืืืขื ืคึฟืึทืจ ืื ืืืืขืจืืืื ืืื ืคืขืกืืงืืึทื ืคืื ืื ืคึผืืึทืฅ ืืื, ืืื ื ืืฉื ืืืจื ืื ืฉืืขืงื ืคืื ืจืขืืืืขืจ ืืึธืกืืื ื ืคึผืจืึทืืืืืืขืจื.
- ื ืืฆื VPS ืคึฟืึทืจ ืืืืืื ืืงืจืืื ืฆืืืขืงื: ืืึทืืขืืึธืก ืืืื ืคึผืจืืืขืงื, ืืขืจื ืขื ืื ืคึฟืขืึดืงืืืื ืคืื ืื ืกืขืจืืืขืจ ืืื ืกืขืจืืืขืจ ืึธืคึผืขืจืืืืื ื ืกืืกืืขื, ืขืงืกืคึผืขืจืืืขื ื ืืื ืื ืก, ืืื ืงืขืจ ืืื ืึท ืงืืืื ืืืืืื ืืงืจืืื ืคึผืืึทืฅ.
- ืคึฟืึทืจ ืืขืืขืคืึธื ื. ืืื ืึท ืืืื ืึทื ืืจืึทืคึผืจืึทื ืขืจ, ืคืจืืืึทื ืกืขืจ ืึธืืขืจ ืึท ืืืืขืจ ืงืืืื ืคืืจืืข ืืึทืจืฃ ืืขืกืคึผืขืจืึทืืื IP ืืขืืขืคืึธื ื, ืืื ืื ืึธืคึผืขืจืืืืขืจื ืคืื ืืขื ืืืืขืจ ืืขืืขืคืึธื ืืขื ืขื ืืืืขืจ ืืฉืขืื ืข. ืขืก ืืื ืคึผืฉืื: ืืืจ ื ืขืืขื ืืื ืืืขืจ ืกืขืจืืืขืจ, ืงืืืคื ืึท ื ืืืขืจ ืคืื ืึทื IP ืืขืืขืคืึธื ืึธืคึผืขืจืึทืืึธืจ, ืฉืืขืื ืึทืจืืืฃ ืึท ืืืืจืืืึทื ืคึผืืงืก ืืื ืฉืึทืคึฟื ืื ืขืจืืขื ื ืืืขืจื (ืืืื ื ืืืืืง). ืื ืกืืืืืื ืื ืืขื ืขื ืงืึธืืึธืกืึทื.
- ื ืืฆื ืื ืกืขืจืืืขืจ ืฆื ืคึผืจืืืืจื ืืืื ืึทืคึผืืึทืงืืืฉืึทื ื.
- ื ืืฆื ืื ืกืขืจืืืขืจ ืคึฟืึทืจ ืืื ืืงืกืคึผืขืจืึทืืึทื ืฅ, ืึทืจืืึทื ืืขืจืขืื ื ืงืึทื ืืจืึธืืืื ื ืืื ืงืึทืืขืงืืื ื ืืึทืื ืคืื ืกืขื ืกืึธืจืก ืคืื ืงืืื ืืืื ืกืืกืืขื.
- ืึท ืืืืขืืืืื ืืืขื ืืืขื ืฆื ื ืืฆื ืขืก ืืื ืฆื ืฉืืขืื ืึท ืืืืจืืืึทื ืืืขืงืกื ืืจืืืืื ื ืึทืกืืกืืึทื ื, ืึท ืืจืืืืื ื ืจืึธืืึธื, ืืืืฃ ืื ืกืขืจืืืขืจ. ืืืจ ืืืขื ืืืื ืืึธืจ ืคืึทืจืึทื ืืืืึธืจืืืขื ืคึฟืึทืจ ืื ืคืขืกืืงืืึทื ืืื ืืืืขืจืืืื ืคืื ืื ืกืขืจืืืขืจ, ืืืึธืก ืืืื ืืืจ ืืืขื ืืึทืงืืืขื ืึท ืงืึทื ืืจืึธืืื ืงืืืืข ืคึฟืึทืจ ืืจืืืืื ื ืืืืฃ ืื ืืึทืืขืจ ืืืจืงืคืืขืฆืขืจ. ื ื, ืืืื ืืืขืจ ืขืก ืื ืืื ืืื ืืขืจืขืกืืจื ืึธืืขืจ ืคึผืืึทื ืืจืื ื :)
ืขืก ืืขื ืขื ืึทืคึผืืึทืงืืืฉืึทื ื ืคึฟืึทืจ ืึทืืึท ืืืคึผืก ืืื ืื ืคึฟืืจืืข ืงืืื. ืืื ืึทืืืฉืึทื ืฆื ืื ืฉืืื ืืขืจืืื ื ืืขืืขืคืึธื ืืื ืกื, ืืืจ ืงืขื ืขื ืื ืกืืจืืืขื ื ืขืืืขืืข ืืฉืืงืึทืืืข ืืื ืื. ืืืฉื:
- ืฉืืขืื ืงืืืื ืืึทืืึทืืืืกืื ืืื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืึธืก ืืืขื ืืืื ืฆืืืจืืืืขื ืฆื ืืจืึทืืืึทืืื ื ืขืืคึผืืืืื ืืื ืึท ืืืืึทืืงืืื, ืืืฉื, ื ืืฆื ืคืืคึผ. ืืึธืก ืืืขื ืืึธืื ืืืจ ืฆื ืืขืฉืืืื ื ืืืึทืื ืคืจืืฉ ืึทื ืึทืืืืืงืก, ืืขืจืืืึทื ืืืงื ืงืึทื ืคืืืืขืจืืืฉืึทื ื ืคึฟืึทืจ ืคืืจืงืืืคืื ื ืืขื ืืฉื, ืคึผืจืขืืึทื ืืืืฉืึทื ื, ืขืืง.
- ืืขืื ืฆืืืืืืืืืืืข ืึทืงืกืขืก ืฆื ื ืืฆืขืจืก ืึธืืขืจ ืงืืืืึทื ืฅ ืฆื ืืึทืืืืึทืื ืืืืืืืืืจื ืึธืืขืจ ืืขืืืข.
VPS ืคึผืจืืืืจื ืคืึธืจ ืคึฟืึทืจ 30 ืจืืื - ืืขืืื ืคึฟืึทืจ ืืืจ
30 ืจืืื ืืื ืึทืืื ืงืืืื ืึทื ืืืจ ืืึธื ื ืื ืืคืืื ืืืืื ืฆื ื ืขืืขื ืึท ืงืึธืจื ืฆื ืืึทืฆืึธืื ืืื ืคึผืจืืืืจื. ืืืจ ืืขื ืขื ืืื ืึทืืื ืคืืื ืืืื, ืึธืืขืจ ืืึธืก ืืึธื ืืืจ ืืึธืื ืึทืืฅ ืคึฟืึทืจ ืืืจ. ืืืืืขืจ ืืึธื ืืฉืื ื ืื ืกืขืจืืืขืจืก ืืื ืฉืืึทืื, ืืืจ ืืขืคืืจื ืึท ืคึผืจืึธืืข ืฆื ืงืึธื ืืจืึธืืืจื ืึทืืข ืื ืืขืืึทืืืก ืืื ืืืืึทืื ืืืึธืก ืื ืกืขืจืืืขืจืก ืืขื ืขื ืืืืืขืืืืืง ืคืื ืืขื ืฆืึธื. ืฆื ืืึทืื ืขืก ืืขืจ ืืฉืืงืึทืืืข, ืืืจ ืฆืืืขืืขืื ืขืงืกืืจืขื ืืื ืึธืคึผืืขืฉืืขืื ืืื ืื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืืึธืื ืืืื ืืืืืืืื ืืืื ืื ืืขืืืืืงืืึทื ืืื ืืึทืกืข ืืงืกืื ืื ืืืึทืืืขืก ืืืึธืก ืืืจ ืฉืืขืื.
ืืขืจ ืืึทืืขืืึธืก ืืื ืืขืืืขื ืืื ืืขืจ ืื ืืึทืกืข ืคืื โโืึท ื ืืืขืจ ืคืื ืืืืจืืืึทื ืืืฉืื ืขื ืืืึธืก ืืึธืื ืืืจืืืขืงืึธืื ืคืึทืจืฉืืื ืืึทืกืงืก ืืืืฃ ืื ืคึผืจืึทืกืขืกืขืจ ืืื ืึทืงืืืืืื ืืขืืืืื ื ืื ืืืกืง ืกืึทืืกืืกืืึทื. ืืขืจ ืฆืื ืืื ืฆื ืกืืืืืืจื ืึท ืืืื ืืขืืืืืงืืึทื ืคืื ืคึผืืืืกืืึทื ื ืืื ืึท ืืึทืกืข ืคืึทืจืืืืึทืืืขื ืฆื ืึธืืขืจ ืืจืขืกืขืจ ืืื ืึท ืงืึทืืืึทื ืืืื ืขืจ.
ืืื ืึทืืืฉืึทื ืฆื ืื ืงืขืกืืืืขืจืืืง ืืึทืกืข, ืืืจ ืืื ืกืืึทืืืจื 3 ืืืืจืืืึทื ืืืฉืื ืขื ืืืึธืก ืืขืืืืื ืกืื ืืขืืืฉ ืืขืืจืืงืก ื ืืฆื ืกืืกืืขื ืืฉ, ืื ืืืจืืฉื ืืืืขื ืจืขืืืืืึทืื ืคืื ืืืึธืก ืืขื ืขื ืืขืืขืื ืืื ืื, ืืื 50 ืืืืจืืืึทื ืืืฉืื ืขื ืืืึธืก ืืืฉืืคื ื ืึธื ืืึทืกืข. ืึทืืข ืคึผืจืึธืืข ืืืืจืืืึทื ืืืฉืื ืขื ืืึธืื ืื ืืขืืืข ืงืึทื ืคืืืืขืจืืืฉืึทื (1 ืืึทืจืฅ, ืืึทืจืึทื 512 ืืืืืืืื, ืกืกื 10 ืืืืืืืื), ืื ื ืึธืจืืึทื ืืขืืืึทื 9.6 ืืืื ืืื ืืืืกืืขืงืืืื ืืื ืื ืึธืคึผืขืจืืืืื ื ืกืืกืืขื, ืืืึธืก ืืื ืืขืคึฟืื ื ืฆื ื ืืฆืขืจืก ืืืืฃ RUVDS.
ืื ืืึทืกืข ืืื ืกืืืืึทืืืืืื ืืื ื ืึทืืืจ ืืื ืืึทืื ืึทืืื ืคืึทืจืืืืึทืืืขื ืฆื ืงืึทืืืึทื:
- ืขืืืขืืข ืืืืจืืืึทื ืืืฉืื ืขื ืืขื ืขื ืืึธื ืืฉื ืืื ื ืืืขืจืืง ืืึทืกืข
- ืขืืืขืืข ืืืฉืื ืขื ืืืืคื ืึท ืคึผืจืึธืืข ืฉืจืืคื ืกืืืืึทืืืืืื ื ืื ืืึทืกืข ืืืืฃ ืื ืคึผืจืึทืกืขืกืขืจ (ื ืืฆื ืื ื ืืฆื
ืืจืืง ) - ืืืืฃ ืื ืจืืขื ืืืื ืคืื ืื ืืืืจืืืึทื ืืืฉืื ืขื, ืืืจ ืืืืคื ืึท ืฉืจืืคื ืืืึธืก ืืขืืืืื ื dd ืฆื ื ืึธืืืึทืื ืืึทืื ืคืื ืคืึทืจ-ืฆืืืขืืจืืื ืืึทืื ืฆื ืืืกืง ืืื ืึท ืืืืื ืืึทืฉืืขืืืงื ื ืืฆื ืคึผืื (ืืืฉืคืืื ืงืขื ืขื ืืืื ืืขืืขื
ืืึธ ะธืืึธ ).
ืืืื, ืืื ืืืจ ืืขืืขื ืงืขื, ืืืจ ืืึธืื ืืจืืึท ืืืฉืื ืขื ืืืึธืก ืืขืืืืื ืกืื ืืขืืืฉ ืืขืืจืืงืก.
ืืืืฃ ืืขืืขืจ ืืึทืฉืื, ืึท ืฉืจืืคื ืืื ืขืงืกืึทืงืืืืึทื ืกืืืงืืืงืื ืืขืืขืจ 15 ืืื ืื, ืืืึธืก ืืืืคื ื ืึธืจืืึทื ืกืืกืืืขื ืืฉ ืืขืกืฅ ืคึฟืึทืจ ืื ืคึผืจืึทืกืขืกืขืจ, ืืึผืจืื ืืื ืืืกืง.
ืฉืจืืคื sysbench.sh
#!/bin/bash
date +"%Y-%m-%d %H:%M:%S" >> /root/sysbench/results.txt
sysbench --test=cpu run >> /root/sysbench/results.txt
sysbench --test=memory run >> /root/sysbench/results.txt
sysbench --test=fileio --file-test-mode=seqwr run >> /root/sysbench/results.txt
sysbench --test=fileio --file-test-mode=seqrd run >> /root/sysbench/results.txt
sysbench --test=fileio --file-test-mode=rndrw run >> /root/sysbench/results.txt
ืื ืจืขืืืืืึทืื ืืขื ืขื ืืขืจืืื ืื ืคึฟืึทืจ ืงืึทื ืืืื ืืึทื ืก ืืื ืกืืกืืืขื ืืฉ ืคึฟืึธืจืืึทื, ืึธืืขืจ ืื ืืืจืืฉื ืืืืขื ืืืึทืืืขืก ืคึฟืึทืจ ืื ืืื ืฆืข ืืขืกืืื ื ืฆืืึทื ืืขื ืขื ืืขื ืืืขื ืคืื ืึทืืข ืืืฉืื ืขื, ืืขืจ ืจืขืืืืืึทื ืงืขื ืขื ืืืื ืืขืืขื ืืึธ:
Sysbanch-avg.txtsysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Doing CPU performance benchmark
Threads started!
Done.
Maximum prime number checked in CPU test: 10000
Test execution summary:
total time: 19.2244s
total number of events: 10000
total time taken by event execution: 19.2104
per-request statistics:
min: 1.43ms
avg: 1.92ms
max: 47.00ms
approx. 95 percentile: 3.02ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 19.2104/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Doing memory operations speed test
Memory block size: 1K
Memory transfer size: 102400M
Memory operations type: write
Memory scope type: global
Threads started!
Done.
Operations performed: 104857600 (328001.79 ops/sec)
102400.00 MB transferred (320.32 MB/sec)
Test execution summary:
total time: 320.9155s
total number of events: 104857600
total time taken by event execution: 244.8399
per-request statistics:
min: 0.00ms
avg: 0.00ms
max: 139.41ms
approx. 95 percentile: 0.00ms
Threads fairness:
events (avg/stddev): 104857600.0000/0.00
execution time (avg/stddev): 244.8399/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 16Mb each
2Gb total file size
Block size 16Kb
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing sequential write (creation) test
Threads started!
Done.
Operations performed: 0 Read, 131072 Write, 128 Other = 131200 Total
Read 0b Written 2Gb Total transferred 2Gb (320.1Mb/sec)
20251.32 Requests/sec executed
Test execution summary:
total time: 6.9972s
total number of events: 131072
total time taken by event execution: 5.2246
per-request statistics:
min: 0.01ms
avg: 0.04ms
max: 96.76ms
approx. 95 percentile: 0.03ms
Threads fairness:
events (avg/stddev): 131072.0000/0.00
execution time (avg/stddev): 5.2246/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 16Mb each
2Gb total file size
Block size 16Kb
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing sequential read test
Threads started!
Done.
Operations performed: 131072 Read, 0 Write, 0 Other = 131072 Total
Read 2Gb Written 0b Total transferred 2Gb (91.32Mb/sec)
5844.8 Requests/sec executed
Test execution summary:
total time: 23.1054s
total number of events: 131072
total time taken by event execution: 22.9933
per-request statistics:
min: 0.00ms
avg: 0.18ms
max: 295.75ms
approx. 95 percentile: 0.77ms
Threads fairness:
events (avg/stddev): 131072.0000/0.00
execution time (avg/stddev): 22.9933/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 16Mb each
2Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random r/w test
Threads started!
Done.
Operations performed: 6000 Read, 4000 Write, 12800 Other = 22800 Total
Read 93.75Mb Written 62.5Mb Total transferred 156.25Mb (1341.5Kb/sec)
85.61 Requests/sec executed
Test execution summary:
total time: 152.9786s
total number of events: 10000
total time taken by event execution: 14.1879
per-request statistics:
min: 0.01ms
avg: 1.41ms
max: 210.22ms
approx. 95 percentile: 4.95ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 14.1879/0.00
ืื ืจืขืืืืืึทืื ืืขื ืขื ืื ืืืงืึทืืืื, ืึธืืขืจ ื ืึธื ืืึธื ื ืื ืืืื ืืขื ืืืขื ืืื QoS.
ืืืฉืื ืขื ืืืึธืก ืืึทืื ื ืึธื ืืึทืกืข
ืืืืืืืืืจื:
- ืึทืคึผื-ืืึทืงืืืขื ืืขืจืืืึทื ืืืงื
- ืคืืืืง-ืืึทืงืืืขื ืึทืคึผืืจืืื
- apt-get ืื ืกืืึทืืืจื ืคึผืืืืึธื-ืคึผืืคึผ
- ืคึผืืคึผ ืื ืกืืึทืืืจื mysql-connector-python-rf
ืืื ืกืืึทืืืจื MariaDB, ืืื ืฆื
apt-get install libmariadbclient-dev
mysql -e "INSTALL PLUGIN blackhole SONAME 'ha_blackhole.so';" -- ะฝัะถะฝะพ ะดะปั test_employees_sha
ืืขืกื ืืึทืืข ืืขื ืืืขื
ืื ืืึทืืึทืืืืก ืืื ืืืคึผืืืื ืืื ืกืคึผืขืกืืคืืขื
mysql -t < employees.sql
mysql -t < test_employees_sha.sql
ืงืืืื ืคึผืจืืืืจื ืืึทืืข:
ืืืฉ
RowsCount
ืืึทืื ืืจืืืก (MB)
ืืื ืืขืงืก ืืจืืืก (KB)
ืืืคึผืึทืจืืืึทื ืฅ
9
0.02
16.00
dept_emp
331143
11.52
5648.00
ืืขืคึผื_ืคืึทืจืืืึทืืืขืจ
24
0.02
16.00
ืขืืคึผืืืืื
299379
14.52
0.00
ืกืึทืืขืจืื
2838426
95.63
0.00
ืืืืืขื
442783
19.56
0.00
ื ืคึผืจืืืืืืื ืคึผืจืืืืจื ืืื ืกื ืืื ืืขืฉืจืืื ืืืืฃ ืื ืงื ื ืืื ืคึผืืืืึธื; ืขืก ืคึผืขืจืคืึธืจืื ืคืืจ ืึทืคึผืขืจืืืฉืึทื ื:
- getState: ืงืขืจื ืื ืกืืึทืืืก
- getEmployee: ืงืขืจื ืขืืคึผืืืืื (+ ืกืึทืืขืจืื, + ืืืืืขื) ืคึฟืื ืื ืืึทืืึทืืืืก
- patchEmployee: ืขื ืืขืจืื ืืขื ืึธื ืืขืฉืืขืืืขืจ ืคืขืืืขืจ
- insertSalary: ืื ืกืขืจืฅ ืึท ืืขืฆืึธืื
ืกืขืจืืืืก ืืงืืจ (dbtest.py)
#!/usr/bin/python
import mysql.connector as mariadb
from flask import Flask, json, request, abort
from mysql.connector.constants import ClientFlag
app = Flask(__name__)
def getFields(cursor):
results = {}
column = 0
for d in cursor.description:
results[d[0]] = column
column = column + 1
return results
PAGE_SIZE = 30
@app.route("/")
def main():
return "Hello!"
@app.route("/employees/<page>", methods=['GET'])
def getEmployees(page):
offset = (int(page) - 1) * PAGE_SIZE
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees')
cursor = connection.cursor()
cursor.execute("SELECT * FROM employees LIMIT {} OFFSET {}".format(PAGE_SIZE, offset))
return {'employees': [i[0] for i in cursor.fetchall()]}
@app.route("/employee/<id>", methods=['GET'])
def getEmployee(id):
id = int(id)
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees')
cursor = connection.cursor()
cursor.execute("SELECT * FROM employees WHERE emp_no = {}".format(id))
fields = getFields(cursor)
employee = {}
found = False
for row in cursor.fetchall():
found = True
employee = {
"birth_date": row[fields["birth_date"]],
"first_name": row[fields["first_name"]],
"last_name": row[fields["last_name"]],
"gender": row[fields["gender"]],
"hire_date": row[fields["hire_date"]]
}
if not found:
abort(404)
cursor.execute("SELECT * FROM salaries WHERE emp_no = {}".format(id))
fields = getFields(cursor)
salaries = []
for row in cursor.fetchall():
salary = {
"salary": row[fields["salary"]],
"from_date": row[fields["from_date"]],
"to_date": row[fields["to_date"]]
}
salaries.append(salary)
employee["salaries"] = salaries
cursor.execute("SELECT * FROM titles WHERE emp_no = {}".format(id))
fields = getFields(cursor)
titles = []
for row in cursor.fetchall():
title = {
"title": row[fields["title"]],
"from_date": row[fields["from_date"]],
"to_date": row[fields["to_date"]]
}
titles.append(title)
employee["titles"] = titles
return json.dumps({
"status": "success",
"employee": employee
})
def isFieldValid(t, v):
if t == "employee":
return v in ["birdth_date", "first_name", "last_name", "hire_date"]
else:
return false
@app.route("/employee/<id>", methods=['PATCH'])
def setEmployee(id):
id = int(id)
content = request.json
print(content)
setList = ""
data = []
for k, v in content.iteritems():
if not isFieldValid("employee", k):
continue
if setList != "":
setList = setList + ", "
setList = setList + k + "=%s"
data.append(v)
data.append(id)
print(setList)
print(data)
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees', client_flags=[ClientFlag.FOUND_ROWS])
cursor = connection.cursor()
cursor.execute("UPDATE employees SET {} WHERE emp_no = %s".format(setList), data)
connection.commit()
if cursor.rowcount < 1:
abort(404)
return json.dumps({
"status": "success"
})
@app.route("/salary", methods=['PUT'])
def putSalary():
content = request.json
print(content)
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees', client_flags=[ClientFlag.FOUND_ROWS])
cursor = connection.cursor()
data = [content["emp_no"], content["salary"], content["from_date"], content["to_date"]]
cursor.execute("INSERT INTO salaries (emp_no, salary, from_date, to_date) VALUES (%s, %s, %s, %s)", data)
connection.commit()
return json.dumps({
"status": "success"
})
@app.route("/state", methods=['GET'])
def getState():
return json.dumps({
"status": "success",
"state": "working"
})
if __name__ == '__main__':
app.run(host='0.0.0.0',port='5002')
ืืืืจืขื ืื ื! ืืื ืงืืื ืฆืืฉืืื ืื ืืึธื ืื ืืื ืกื ืืืื ืืขื ืืืขื ืืื ืึท ืืืึทืฉืคึผืื ืึธืืขืจ ืคืืจืขืจ!
ืืขืกืฅ ืืขื ืขื ืืืจืืืขืงืึธืื ืืื ืืื ืึทืื JMeter. ื ืกืขืจืืข ืคืื โโโโืืขืกืืก ืืืึธืก ืืขืืืืขืจื ืคืื 15 ืืื ืื ืฆื 2 ืฉืขื ืืขื ืขื ืืึธื ืืฉื, ืึธื ืื ืืขืจืึทืคึผืฉืึทื ื, ืืขืจ ืคึผืจืึธืฆืขื ื ืคืื ืจืืงืืืขืก ืืืขืจืื, ืืื ืืจืืคึผืื ืืืขืจืื ืคืื 300 ืฆื 600 ืจืืงืืืขืก ืคึผืขืจ ืืื ืื. ื ืืืขืจ ืคืื ืคึฟืขืืขื ืคืื 50 ืฆื 500.
ืจืขืื ืฆื ืืขื ืคืึทืงื ืึทื ืื ืืึทืืึทืืืืก ืืื ืืืืขืจ ืงืืืื, ืื ืืึทืคึฟืขื:
mysql -e "SHOW ENGINE INNODB STATUS"
ืืืืืื ืึทื:
Buffer pool hit rate 923 / 1000, young-making rate 29 / 1000 not 32 / 1000
ืื ืืขืจ ืืขื ืขื ืื ืืืจืืฉื ืืืืขื ืขื ืืคืขืจ ืฆืืื ืคึฟืึทืจ ืจืืงืืืขืก:
ืคืืจืืข
ืืืจืืฉื ืืืืขื
ืืขืืืึทื
90% ืฉืืจื
95% ืฉืืจื
99% ืฉืืจื
ืืื
ืืืงืก
getEmployee
37.64
12.57
62.28
128.5
497.57
5
4151.78
getState
17
7.57
30.14
58.71
193
3
2814.71
patchEmployee
161.42
83.29
308
492.57
1845.14
5
6639.4
ืฉืืขืื ืืขืฆืึธืื
167.21
86.93
315.34
501.07
1927.12
7
6722.44
ืขืก ืงืขื ืืืื ืฉืืืขืจ ืคึฟืึทืจ ืืืจ ืฆื ืจืืืืขืจ ืคึฟืื ืื ืกืื ืืขืืืฉ ืจืขืืืืืึทืื ืืื ืคึผืึทืกืืง ืืขื VPS ืืื ืคึฟืึทืจ ืืืื ืกืคึผืขืฆืืคืืฉ ืืึทืกืงืก ืืื, ืืื ืึทืืืขืืืื, ืื ืืืกืืขื ืืขืืืึธืืก ืืขื ืขื ืืืืืืขื ืฆื ืื ืงืึทืกืขืก ืืืึธืก ืืืจ ืืึธืื ืฆื ืืึทื ืืืขื ืืื ืืื ืืืื ืึธืืขืจ ืื ืืขืจื ืคืึธืจืขื. ืงืืืจ ื ืืฉื ืืืกืืึทืืขืจื. ืืืจ ืืึทืื ืืืจ ืฆื ืฆืืขื ืืืื ืืืืืขื ืข ืงืึทื ืงืืืืฉืึทื ื ืืื ืคึผืจืืืืจื ืื ืกืขืจืืืขืจ ืคึฟืึทืจ 30 ืจืืื ืืืืฃ ืืืื ืคืึทืงืืืฉ ืึทืคึผืืึทืงืืืฉืึทื ื ืืื ืืึทืกืงืก ืืื ืคึฟืึธืจืฉืืึธืื ืืืื ืึธืคึผืฆืืขืก ืคึฟืึทืจ ืืขื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืื ืื ืืึทืืขืจืงืื ืืขื.
ืืงืืจ: www.habr.com