OurSQL Episode 81: From the Tool Bench

This week we present the how's and why's of benchmarking MySQL.

News/Feedback:
MySQL Cluster 7.2 can do one billion queries per minute, what does that actually mean?

Percona's XtraDB cluster announcement
XtraDB Cluster at the San Francisco MySQL Meetup on Wednesday, March 21st
XtraDB Webinar on Wednesday April 4th

High Performance MySQL, 3rd edition

Percona's web-based query advisor

Oracle is setting up another round of Tech Tours. Tech tours are free, in-depth technical seminars. They are scheduled for:
Colorodo Springs, CO on Monday, March 12th.
San Diego, CA on Wednesday, March 14th.
Burlington, MA also on Wednesday, March 14th
Phoenix, AZ on Friday, March 16th
Reston, VA on Tuesday, March 20th.

Finally, Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd

The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule.

SkySQL and MariaDB Solutions Day, Friday April 13th, in Santa Clara, CA.

Drizzle Day, Friday April 13th in Santa Clara, CA.

Collaborate, the technology and applications forum for the Oracle Community, has 18 MySQL sessions. Collaborate runs from Sunday, April 22nd through Thursday, April 26th, 2012 at the Mandalay Bay Hotel and Casino in Las Vegas Nevada.

LinuxFest Northwest will be happening on Saturday April 28th and Sunday April 29th.

The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies will be held in Buenos Aires Wednesday, June 27th through Friday, June 29th at the Puerto Madero Hilton Hotel. It is called the MariaDB NoSQL & Cloud Latin American Conference and we will link to information in the show notes.

Benchmarking
Wikipedia's definition of benchmarking.

Mark Callaghan of Facebook has a good article on a benchmark he ran a few years ago, getting 90 different data points.

Gerry's article about benchmarks, using sysbench

Giuseppe Maxia's article about MySQL 5.x logging overhead

Benchmarking tools
BENCHMARK() MySQL function
mysqlslap, a load emulation client for MySQL Server
Sysbench, benchmarking for I/O, threads, scheduler, memory, and database performance
pt-log-player

Ear Candy
This week's ear candy is custom locking with MySQL using the functions GET LOCK, RELEASE LOCK, IS USED LOCK and IS FREE LOCK.

At the Movies
This week in at the movies we present 'How to Stop Hating MySQL' - Fixing common mistakes and myths

Where you can see us
Gerry will be at the March Seattle MySQL User Group on Monday March 5th from 7 - 9 pm. Rich Kelm will be answering the age old question of 'When to adopt a Sphinx (for Search)'.

Sheeri will be at the March Boston MySQL User Group on Monday March 12th from 7 - 9 pm. The meetup topic is about VoltDB, a column-based data store.

Sheeri will be delivering a tutorial on White-hat Google Hacking and MySQL Security at Percona Live: MySQL Conference and Expo from April 10-12th, 2012 in Santa Clara, CA.

Sheeri will also be speaking at the SkySQL and MariaDB Solutions Day on Friday, April 13th, 2012 in Santa Clara, CA, giving a session on creating a data warehouse.

Sheeri will be speaking about MySQL Security at the Professional IT Community Conference, Friday May 11 - Saturday May 12 in New Brunswick, NJ

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast