TCMalloc 对MYSQL 性能 优化的分析(二)

2015-11-21 01:32:39 · 作者: · 浏览: 7
centile:???? 56.25ms

????????????????????????????????使用TCMalloc

OLTP test statistics:?
??? queries performed:?
??????? read:??????????????????????????? 140084?
??????? write:?????????????????????????? 50017?
??????? other:?????????????????????????? 20006?
??????? total:?????????????????????????? 210107?
??? transactions:??????????????????????? 10000? (862.83 per sec.)?
??? deadlocks:?????????????????????????? 6????? (0.52 per sec.)?
??? read/write requests:???????????????? 190101 (16402.39 per sec.)?
??? other operations:??????????????????? 20006? (1726.17 per sec.)

Test execution summary:?
????total time:????????????????????????? 11.5898s?
??? total number of events:????????????? 10000?
??? total time taken by event execution: 185.2397?
??? per-request statistics:?
???????? min:????????????????????????????????? 2.81ms?
???????? avg:???????????????????????????????? 18.52ms?
???????? max:??????????????????????????????? 430.03ms?
???????? approx.? 95 percentile:????????????? 36.49ms

?
?
可以看到使用TCMalloc性能明显优于未使用,这里主要原因是mysql是多线程小内存分配,TCMalloc由于每个线程均有线程缓冲区,所以对这样的小对象分配无竞争,效率非常好,可以看到TCMalloc对MYSQL优化效果不错 ,建议使用。