The following instance parameter indicators are tested:
• Transactions per second (TPS)
• The number of transactions that are executed by the database per second. A transaction is executed only after it is committed.
– In a standard OLTP read/write scenario of SysBench, a transaction contains 18 read/write SQL statements.
– In a standard OLTP read-only scenario of SysBench, a transaction contains 14 read SQL statements (ten primary key point queries and four range queries).
– In a standard OLTP write-only scenario of SysBench, a transaction contains four write SQL statements (two UPDATE, one DELETE, and one INSERT).
• Queries per second (QPS)
– The number of SQL statements executed per second by the database, including INSERT, SELECT, UPDATE, DETELE, COMMIT, etc.