mycat性能測(cè)試案例

1、MyCAT性能測(cè)試案例測(cè)試案例一：硬件；HPZooK，8核心CPU，16G內(nèi)存。Mycat版本1.2（SVN445），默認(rèn)參數(shù)，日志級(jí)別Info操作系統(tǒng)windows764Java環(huán)境：JDK7Mysql版本版本mysql5.6.13winx64Mysql參數(shù)[mysqld]max_connections=1000innodb_buffer_pool_size=4G#innodb_flush_method=O_DIRECTinnodb_

2、flush_log_at_trx_commit=0innodb_autoextend_increment=1Ginnodb_log_file_size=256M1114:27:16finishedrecds:848622failed:0speed:22161.2827409709351114:27:17finishedrecds:870834failed:0speed:22162.0094670942131114:27:18finish

3、edrecds:888461failed:0speed:22048.914257352031114:27:19finishedrecds:917319failed:0speed:22213.2652072841114:27:20finishedrecds:947460failed:0speed:22400.6998297711361114:27:21finishedrecds:973319failed:0speed:22480.5755

4、728011831114:27:22finishedrecds:983834failed:0speed:22204.4326081068871114:27:23finishedrecds:1008703failed:0speed:22262.7513297578841114:27:24finishedrecds:1024218failed:0speed:22117.039884255761114:27:25finishedrecds:1

5、041733failed:0speed:22015.5754681093861114:27:26finishedrecds:1072460failed:0speed:22195.4096732134351114:27:27finishedrecds:1102339failed:0speed:22351.203390174171114:27:28finishedrecds:1132632failed:0speed:22508.585055

6、6438781114:27:29finishedrecds:1132632failed:0speed:22069.9922057677321114:27:30finishedrecds:1152117failed:0speed:22020.584862385321114:27:31finishedrecds:1177561failed:0speed:22084.7899474868721114:27:32finishedrecds:12

7、02844failed:0speed:22143.6671575846851114:27:33finishedrecds:1220723failed:0speed:22066.5762834417951114:27:34finishedrecds:1245612failed:0speed:22116.6903409090921114:27:35finishedrecds:1267511failed:0speed:22112.892533

8、1472421114:27:36finishedrecds:1278763failed:0speed:21926.2872721661151114:27:37finishedrecds:1307319failed:0speed:22038.0472345375161114:27:38finishedrecds:1337147failed:0speed:22167.1888728635131114:27:39finishedrecds:1

9、355188failed:0speed:22099.900523474831114:27:40finishedrecds:1368471failed:0speed:21958.4249289966461114:27:41finishedrecds:1375259failed:0speed:21718.845248811611114:27:42finishedrecds:1396753failed:0speed:21715.0119710

10、208021114:27:43finishedrecds:1419501failed:0speed:21730.8257554881971114:27:44finishedrecds:1437420failed:0speed:21673.351225837581114:27:45finishedrecds:1440410failed:0speed:21395.829000920951114:27:46finishedrecds:1471

11、056failed:0speed:21530.9046733896361114:27:47finishedrecds:1492582failed:0speed:21530.833922363431114:27:48finishedrecds:1503925failed:0speed:21385.9619185757151114:27:49finishedrecds:1530864failed:0speed:21463.518591217

12、5441114:27:50finishedrecds:1544026failed:0speed:21348.7362424644671114:27:51finishedrecds:1581157failed:0speed:21563.9763242594531114:27:52finishedrecds:1585036failed:0speed:21326.0319681394981114:27:53finishedrecds:1613

13、734failed:0speed:21423.9020763634431114:27:54finishedrecds:1637824failed:0speed:21458.833394476181114:27:55finishedrecds:1668520failed:0speed:21578.2939320262781114:27:56finishedrecds:1689672failed:0speed:21570.372639883

14、5751114:27:57finishedrecds:1707774failed:0speed:21526.110795991681114:27:58finishedrecds:1723926failed:0speed:21458.9474208325051114:27:59finishedrecds:1738865failed:0speed:21378.78676108981114:28:00finishedrecds:1744016

15、failed:0speed:21181.4372639275171114:28:01finishedrecds:1774348failed:0speed:21290.9837049125241114:28:02finishedrecds:1797359failed:0speed:21311.3780265123681114:28:03finishedrecds:1827815failed:0speed:21418.28472328009

16、61114:28:04finishedrecds:1838683failed:0speed:21295.842019921241114:28:05finishedrecds:1838885failed:0speed:21053.1226744518861114:28:06finishedrecds:1862744failed:0speed:21084.6444660765631114:28:07finishedrecds:1878794