Introduction to TPC-C
The TPC-C workload simulates a simple OLTP environment: multiple online terminal sessions in a warehouse-based distribution operation. It contains a mixture of read-only and update-intensive transactions based on a nonuniform data distribution while enforcing transaction (ACID) properties. Table 27-1 shows the five TPC-C transactions executed against nine tables.
| Transactions | Weight | Profile | Percentage Mix | 90th Percentile Response |
|---|---|---|---|---|
| New-Order | Midweight | Read/write | < 45% | 5 secs |
| Payment | Lightweight | Read/write | Min. 43% | 5 secs |
| Order-Status | Midweight | Read-only | Min. 4% | 5 secs |
| Stock-Level | Heavyweight | Read-only | Min. 4% | 20 secs |
| Delivery | Heavyweight | Read/write | Min. 4% | 80 secs |
Of the nine tables, all ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
