----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/42041/ -----------------------------------------------------------
(Updated Jan. 8, 2016, 1:52 p.m.) Review request for Aurora, John Sirois and Maxim Khutornenko. Repository: aurora Description ------- With this enabled operators can visit the H2 console at /h2console and run queries like `SELECT * FROM INFORMATION_SCHEMA.QUERY_STATISTICS ORDER BY MAX_EXECUTION_TIME DESC;` to diagnose slow schedulers. Diffs ----- src/main/java/org/apache/aurora/scheduler/storage/db/DbModule.java e3efbdb80d8b18312bf1589eef883cdeee65b225 Diff: https://reviews.apache.org/r/42041/diff/ Testing (updated) ------- Ran `SELECT * FROM INFORMATION_SCHEMA.QUERY_STATISTICS ORDER BY MAX_EXECUTION_TIME DESC;` within vagrant and saw query statistics. Benchmarks Master (c595228): Benchmark (numPendingTasks) Mode Cnt Score Error Units SchedulingBenchmarks.ClusterFullUtilizationBenchmark.runBenchmark N/A thrpt 10 64138.084 ± 6732.130 ops/s SchedulingBenchmarks.InsufficientResourcesSchedulingBenchmark.runBenchmark N/A thrpt 10 23863.861 ± 2101.622 ops/s SchedulingBenchmarks.LimitConstraintMismatchSchedulingBenchmark.runBenchmark N/A thrpt 10 2228.883 ± 311.434 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 1 thrpt 10 50.914 ± 2.488 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 10 thrpt 10 43.729 ± 3.038 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 100 thrpt 10 44.409 ± 4.426 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 1000 thrpt 10 40.429 ± 7.526 ops/s SchedulingBenchmarks.ValueConstraintMismatchSchedulingBenchmark.runBenchmark N/A thrpt 10 22942.538 ± 1281.331 ops/s This change: Benchmark (numPendingTasks) Mode Cnt Score Error Units SchedulingBenchmarks.ClusterFullUtilizationBenchmark.runBenchmark N/A thrpt 10 65285.628 ± 2422.816 ops/s SchedulingBenchmarks.InsufficientResourcesSchedulingBenchmark.runBenchmark N/A thrpt 10 24573.332 ± 1332.474 ops/s SchedulingBenchmarks.LimitConstraintMismatchSchedulingBenchmark.runBenchmark N/A thrpt 10 2430.402 ± 258.860 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 1 thrpt 10 43.810 ± 2.669 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 10 thrpt 10 37.378 ± 14.637 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 100 thrpt 10 40.180 ± 9.738 ops/s SchedulingBenchmarks.PreemptorSlotSearchBenchmark.runBenchmark 1000 thrpt 10 24.130 ± 15.746 ops/s SchedulingBenchmarks.ValueConstraintMismatchSchedulingBenchmark.runBenchmark N/A thrpt 10 18429.830 ± 3077.426 ops/s Thanks, Zameer Manji