|
TOP
|
|
TCMalloc 对MYSQL 性能 优化的分析(二)
|
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优化效果不错 ，建议使用。
|