QPS -(Queries Per Second) 及数据库的每秒查询处理量,同时适用InnoDB
TPS -(Transactions Per Second) 及数据库的每秒传输的事物处理个数,主要是对事务性存储引擎(InnoDB)的一个性能指标。
TPS -(Transactions Per Second) 及数据库的每秒传输的事物处理个数,主要是对事务性存储引擎(InnoDB)的一个性能指标。
计算方法:
TPS = (COM_COMMIT + COM_ROLLBACK)/UPTIME
SQL语句:
USE information_schema;
SELECT VARIABLE_VALUE INTO @com_commit FROM GLOBAL_STATUS WHERE VARIABLE_NAME =’COM_COMMIT’;
SELECT VARIABLE_VALUE INTO @com_rollback FROM GLOBAL_STATUS WHERE VARIABLE_NAME =’COM_ROLLBACK’;
SELECT VARIABLE_VALUE INTO @uptime FROM GLOBAL_STATUS WHERE VARIABLE_NAME =’UPTIME’;
SELECT (@com_commit+@com_rollback)/@uptime;
QPS -(Queries Per Second) 及数据库的每秒查询处理量,同时适用InnoDB和MyISAM 等存储引擎。
计算方法:
QPS=QUESTIONS/UPTIME
sql语句:
USE information_schema;
SELECT VARIABLE_VALUE INTO @questions FROM GLOBAL_STATUS WHERE VARIABLE_NAME =’QUESTIONS’;
SELECT VARIABLE_VALUE INTO @uptime FROM GLOBAL_STATUS WHERE VARIABLE_NAME =’UPTIME’;
SELECT @questions/@uptime;