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

Help with TPCC and MySQL

NikpraskatonNikpraskaton EntrantInactive User Role Beginner
Hy,
I have to do a tpcc benchmark with MySQL on my PC :)
I saw that on this link http://bazaar.launchpad.net/~percona...w/head:/README
I have everything that i need but I don't know how to run it.

First of all, I have istalled XAMPP on my windows 7.
Readme file is saying that I have to build binaries from src folder, right?
Where do I have to compile them? In foledre where is mysql on xampp folder?
Can someone give me some directions?

Thanks

all i had to do was install MySQL server on Ubuntu and run makeFile :)
Next thing I would like to do is to see graphic representation of TPCC benchmark. How can I do this with gnuplot?

Thanks

Comments

  • mixamixa Member Inactive User Role Beginner
    Nikpraskaton,

    I tried on my laptop an saved all steps.

    This is step by step summary:

    ### I do everything in homedir assuming that tpcc-mysql installed and located on ~/tpcc-mysql/ and gnuplot installed too

    cd ~/tpcc-mysql/

    ### create db
    mysql -u root -p -e "CREATE DATABASE tpcc1000;"
    mysql -u root -p tpcc1000 < create_table.sql
    mysql -u root -p tpcc1000 < add_fkey_idx.sql

    ### run tpcc, save output
    ./tpcc_load 127.0.0.1 tpcc1000 root "<root-password>" 3
    ./tpcc_start -h127.0.0.1 -dtpcc1000 -uroot -p<root-password> -w3 -c8 -r5 -l180 > ~/tpcc-output.log

    ### generate datafile
    cd ~/
    ./tpcc-output-analyze.sh ~/tpcc-output.log > tpcc-data.txt

    ### generate graph
    ./tpcc-graph-build.sh tpcc-data.txt

    ==================================================

    file: tpcc-output-analyze (I got it here http://bazaar.launchpad.net/~percona...pts/analyze.sh and modified a bit)

    TIMESLOT=1

    if [ -n "$2" ]
    then
    TIMESLOT=$2
    echo "Defined $2"
    fi

    cat $1 | grep -v HY000 | grep -v payment | grep -v neword | awk -v timeslot=$TIMESLOT ' BEGIN { FS="[,():]"; s=0; cntr=0; aggr=0 } /MEASURING START/ { s=1} /STOPPING THREADS/ {s=0} /0/ { if (s==1) { cntr++; aggr+=$2; } if ( cntr==timeslot ) { printf ("%d %3d\n",$1,(aggr/'$TIMESLOT')) ; cntr=0; aggr=0 } } '

    ==================================================

    file: tpcc-graph-build.sh

    #!/bin/bash

    ### goto user homedir and remove previous file
    cd ~/
    rm -f tpcc-graph.jpg

    gnuplot << EOP

    ### set data source file
    datafile = "tpcc-data.txt"

    ### set graph type and size
    set terminal jpeg size 640,480

    set grid x y
    set xlabel "Time (sec)"
    set ylabel "Transactions"
    set output "tpcc-graph.jpg"

    ### build graph
    # plot datafile with lines
    plot datafile title "TpmC" with lines

    EOP

    ==================================================

    graph is saved to tpcc-graph.jpg file
  • mixamixa Member Inactive User Role Beginner
    Generated file
  • yogesh777yogesh777 Contributor Current User Role Beginner
    Thanks for detailed explanation. I followed all the steps and able to install and run the benchmarking test.
    I was using sysbench for a long time so i thought results would be same as sysbench like qps or tps over number of threads/connections.
    How will i get the same results here in tpcc-mysql.
    i want tps or qps on number of threads, can any body guide me?
    also how can we get read and read/write test separately in tpcc-mysql?
  • ntlinhntlinh Entrant Current User Role Beginner
    Hi Mixa,

    On this file http://bazaar.launchpad.net/~percona...w/head:/README, I try at the first step with "make" command, but it didn't work. It seems I didn't configure the mysql_configure file. But I don't know how to configure it in the $PATH.
    Could you show me, please?

    Many thanks.
  • ntlinhntlinh Entrant Current User Role Beginner
    Dear Nikpraskaton,

    Thank you

    I install "libmysqlclient15-dev" and it works now.
    But I can not generate datafile like tutorial:

    ### generate datafile
    cd ~/
    ./tpcc-output-analyze.sh ~/tpcc-output.log > tpcc-data.txt

    ### generate graph
    ./tpcc-graph-build.sh tpcc-data.txt


    I didn't find tpcc-output-analyze.sh file in ~/

    Could you help me?
  • NikpraskatonNikpraskaton Entrant Inactive User Role Beginner
    Look at mixa's post, there is tpcc-output-analyze written in code.
    You have to open text editor (eg. gedit) and copy paste mixa's code.
    Copy and paste this code:


    TIMESLOT=1

    if [ -n "$2" ]
    then
    TIMESLOT=$2
    echo "Defined $2"
    fi

    cat $1 | grep -v HY000 | grep -v payment | grep -v neword | awk -v timeslot=$TIMESLOT ' BEGIN { FS="[,():]"; s=0; cntr=0; aggr=0 } /MEASURING START/ { s=1} /STOPPING THREADS/ {s=0} /0/ { if (s==1) { cntr++; aggr+=$2; } if ( cntr==timeslot ) { printf ("%d %3d\n",$1,(aggr/'$TIMESLOT')) ; cntr=0; aggr=0 } } '

    in tex editor and name it tpcc-output-analyze.sh.
    Read once again mixa's second post. There is code for tpcc-graph-build.sh.
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.