has anybody used tpcc-mysql,where can i get it!
You can find it here https://launchpad.net/perconatools
The code is available through Launchpad and there is a brief README file that explains how to build and use the tool. It is quite simple to use. For large numbers of warehouses, you might want to consider using the parallel data loading utility included with the tool, because otherwise it can take a long time to generate the dataset.