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

Source: Internet
Author: User
Tags cpu usage mysql index

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.