1. And there are two main strategies for registration :① We are testing the whole system ( Integrated full-stack) ② Individual test mysql( But component benchmarks single-component)

2. Get system performance and status ( The data to be recorded include The state of the system and Performance indicators )

3. Testing tools

① Integration test tools : ab、http_load、JMeter

② Single component testing tools :mysqlslap、MYSQL Benchmark Suit(sql-bench)、Super Smack、Database Test Suit、

Percona's TPCC-MySQL Tool、sysbench

mysql More articles on Benchmarking

  1. Detailed explanation MySQL Benchmarking and sysbench Tools

    Preface As a background Developer , Benchmark the database , It is necessary to know the performance of the database . This paper introduces MySQL The basic concept of benchmarking , And the use of sysbench Yes MySQL Detailed methods for benchmarking . There are omissions in the article , ...

  2. Mysql The benchmark is explained in detail ( According to MOOCS :《 Make it bearable Mysql Database architecture 》 Real time recording of video courses )

    What is benchmarking Benchmarking is the activity of measuring and evaluating software performance indicators to establish a performance benchmark at a certain time , In order to re benchmark and evaluate the impact of changes on performance when the system hardware and software changes . We can think of it like this : Benchmarking is a part of the system setup ...

  3. 【mysql】mysql The benchmark

    Benchmark definition Benchmarking is actually a way to measure and evaluate software performance , Used to establish a performance benchmark at a point in time , So that when the hardware and software of the system change, the benchmark test will be conducted again to evaluate the impact of the change on the performance . So the measurement of system performance , To know our ...

  4. Detailed explanation MySQL Benchmarking and sysbench Tools ( turn )

    Preface As a background Developer , Benchmark the database , It is necessary to know the performance of the database . This paper introduces MySQL The basic concept of benchmarking , And the use of sysbench Yes MySQL Detailed methods for benchmarking . There are omissions in the article , ...

  5. MySQL The benchmark ( 3、 ... and )-- Open source tools and demonstration examples

    MySQL The benchmark ( 3、 ... and )-- Open source tools and demonstration examples in the light of web application ab ab It's a Apache HTTP Benchmarking tools for services . http_load http_load It's a response to Web Server testing tools . JM ...

  6. MySQL The benchmark ( Two )-- Method

    MySQL The benchmark ( Two )-- Method Purpose : The method is not as advanced as possible . You should be good at subtraction . Simplicity is a kind of wisdom , The first thing to do is to collect MySQL The status data of the system . Collected , No matter what happens in each period of time , At least you have the number of states for the first time ...

  7. MySQL The benchmark ( One )-- reason , Strategy , Ideas

    MySQL The benchmark ( One )-- reason , Strategy , Ideas Application benchmark Why Verify some of the problems you think , Benchmark and simulate data to verify . Solve some anomalies in the production system Test the current operation of the system , Through historical benchmarks ...

  8. mysql Benchmarking tools tpcc-mysql install 、 Use 、 Interpretation of results

    TPCC It's specifically for online transaction processing systems (OLTP System ) The specification of , In general, we also call this kind of system business processing system ,tpcc-mysql yes percona be based on TPC-C( The following is abbreviated as TPCC) Derivative products , Dedicated to My ...

  9. Explain MySQL Benchmarking and sysbench Tools

    Preface As a background Developer , Benchmark the database , It is necessary to know the performance of the database . This paper introduces MySQL The basic concept of benchmarking , And the use of sysbench Yes MySQL Detailed methods for benchmarking . There are omissions in the article , ...

  10. MySQL The benchmark

    This is a < High performance MySQL( The third edition )> Reading notes of Chapter 2 . The benchmark (benchmark) It's a stress test for the system , It is used to master the behavior of the system or to reconstruct a state of the system .sysbench It is commonly used. MySQL The base ...

Random recommendation

  1. supermpa Configuration problems

    Environmental Science vs2010  supermap idesktop7.1.2  iobject7.1.2.net windowform problem In the installation iobject7.1.2 64 When a stay vs The toolbox in is not shown s ...

  2. Sass And Web Functions related to componentization

    Sass https://en.wikipedia.org/wiki/Sass_(stylesheet_language) Sass (Syntactically Awesome Stylesheet ...

  3. js Bubble sort and binary search

    Bubble sort var attr=[1,5,7,6,3,9,2,8,4]; var zj=0; // Control the number of comparison rounds for(var i=0;i<attr.length-1;i++) { // Control the ratio of each round ...

  4. JSON And SuperObject(6): Method

    SuperObject Of JSON Objects can also contain " Method ", This is so interesting ; The format of the method is : procedure Method(const This, Params: IS ...

  5. Fedora Next install chrome

    One . Download installation package , install 1. Go to google Download installation package 2. Under the terminal     Run the command :    rpm -ivh google-chrome-stable_current_i386.rpm 3.   Appear as follows ...

  6. java be based on xml General configuration excel Single table data import component ( 3、 ... and 、 The class responsible for data conversion processing )

    package xxxxxxx.manage.importexcel; import java.util.Map; import java.util.logging.Logger; import xx ...

  7. Device dependent bitmaps (DDB) ,CreateCompatibleBitmap usage

    DDB(Device-dependent bitmap) Depending on the device , This is mainly reflected in the following two aspects : DDB The color mode of must be consistent with the output device . for example , If the current display device is 256 Color mode , that DDB It must be 25 ...

  8. [ Brush problem ]Google Code Jam 2017 - Round1 C Problem A. Ample Syrup

    https://code.google.com/codejam/contest/3274486/dashboard Problem The kitchen at the Infinite House ...

  9. https The connector

    Asymmetric encryption :A Generate a public and private key , Give the public key to someone who needs to transfer data B,B When sending data, encrypt the data with the public key first , And send it to A, Again by A Decrypt with private key . But there is a loophole, that is B How to confirm the public key is determined by A Provided . So we need a third party machine ...

  10. windwos::mutex

    The way and mechanism of thread synchronization A critical region . Mutual exclusion zone . event . Four ways of semaphore A critical region (Critical Section). The mutex (Mutex). Semaphore (Semaphore). event (Event) The difference between 1. A critical region : Through to ...