MySQL的TPS和QPS 计算方式

Post author:xfxia
Post published:2023年10月9日
Post category:mysql

TPS – Transactions Per Second（每秒传输的事物处理个数），这是指服务器每秒处理的事务数，支持事务的存储引擎如InnoDB等特有的一个性能指标。

计算方法：

TPS = (COM_COMMIT + COM_ROLLBACK)/UPTIME

       [sql]

       view plain

       copy

        use information_schema;

        select

        VARIABLE_VALUE

        into

        @num_com

        from

        GLOBAL_STATUS

        where

        VARIABLE_NAME =

        ‘COM_COMMIT’

        ;

        select

        VARIABLE_VALUE

        into

        @num_roll

        from

        GLOBAL_STATUS

        where

        VARIABLE_NAME =

        ‘COM_ROLLBACK’

        ;

        select

        VARIABLE_VALUE

        into

        @uptime

        from

        GLOBAL_STATUS

        where

        VARIABLE_NAME =

        ‘UPTIME’

        ;

        select

        (@num_com+@num_roll)/@uptime;

QPS – Queries Per Second（每秒查询处理量）同时适用与InnoDB和MyISAM 引擎

计算方法：

QPS=QUESTIONS/UPTIME

       [sql]

       view plain

       copy

        use information_schema;

        select

        VARIABLE_VALUE

        into

        @num_queries

        from

        GLOBAL_STATUS

        where

        VARIABLE_NAME =

        ‘QUESTIONS’

        ;

        select

        VARIABLE_VALUE

        into

        @uptime

        from

        GLOBAL_STATUS

        where

        VARIABLE_NAME =

        ‘UPTIME’

        ;

        select

        @num_queries/@uptime;

原文链接：https://blog.csdn.net/isoleo/article/details/52937793

Tags: mysql

你可能也喜欢