Mark, I tried with LDFLAGS="-ltcmalloc_minimal", it showed good result, I will post eventually about it.
Replacing internall InnoDB allocation to malloc and using tcmalloc did not show good results for me. I am thinking to make percona builds linked with tcmalloc_minimal. MARK CALLAGHAN wrote: > I ran sysbench with my changes to make it use predicates on a > secondary index for half of the queries. Vadim has the diff for the > changes to sysbench. > > I used: > * 8 core server > * CPU bound workload > * 1,2,4,8,16 concurrent sessions > * Xtradb 5.0.75 build 12 compiled from source -- > http://www.mysqlperformanceblog.com/2009/01/23/5075-build12-percona-binaries/ > * with and without tcmalloc > * throughput is value reported as 'transactions:' > * sysbench binary runs on same host as db server > * sysbench command line is: (--oltp-secondary-index is new with my patch) > --test=oltp --oltp-read-only --oltp-table-size=2000000 > --max-time=120 --max-requests=0 --mysql-table-engine=innodb \ > --db-ps-mode=disable --mysql-engine-trx=yes --oltp-secondary-index > > Results: > > throughput for 1 2 4 8 16 concurrent sessions > without-tcmalloc 220 413 718 461 397 > with-tcmalloc 223 439 744 780 759 > > Observations: > The only thing needed to make CPU-bound sysbench readonly fast is > tcmalloc. MySQL performance doesn't change much with Percona or Google > patches compared to the original code. This may change when the > bottlenecks above InnoDB (LOCK_open) are removed and when run on a > larger box. > > --- > Mark Callaghan > [email protected] > > _______________________________________________ > Mailing list: https://launchpad.net/~percona-discussion > Post to : [email protected] > Unsubscribe : https://launchpad.net/~percona-discussion > More help : https://help.launchpad.net/ListHelp > -- Vadim Tkachenko, CTO Percona Inc. ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403 MySQL Performance Blog - http://www.mysqlperformanceblog.com MySQL Consulting http://www.percona.com/ Attend the 2009 Percona Performance Conference April 22-23 - http://conferences.percona.com/ _______________________________________________ Mailing list: https://launchpad.net/~percona-discussion Post to : [email protected] Unsubscribe : https://launchpad.net/~percona-discussion More help : https://help.launchpad.net/ListHelp
