Software Performance Testing Technology Tree (III)----Database (MySQL) performance

Full Picture:

MySQL Key monitoring indicators:

MySQL Main branch:

Database Schema Design:

MySQL Slow query:

SQL statement Analysis and tuning:

MySQL index:

MySQL Storage engine:

MySQL Real-time monitoring:

MySQL Cluster monitoring tool:

JMeter developing MySQL performance test script:

The following from the Baidu Encyclopedia----software Performance test

Throughput I defined the throughput as "the number of customer requests handled per unit of time", directly reflecting the performance carrying capacity of the software system, for the interactive application system, the throughput reflects the pressure of the server, in the capacity planning test, throughput is an important indicator, it is not only reflected in the middleware, the database And more on the hardware. We use this indicator in the following areas: (1) to assist in the design of software performance testing scenarios, to measure whether the software performance test has achieved the expected design goals, such as the connection pool of the Java EE Application System, the frequency of database transactions, and the number of transactions occurring. (2) To assist in the analysis of performance bottlenecks, referring to the second part of the overall RBI method. Performance counter performance counters some data metrics that describe the performance of a server or operating system, such as the number of memory used for Windows, CPU usage, process time, and so on, are common counters. [Page] For performance counters this metric, you need to take into account not only hardware counters, Web server counters, WebLogic server counters, servlet performance counters, EJB2 performance counters, JSF performance counters, JMS performance counters. Finding these metrics is the first step in using performance counters, and the key is to find performance bottlenecks, determine system thresholds, and provide optimization recommendations that are key to performance counter usage. Performance counters are complex and diverse, and are closely related to the code context, system configuration, System architecture, development methods, specification implementations used, tools, and library versions.

Software Performance Testing Technology Tree (III)----Database (MySQL) performance