Comparing vtgate planner v3 and Gen4 for main
The GitHub issue used to track Gen4's progress can be found here.
| v3 | Gen4 | Improved by % | |
|---|---|---|---|
| QPS Total | 64,141.0 | 63,701.2 | -0.7 |
| QPS Reads | 40,088.1 | 39,813.3 | -0.7 |
| QPS Writes | 16,035.2 | 15,925.3 | -0.7 |
| QPS Other | 8,017.6 | 7,962.7 | -0.7 |
| TPS | 4,008.8 | 3,981.3 | -0.7 |
| Latency | 38.6 | 38.6 | 0.0 |
| Errors | 0.0 | 0.0 | 0.0 |
| Reconnects | 0.0 | 0.0 | 0.0 |
| Time | 900 | 900 | 0 |
| Threads | 0.0 | 0.0 | 0.0 |
| Total CPU time | 48,099.75 | 48,227.70 | -0.27 |
| CPU time vtgate | 25,371.30 | 25,276.20 | 0.37 |
| CPU time vttablet | 22,728.45 | 22,951.45 | -0.98 |
| Total Allocs bytes | 6.2 TB | 6.2 TB | 0.11 |
| Allocs bytes vtgate | 3.0 TB | 3.0 TB | 0.17 |
| Allocs bytes vttablet | 3.2 TB | 3.2 TB | 0.07 |
| v3 | Gen4 | Improved by % | |
|---|---|---|---|
| QPS Total | 82,248.6 | 70,726.6 | -16.3 |
| QPS Reads | 37,614.7 | 28,665.7 | -31.2 |
| QPS Writes | 38,794.8 | 19,561.8 | -98.3 |
| QPS Other | 5,839.2 | 22,499.0 | 74.0 |
| TPS | 2,919.4 | 6,358.0 | 54.1 |
| Latency | 240.0 | 84.5 | 64.8 |
| Errors | 12.7 | 4,891.3 | -38,444.7 |
| Reconnects | 0.0 | 0.0 | 0.0 |
| Time | 900 | 900 | 0 |
| Threads | 0.0 | 0.0 | 0.0 |
| Total CPU time | 88,800.20 | 90,630.90 | -2.06 |
| CPU time vtgate | 55,499.90 | 54,954.40 | 0.98 |
| CPU time vttablet | 33,300.30 | 35,676.50 | -7.14 |
| Total Allocs bytes | 11 TB | 11 TB | -0.64 |
| Allocs bytes vtgate | 6.7 TB | 6.6 TB | 1.07 |
| Allocs bytes vttablet | 3.9 TB | 4.0 TB | -3.59 |