Charles Engelke's Blog

July 13, 2003

OSCON Day 5: Session – Benchmarking MySQL Queries

Filed under: Ozette Brown — Charles Engelke @ 6:19 pm

Why Benchmark?

  • what’s going to break
  • where will it break
  • does the server scale gracefully
  • monitor the system

    Compare alternative implementations

  • queries
  • indexes, table types
  • application logic

    Test server hardware configuration

  • should you add more RAM or disks
  • is Raid 10 faster than Raid 5
  • will dual CPU’s help

    Useful Tools

  • MySQL-Bench
  • super-smack
  • mybench

    URLS

  • http://advanced-mysql.com/super-smack/
  • http://advanced-mysql.com/mybench/

    My Comments

  • Jeremy Zawodny has a book coming out by O’reilly called “Advanced MySQL”. This will be a must have.
    Advertisements
  • Blog at WordPress.com.

    %d bloggers like this: