Friday, August 5, 2011

notes on mysql while reading ... (2)

High Performance MySQL

Finding Bottlenecks: Benchmarking and Profiling
A benchmark measures your system’s performance. In contrast, profiling helps you find where your application spends the most time or consumes the most resources.

*) http_load - windows port: http://www.orenosv.com/misc/
*) MySQL’s BENCHMARK( ) - SET @input := 'hello world'; SELECT BENCHMARK(1000000, MD5(@input)); (an exec var to avoid cache hits)
*) SysBench -

No comments:

Post a Comment