????????????????????

?????????????????

?????????flashT

????36????

????Test1- test36:

?????????

????CREATE TABLE `test1` (
????`doc_id` int(10) unsigned NOT NULL default ’0′??
????`main_status` tinyint(3) unsigned NOT NULL default ’0′??
????`sub_status` tinyint(3) unsigned NOT NULL default ’0′??
????`create_time` int(10) unsigned NOT NULL default ’0′??
????cid1` smallint(5) unsigned NOT NULL default ’0′??
????……………
????PRIMARY KEY (`doc_id`)
????);

????????????

??????????5000W ?У????30G??

????36????

??????????????????????????

????????????????????????????????????????????????????

??????????????

??????????? ????????????????????????????

??????? ????????????????????????????д?????

????1??4????????????insert 5000W?????????д?????

??????36??slap????????????36???insert????????????5000W ???????

????2??4?????????????????20??select????select???????????????

??????36??slap???????????????20??????select???????36???????????

??????????????????г???SQL????????????

???????????????????SQL?????????????ЩSQL???????????slap???????????10??50??100??200??

??????????????????????SQL????????????

???????????????????SQL?????????????ЩSQL???????????slap???????????10??50??100??200??

?????????????????????????????????

???????????????slap?????????10??50??100??200??500??800??1000???????????????????????????￡?TPS???

?????壺?????????????????????????

????????????????????????????TPS??????TPS?????????????????????????jemeter???????????10??50??100??200??500??800??1000.???????????????????μ??????????????????????????????TPS?????????????

??????????????????????

?????????????????????е???????????CPU?????????????????????

????????????????????????????????????????????????????????????????????????????е?????????????????CPU???δ???????????????е?????????????????????????????????

????????????????????

??????????????????????????

???????裺??jmeter ????????24С???

?????ò?????е???????????TPS????????????β?????????????Jmeter????????24С????????????С???????С???TPS??????????????

????????????β????????У??漰??????????????????

?????塢???

?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????°?????