{"id":5397,"date":"2020-07-30T00:18:22","date_gmt":"2020-07-29T16:18:22","guid":{"rendered":"http:\/\/39.97.231.10\/?p=5397"},"modified":"2020-07-30T00:18:22","modified_gmt":"2020-07-29T16:18:22","slug":"mysql%e6%80%a7%e8%83%bd%e7%9b%91%e6%8e%a7%e5%b7%a5%e5%85%b7-orzdba-python%e7%89%88%e6%9c%ac-2","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=5397","title":{"rendered":"MySQL\u6027\u80fd\u76d1\u63a7\u5de5\u5177 orzdba python\u7248\u672c"},"content":{"rendered":"<div>\n<div>\norzdba \u662f\u6dd8\u5b9d\u5f00\u6e90\u7684\u4e00\u6b3eMySQL\u5b9e\u65f6\u6027\u80fd\u76d1\u63a7\u5de5\u5177\uff0c\u4f7f\u7528Perl\u8bed\u8a00\u5f00\u53d1\uff0c\u6700\u8fd1\u5728github\u4e0a\u770b\u5230\u4e00\u6b3epython\u7248\u672c\u7684orzdba\uff0c\u529f\u80fd\u4e0ePerl\u7248\u672c\u5dee\u4e0d\u591a\uff0c\u8bd5\u7528\u4e86\u4e00\u4e0b\uff0c\u603b\u4f53\u611f\u89c9\u8fd8\u4e0d\u9519\uff0c\u4e5f\u53d1\u73b0\u4e86\u4e00\u4e9b\u95ee\u9898\u3002\n<\/div>\n<\/div>\n<div>\n<div>\n<div><\/div>\n<div>\u5730\u5740\uff1a<a href=\\\"https:\/\/github.com\/cnlubo\/orzdba\\\">https:\/\/github.com\/cnlubo\/orzdba<\/a><\/div>\n<div><\/div>\n<div>\u76d1\u63a7\u9879\uff1a<\/div>\n<ul>\n<li>\n<div>CPU\u8d1f\u8f7d<\/div>\n<\/li>\n<li>\n<div>\u78c1\u76d8IO<\/div>\n<\/li>\n<li>\n<div>\u7f51\u7edc\u6d41\u91cf<\/div>\n<\/li>\n<li>\n<div>swap<\/div>\n<\/li>\n<li>\n<div>MySQL QPS<\/div>\n<\/li>\n<li>\n<div>MySQL InnoDB<\/div>\n<\/li>\n<li>\n<div>MySQL \u8fde\u63a5\u7ebf\u7a0b<\/div>\n<\/li>\n<li>\n<div>MySQL\u00a0\u7f13\u5b58\u547d\u4e2d\u7387<\/div>\n<\/li>\n<li>\n<div>MySQL\u00a0\u54cd\u5e94\u65f6\u95f4<\/div>\n<\/li>\n<\/ul>\n<div><\/div>\n<div>1\u3001\u4e0b\u8f7d<\/div>\n<div>git clone https:\/\/github.com\/cnlubo\/orzdba.git<\/div>\n<div><\/div>\n<div>2\u3001\u4f7f\u7528<\/div>\n<div>cd orzdba<\/div>\n<div>python2.7 orzdba.py -S \/mysql\/data\/mysql.sock -p\\&#8217;123456\\&#8217;\u00a0 -t -com -c -l -n eth0<\/div>\n<div><\/div>\n<div>\u8f93\u51fa\u7ed3\u679c\uff1a<\/div>\n<div>\n<div>&#8212;&#8212;&#8211; &#8212;&#8211;load-avg&#8212;- &#8212;cpu-usage&#8212;\u00a0\u00a0\u00a0&#8212;&#8211;net(B)&#8212;&#8211; &#8212;&#8212;&#8212;&#8211;QPS&#8211;TPS&#8212;&#8212;&#8212;&#8211;<\/div>\n<div>\u00a0\u00a0time\u00a0\u00a0|\u00a0\u00a01m\u00a0\u00a0\u00a0\u00a05m\u00a0\u00a0\u00a015m |usr sys idl iow|\u00a0\u00a0\u00a0\u00a0recv\u00a0\u00a0\u00a0send |\u00a0\u00a0\u00a0ins\u00a0\u00a0\u00a0upd\u00a0\u00a0\u00a0del\u00a0\u00a0\u00a0\u00a0sel\u00a0\u00a0\u00a0iud|<\/div>\n<div>21:39:54| 0.06\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00b\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00b|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:39:55| 0.06\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:39:57| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:39:58| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:39:59| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:00| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:01| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a08k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:02| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:03| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:04| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:05| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:06| 0.05\u00a0\u00a00.06\u00a0\u00a00.64|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:07| 0.04\u00a0\u00a00.06\u00a0\u00a00.63|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:08| 0.04\u00a0\u00a00.06\u00a0\u00a00.63|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<div>21:40:09| 0.04\u00a0\u00a00.06\u00a0\u00a00.63|\u00a0\u00a00\u00a0\u00a0\u00a00 100\u00a0\u00a0\u00a00|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06k\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05k|\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a00|<\/div>\n<\/div>\n<div><\/div>\n<div>3\u3001\u53c2\u6570<\/div>\n<div><\/div>\n<div>\u51e0\u4e2a\u91cd\u8981\u7684\u53c2\u6570\uff1a<\/div>\n<ul>\n<li>\n<div>-t\u00a0\u663e\u793a\u65f6\u95f4<\/div>\n<\/li>\n<li>\n<div>-l\u00a0\u663e\u793acpu\u8d1f\u8f7d<\/div>\n<\/li>\n<li>\n<div>-c\u00a0\u663e\u793acpu\u5360\u7528<\/div>\n<\/li>\n<li>\n<div>-d\u00a0\u663e\u793a\u78c1\u76d8IO\uff0c\u5982-d vdb<\/div>\n<\/li>\n<li>\n<div>-n\u00a0\u663e\u793a\u7f51\u7edc\u6d41\u91cf\uff0c\u5982-n eth0<\/div>\n<\/li>\n<li>\n<div>-com\u00a0\u663e\u793aMySQL QPS<\/div>\n<\/li>\n<li>\n<div>-innodb\u00a0\u663e\u793aInnoDB\u76d1\u63a7\u4fe1\u606f<\/div>\n<\/li>\n<li>\n<div>-T\u00a0\u663e\u793aMySQL\u8fde\u63a5\u7ebf\u7a0b\u4fe1\u606f<\/div>\n<\/li>\n<li>\n<div>-B\u00a0\u663e\u793aMySQL\u63a5\u6536\uff0c\u53d1\u9001\u7684\u6570\u636e\u91cf<\/div>\n<\/li>\n<li>\n<div>-rt\u00a0\u663e\u793a\u54cd\u5e94\u65f6\u95f4<\/div>\n<\/li>\n<li>\n<div>-hit\u00a0\u663e\u793aMySQL\u7f13\u5b58\u547d\u4e2d\u7387<\/div>\n<\/li>\n<\/ul>\n<div><\/div>\n<div>\u5168\u90e8\u53c2\u6570\uff0c\u5982\u4e0b\uff1a<\/div>\n<div>\n<div>optional arguments:<\/div>\n<div>\u00a0\u00a0-h, &#8211;help\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0show this help message and exit<\/div>\n<div>\u00a0\u00a0-i INTERVAL, &#8211;interval INTERVAL<\/div>\n<div>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Time(second) Interval.<\/div>\n<div>\u00a0\u00a0-t, &#8211;time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print The Current Time.<\/div>\n<div>\u00a0\u00a0-sys\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0print SysInfo (include -l,-c,-s).<\/div>\n<div>\u00a0\u00a0-l, &#8211;load\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Load Info.<\/div>\n<div>\u00a0\u00a0-c, &#8211;cpu\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Cpu Info.<\/div>\n<div>\u00a0\u00a0-d DISK, &#8211;disk DISK\u00a0\u00a0Print Disk Info.<\/div>\n<div>\u00a0\u00a0-n NET, &#8211;net NET\u00a0\u00a0\u00a0\u00a0\u00a0Print Net Info.Time.<\/div>\n<div>\u00a0\u00a0-s, &#8211;swap\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print The Swap Info.<\/div>\n<div>\u00a0\u00a0-com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0print mysql status.<\/div>\n<div>\u00a0\u00a0-innodb_rows\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Innodb Rows Status.<\/div>\n<div>\u00a0\u00a0-innodb_pages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Innodb Buffer Pool Pages\u00a0\u00a0Status.<\/div>\n<div>\u00a0\u00a0-innodb_data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Innodb Data Status.<\/div>\n<div>\u00a0\u00a0-innodb_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Innodb Log Status.<\/div>\n<div>\u00a0\u00a0-innodb_status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Innodb Status from Command:\u00a0\u00a0\\&#8221;Show Engine Innodb<\/div>\n<div>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Status\\&#8221;.<\/div>\n<div>\u00a0\u00a0-innodb\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Innodb Info.<\/div>\n<div>\u00a0\u00a0-T, &#8211;threads\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Threads Status.<\/div>\n<div>\u00a0\u00a0-B, &#8211;bytes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Bytes Status.<\/div>\n<div>\u00a0\u00a0-rt\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print MySQL DB RT.<\/div>\n<div>\u00a0\u00a0-hit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Innodb Hit%<\/div>\n<div>\u00a0\u00a0-mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0print SysInfo (Print MySQLInfo\u00a0\u00a0(include<\/div>\n<div>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-t,-com,-hit,-T,-B).<\/div>\n<div>\u00a0\u00a0-P PORT, &#8211;port PORT\u00a0\u00a0Port number to use for mysql\u00a0\u00a0connection(default 3306).<\/div>\n<div>\u00a0\u00a0-S SOCKET, &#8211;socket SOCKET<\/div>\n<div>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Socket file to use for mysql\u00a0\u00a0connection.<\/div>\n<div>\u00a0\u00a0-p PWD, &#8211;pwd PWD\u00a0\u00a0\u00a0\u00a0\u00a0root user password.<\/div>\n<div>\u00a0\u00a0-C COUNT, &#8211;count COUNT<\/div>\n<div>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Times.<\/div>\n<div>\u00a0\u00a0-L LOGFILE, &#8211;logfile LOGFILE<\/div>\n<div>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ath of logfile.<\/div>\n<div>\u00a0\u00a0-logfile_by_day\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0one day a logfile.<\/div>\n<div>\u00a0\u00a0-lazy\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print Info (include\u00a0\u00a0-t,-l,-c,-s,-m,-hit).<\/div>\n<\/div>\n<div><\/div>\n<div>4\u3001\u95ee\u9898<\/div>\n<div><\/div>\n<ol>\n<li>\n<div>-n \u53c2\u6570\u76d1\u63a7\u7f51\u7edc\u6d41\u91cf\uff0c\u5728RedHat 6.3 \u4e0a\u6d41\u91cf\u503c\u4e0d\u51c6\u786e\u3002\u4ee3\u7801\u4e2d\u901a\u8fc7\u5468\u671f\u6027\u8bfb\u53d6 \/proc\/net\/dev \u4e2d\u7684\u503c\u6765\u8ba1\u7b97\u7f51\u5361\u6d41\u91cf\uff0c\u4e0d\u540cLinux\u53d1\u884c\u7248 \/proc\/net\/dev \u8bfb\u51fa\u6765\u7684\u503c\u683c\u5f0f\u4e0d\u540c\uff0c\u53ef\u80fd\u6e90\u7801\u4f5c\u8005\u4e5f\u6ca1\u6709\u5728RedHat 6.3\u4e0a\u6d4b\u8bd5\u8fc7\u3002<\/div>\n<\/li>\n<li>\n<div>-com \u76d1\u63a7MySQL QPS\u65f6\uff0c\u6709\u4e00\u4e9bSQL\u65e0\u6cd5\u88ab\u76d1\u63a7\uff0c\u6bd4\u5982insert\uff0c\u53ea\u53d6\u4e86MySQL\u72b6\u6001\u53d8\u91cf\u4e2d\u7684Com_insert\uff0c\u800cCom_insert_select\u6ca1\u6709\u8ba1\u7b97\u5728\u5185\uff0c\u5bfc\u81f4insert\u7684QPS\u8ba1\u7b97\u4e0d\u51c6\u786e\u3002<\/div>\n<\/li>\n<\/ol>\n<div><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>orzdba \u662f\u6dd8\u5b9d\u5f00\u6e90\u7684\u4e00\u6b3eMySQL\u5b9e\u65f6\u6027\u80fd\u76d1\u63a7\u5de5\u5177\uff0c\u4f7f\u7528Perl\u8bed\u8a00\u5f00\u53d1\uff0c\u6700\u8fd1\u5728github\u4e0a\u770b\u5230\u4e00\u6b3ep &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/www.weijing.co\/?p=5397\"> <span class=\"screen-reader-text\">MySQL\u6027\u80fd\u76d1\u63a7\u5de5\u5177 orzdba python\u7248\u672c<\/span> \u67e5\u770b\u5168\u6587 &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90,88],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"orzdba \u662f\u6dd8\u5b9d\u5f00\u6e90\u7684\u4e00\u6b3eMySQL\u5b9e\u65f6\u6027\u80fd\u76d1\u63a7\u5de5\u5177\uff0c\u4f7f\u7528Perl\u8bed\u8a00\u5f00\u53d1\uff0c\u6700\u8fd1\u5728github\u4e0a\u770b\u5230\u4e00\u6b3ep&hellip;","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/5397"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5397"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/5397\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5397"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}