Here is the list of MySQL benchmarking tools that were discussed during the "Benchmarking tools" session today.

• mysqlslap (5.1 onwards)
• sql-bench
• supersmack
• ApacheBench
• MySQL benchmark() function
• mybench
• …

Day two of the conference was a little disappointing, as far as sessions went. There were several time blocks where I simply wasn’t interested in any of the sessions. Instead, I went to the expo hall and tried to pry straight answers out of sly salespeople. Here’s what I attended. Paying It Forward: Harnessing the MySQL Contributory Resources This was a talk focused on how MySQL has made it possible for community members to contribute to MySQL.

• Tom Hanlon of MySQL presents
• Benchmarking tools
  • mysqlslap (with MySQL 5.1)
  • sql-bench
  • supersmack - Jeremy Zawodny's tool
  • Apache Bench (combined with some sample PHP scripts)
  • MySQL's benchmark() function
  • …

The slides for the Users Conference talk about MySQL Sandbox are now published online.

http://datacharmer.org/downloads/Sandbox_uc2008.pdf

Thanks to all attendees and to Sheeri and Keith for blogging live during the session!

Unfortunately I didn't find any available seats to take notes for this but this morning a very interesting keynote took place. Representatives from 7 large companies mentioned in the title gathered on stage and answered various questions by MySQL's Kaj Arno.

These questions included things like "how many MySQL servers do you have", "how many DBAs", etc. It was a lot of fun, hopefully someone (Sheeri) will edit and post the video soon.

Keith has a nice summary of everything that went on together with the numbers here.

Update: Venu has even better notes here.

Similar Posts:

• Must-Know People In The MySQL Field …

For those proprietary database vendors who have been hoping and praying that their myths about MySQL would persist ("For low-end applications, "Not high performance," etc.) , Kickfire just announced a MySQL-based database appliance that should wipe the smirks off Oracle and IBM.

If you get nothing else from this post, remember this: Big performance. Little price.

Kickfire, Inc. today announced the first MySQL database appliance that brings the high-performance capabilities of large commercial database systems to the MySQL market. The company...has built its appliance by developing an ultra-modern database kernel and a revolutionary SQL chip that packs the power of 10s of high-end CPUs. The result is a small form-factor MySQL appliance that delivers the high performance of large systems but with …

This week is the annual MySQL Conference & Expo in Santa Clara and I'm happy to report that we have hit record numbers with more exhibitors (over 50) and more attendees (over 2,000) than ever before. Monday was primarily tutorials as well as our Customer Advisory Board and partner meetings. Those are great sessions as we get tons of input from bleeding edge customers including some of the world's largest web sites, retailers, telecommunications customers and software ISVs and OEMs who embed MySQL. It's a "no BS zone" in that we have product management and lots of developers there to... READ MORE

I prefer to install mySQL using the pre-compiled binaries. Depending on the environment, these usually go in either /opt or /usr/local. When you choose this type of install, chances are you are going to need to ensure that you somehow configure your system so that the mysql binaries end up in your PATH. If you are [...]

• Paul McCullagh presents
• BLOB
  • invented by Jim Starkey
  • Basic Large OBject
  • Binary Large OBject
  • photos, films, mp4 files, pdfs, etc
• how MySQL handles BLOBs
  • mysql client send buffer -> receive buffer on the server (max_allowed_packet)
  • streaming a BLOB
    • continuous data stream
    • stream BLOB data directly in and out of the database
    • store BLOBs of any size (>4GB) in the database
    • create a scalable back-end that can handle any throughput and storage requirements. Wouldn't need to know in advance how big the database will get
    • provide an open system that can be used by all engines
    • provide extensions for …

Architecture of Maria: A New Storage Engine with a Transactional Design

Goals of Maria:

• 
  
• ACID compliant
  
• MVCC, transactional
  
• default non-transactional and default transactional storage engine for MySQL
  
• MyISAM replacement, including temporary table use
  
• Storage engine good for data warehousing.
  
• Allow any length transactions to take place
  
• all indexes should have equal speed (clustered indexes are not in the plan)
  
• log shipping — incremental backups just by copying the logs
  
• used as a standalone library
  
• fast count(*)
  
• allow copying of Maria tables between different Maria servers
  
• Better blob handling (than MyISAM) — no memory copying, or extra memory used for blobs on INSERT/UPDATE
  
…