Not the answer you need?
Register and ask your own question!

tpcc-mysql loading data is slow

sherzod.odinaevsherzod.odinaev EntrantInactive User Role Beginner
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?

Comments

  • sherzod.odinaevsherzod.odinaev Entrant Inactive User Role Beginner
    Or, would be grateful if somebody provided 1000W sample db, split in 24 parts for parallel dump :D
  • sherzod.odinaevsherzod.odinaev Entrant Inactive User Role Beginner
    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.
  • NikpraskatonNikpraskaton Entrant Inactive User Role Beginner
    Hi sherzod.odinaev,
    have you done some ploting with gnuplot? I would like to see graphic representation of my TPCC benchmark.

    Thanks
  • NikpraskatonNikpraskaton Entrant Inactive User Role Beginner
    Hy, can someone explain why is number of transaction falling over time? Why the graph don't produce linear line? Thanks
  • mixamixa Member Inactive User Role Beginner
    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 (http://www.percona.com/doc/percona-toolkit/2.2/pt-stalk.html) while this test is running and then analyze its data collected at the peak and drop moments.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.