MySQL super-smack is a great little benchmarking tool. Using it, you can generate a load on your MySQL server to highlight bottlenecks in your configuration or MySQL itself. Heck, one of these days maybe I'll provide a little tutorial about how I've used it.

The trouble is that it doesn't build out-of-the-box on FreeBSD (minor library conflicts). It works great on Linux. I managed to make it work about 1.5 years ago but never bothered with a patch. So, it is with much delay that I present super-smack-bsd.patch.gz

The usual disclaimers apply. It seems to work for me and may or may not work for you. I'm sending it to MySQL AB so they can better include it in the standard super-smack release.

Posted by jzawodn at April 16, 2003 06:09 PM

Reader Comments
# keith knutsson said:

thanks, mysql has been great and my site has been getting decent traffic... time for a benchmark

on April 17, 2003 07:53 AM
# Joseph Scott said:

So how well does mysql & freebsd take the beating?

According to the mysql site this tool can also be used to benchmark postgresql as well. Hmmmm, maybe I'll have to give that a try one of these days.

on April 17, 2003 11:29 AM
# BOK said:

Tiny note:
I had to give the path to "yacc" in the Makefile in manually in the Makefile on FreeBSD. "Configure" didn't discover it :-)
Also some little hackin' in th C-code for database-password and stuff.

on April 17, 2003 10:45 PM
# anon said:

I've been unable to get this to work under Redhat 9 - does anyone have any ideas?

on April 29, 2003 02:51 PM
# Jeremy Zawodny said:

Joseph:

It takes the beating quite well. :-)

on May 3, 2003 10:50 PM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, or previous employers are not responsible for what I write here, the comments left by others, or the photos I may share. If you have questions, please contact me. Also, I am not a journalist or reporter. Don't "pitch" me.

 

Privacy: I do not share or publish the email addresses or IP addresses of anyone posting a comment here without consent. However, I do reserve the right to remove comments that are spammy, off-topic, or otherwise unsuitable based on my comment policy. In a few cases, I may leave spammy comments but remove any URLs they contain.