In one of my previous articles I have written about tools that I use for benchmarking database performance and especially for discovering system bottlenecks. In this article I will show you how large impact on filesystem performance a drive write cache may have.
HP DL360 G4 server
HP and its line of DL servers is very respected [...]
HP DL380 G5 drive write cache (BBWC)
June 19th, 2009 by Boštjan ŠkufcaMySQL sql-bench results
June 16th, 2009 by Boštjan ŠkufcaThis is a follow-up article to the MySQL Super Smack benchmark results. Results from sql-bench benchmark suite can easily pinpoint some of the potential system bottlenecks. I find it especially useful for discovering filesystem performance or – better – slowness.
Results
Total execution time is: 562 seconds
# run-all-tests
alter-table: Total time: 8 wallclock secs ( 0.02 usr [...]
MySQL Super Smack database benchmark results
June 16th, 2009 by Boštjan ŠkufcaAfter a couple of years away in academic environment, I got myself back into the business of system administration (or as I prefer to call it, system engineering), Linux/BSD system administration to be precise. Of course, all the old (and precious) notes and data were gone, so I had to start from scratch. I was [...]