Free, open source database MySQL will run on a variety of platforms. Beginning MySQL Database Design and Optimization: From Novice to Professional covers MySQL version 4.1-5.0, This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics.
Chapter 6 -- Finding the bottlenecks -- of Beginning MySQL Database Design and Optimization: From Novice to Professional covers how to use and alter commands for reading system and configuration variables.
Chapter 6, "Finding the bottlenecks," is excerpted from Beginning MySQL Database Design and Optimization: From Novice to Professional by Chad Russell and Jon Stephens, published in October 2004, by Apress (ISBN:1-59059-332-4). Copyright © 2004, Apress. All rights reserved. Reprinted with permission by Apress.