tps - transactions per second（每秒传输的事物处理个数），这是指服务器每秒处理的事务数，支持事务的存储引擎如innodb等特有的一个性能指标。
计算方法：
tps = (com_commit + com_rollback)/uptime
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
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;