3

MySQL Conference Liveblogging: Benchmarking Tools (Wednesday 4:25PM)


Posted by Artem Russakovskii on April 16th, 2008 in Databases

  • Tom Hanlon of MySQL presents
  • Benchmarking tools
  • sql-bench
    • pros
      • ubiquitous
      • long history of use
    • cons
      • single thread
      • Perl
      • not always real-life test cases (create 10k tables?)
    • list of tests follows
  • supersmack
    • configurable, flexible

  • Robert Hodges from Continuent presents
  • About Continuent
  • leading provider of open source database availability and scaling solutions
  • solutions
    • uni/cluster – multi-master database clustering that replicates data across multiple databases and load balances reads
    • uses "database virtualization"
  • scale-out design motivation
    • protection from db and site failures
    • continuous operation during upgrades
  • how come not everyone has it already?
  • creating identical replicas across different hosts is
  • 7

    sysbench – Linux Test Bench


    Posted by Artem Russakovskii on October 12th, 2007 in Databases, Linux

    Updated: July 23rd, 2008

    sysbench – Linux test bench. Easy as pie to test CPU, memory, threads, mysql, and disk performance.

    Full description is available here: http://sysbench.sourceforge.net/docs/

    install mysql, mysql-devel
    wget http://superb-west.dl.sourceforge.net/sourceforge/sysbench/sysbench-0.4.8.tar.gz
    tar xvzf sysbench*gz
    cd sysbench*
    ./configure && make install

    mysql tests

    This will run 10 separate consecutive mysql tests using an InnoDB table type, each with 100 mysql threads, doing a total of 1000 various SQL operations…