如何测试mysql性能

sudo apt-get install sysbench  # 对于Debian/Ubuntu系统

sudo yum install sysbench      # 对于CentOS/RHEL系统

CREATE DATABASE sbtest;
USE sbtest;

CREATE TABLE t1 (
    id INT(11) NOT NULL AUTO_INCREMENT,
    c1 INT(11) DEFAULT NULL,
    PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

DELIMITER //
CREATE PROCEDURE prepare_data()
BEGIN
    DECLARE i INT DEFAULT 0;
    WHILE i < 100000 DO
        INSERT INTO t1(c1) VALUES(i);
        SET i = i + 1;
    END WHILE;
END //
DELIMITER ;

CALL prepare_data();

sysbench --threads=4 --time=60 --report-interval=10 \
    --mysql-host=localhost --mysql-port=3306 \
    --mysql-user=root --mysql-password=your_password \
    --mysql-db=sbtest \
    --tables=1 --table-size=100000 \
    oltp_read_write --db-driver=mysql prepare
sysbench --threads=4 --time=60 --report-interval=10 \
    --mysql-host=localhost --mysql-port=3306 \
    --mysql-user=root --mysql-password=your_password \
    --mysql-db=sbtest \
    --tables=1 --table-size=100000 \
    oltp_read_write --db-driver=mysql run