QPS:每秒的查詢數

TPS:每秒的事物量

QPS的計算方法

Questions = SHOW GLOBAL STATUS LIKE 'Questions';

Uptime = SHOW GLOBAL STATUS LIKE 'Uptime';

QPS=Questions/Uptime

例如:

mysql> show global status like 'questions';

+---------------+-----------+

| Variable_name | Value     |

+---------------+-----------+

| Questions     | 449106827 |

+---------------+-----------+

1 row in set (0.00 sec)

mysql> show global status like 'uptime';

+---------------+--------+

| Variable_name | Value  |

+---------------+--------+

| Uptime        | 238722 |

+---------------+--------+

1 row in set (0.00 sec)

mysql> select 449106827/238722 as 'QPS VALUE' from dual;

+-----------+

| QPS VALUE |

+-----------+

| 1881.2963 |

+-----------+

1 row in set (0.00 sec)

___________________________________________________________

TPS的計算方法

Com_commit = SHOW GLOBAL STATUS LIKE 'Com_commit';

Com_rollback = SHOW GLOBAL STATUS LIKE 'Com_rollback';

Uptime = SHOW GLOBAL STATUS LIKE 'Uptime';

TPS=(Com_commit + Com_rollback)/Uptime

例如:

mysql> SHOW GLOBAL STATUS LIKE 'Com_commit';

+---------------+----------+

| Variable_name | Value    |

+---------------+----------+

| Com_commit    | 71050554 |

+---------------+----------+

1 row in set (0.00 sec)

mysql> SHOW GLOBAL STATUS LIKE 'Com_rollback';

+---------------+--------+

| Variable_name | Value  |

+---------------+--------+

| Com_rollback  | 537161 |

+---------------+--------+

1 row in set (0.00 sec)

mysql> SHOW GLOBAL STATUS LIKE 'Uptime';

+---------------+--------+

| Variable_name | Value  |

+---------------+--------+

| Uptime        | 238827 |

+---------------+--------+

1 row in set (0.00 sec)

mysql> select (71050554+537161)/238827 as 'TPS VALUE' from dual;

+-----------+

| TPS VALUE |

+-----------+

|  299.7472 |

+-----------+

1 row in set (0.00 sec)