# tpcc-mysql loading data is slow
**URL:** https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753
**Category:** Other MySQL® Questions
**Created:** [June 12, 2013, 10:19am UTC](https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753 "2013-06-12T10:19:53Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@sherzod.odinaev](https://forums.percona.com/u/sherzod.odinaev)
#### Post date: [June 12, 2013, 10:19am UTC](https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753/1 "2013-06-12T10:19:53Z")
Hi,
I’m trying to setup tpcc-mysql to benchmark a server. Running ./tpcc\_load but it’s very slow…ran in parallel, still slow. Is there anything I’m not doing right.
Commands are being run from a VM with 5G mem and 4 cpus, nothing else is running on that VM. The server in question is a HP G8 server, also idle. Any thoughts?
---
### Author:  [@sherzod.odinaev](https://forums.percona.com/u/sherzod.odinaev)
#### Post date: [June 12, 2013, 10:41am UTC](https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753/2 "2013-06-12T10:41:49Z")
Or, would be grateful if somebody provided 1000W sample db, split in 24 parts for parallel dump 😃
---
### Author:  [@sherzod.odinaev](https://forums.percona.com/u/sherzod.odinaev)
#### Post date: [June 13, 2013, 9:16am UTC](https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753/3 "2013-06-13T09:16:56Z")
Sorry to waste your attention. I skipped to mention that two servers were on different networks, and bandwidth was limited. I moved the tpcc\_load onto same network as G8, and load rate increased significantly. I’m populating 1000W, if anyone wants sample data, let me know.
---
### Author:  [@Nikpraskaton](https://forums.percona.com/u/Nikpraskaton)
#### Post date: [June 13, 2013, 6:39pm UTC](https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753/4 "2013-06-13T18:39:39Z")
Hi [sherzod.odinaev](http://www.percona.com/forums/member/20910-sherzod-odinaev),
have you done some ploting with gnuplot? I would like to see graphic representation of my TPCC benchmark.
Thanks
---
### Author:  [@Nikpraskaton](https://forums.percona.com/u/Nikpraskaton)
#### Post date: [June 26, 2013, 2:38pm UTC](https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753/5 "2013-06-26T14:38:06Z")
Hy, can someone explain why is number of transaction falling over time? Why the graph don’t produce linear line? Thanks
---
### Author:  [@mixa](https://forums.percona.com/u/mixa)
#### Post date: [December 25, 2013, 1:17pm UTC](https://forums.percona.com/t/tpcc-mysql-loading-data-is-slow/2753/6 "2013-12-25T13:17:50Z")
It’s hard to tell why there is behavior like this.
Possible causes are: cold/hot cache, size of transactions, innodb checkpoints, other server activity…
The picture clearly shows us that peak values are regular.
To be able to answer exactly what’s going on here - I would run pt-stalk ([url][http://www.percona.com/doc/percona-toolkit/2.2/pt-stalk.html[/url]](http://www.percona.com/doc/percona-toolkit/2.2/pt-stalk.html%5B/url%5D)) while this test is running and then analyze its data collected at the peak and drop moments.