GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

tpcc-mysql loading data is slow

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • tpcc-mysql loading data is slow

    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?

  • #2
    Or, would be grateful if somebody provided 1000W sample db, split in 24 parts for parallel dump

    Comment


    • #3
      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.

      Comment


      • #4
        Hi sherzod.odinaev,
        have you done some ploting with gnuplot? I would like to see graphic representation of my TPCC benchmark.

        Thanks

        Comment


        • #5
          Nikpraskaton,

          You can read about gnuplot here in my post

          Comment


          • Nikpraskaton
            Nikpraskaton commented
            Editing a comment
            Thanks again.

        • #6
          Hy, can someone explain why is number of transaction falling over time? Why the graph don't produce linear line? Thanks

          Comment


          • #7
            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-t.../pt-stalk.html) while this test is running and then analyze its data collected at the peak and drop moments.

            Comment

            Working...
            X