Home arrow MySQL arrow Page 4 - MySQL Benchmarking Tools and Utilities

Taking a Break - MySQL

You are reading the second segment of the four-part article series covering MySQL benchmarking concepts and strategies, benchmarking tools and utilities, and the most common query optimizations, design of optimal schemas, and server tuning tips. In this part we will present some of the popular benchmarking and monitoring tools and utilities. By the end of this article, youíll know how to use and work with each of them.

TABLE OF CONTENTS:
  1. MySQL Benchmarking Tools and Utilities
  2. Benchmarking Tools: sql-bench and Super Smack
  3. Benchmarking Tools: SysBench and the Rest
  4. Taking a Break
By: Barzan "Tony" Antal
Rating: starstarstarstarstar / 5
November 11, 2008

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Throughout this article we presented a variety of benchmarking utilities and monitoring tools, many but not all of which are MySQL-specific. The main guideline that you should follow each time you plan to benchmark is stated below.

First of all, create the test schema. Write the data generator and code the required scripts to accomplish this task. You may use already-existing entries to simulate a real-world scenario, or use a percentage of your entire database, or simply use randomly generated data as well. Itís up to you.

After the benchmarking source data is done, you need to grab the tools you are going to use. Research their usage, command line arguments and parameters, read their manuals and documentation, and learn how to use them. After this step, you should be able to execute the benchmarking tool(s) on the test data you have created.

Benchmarking is a critical part of optimizing and tuning, because it shows you a numerical representation of performance. But donít forget the influencing factors weíve covered in the first segment; always restart the server to eliminate caching artifacts, do more than a few iterative tests (5+), and then calculate the average. Usually, it is helpful to benchmark using an idle system rather than your active server. 

In the upcoming two parts we are going to cover query optimizations and other server tuning tips and strategies. By the end of this series, preparation (benchmarking) will meet opportunity (after each tweak applied, variable changed, etc.). Thatís when youíll get the most out of the things we have learned in these two articles.

As a closure, Iíd like to invite you to join our experienced community of technology professionals on all areas of IT&C starting from software and hardware up to consumer electronics at Dev Hardware Forums. As well as, be sure to check out the community of our sister site at Dev Shed Forums. We are friendly and weíll do our best to help you.



 
 
>>> More MySQL Articles          >>> More By Barzan "Tony" Antal
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: