--- /dev/null
+package events_stages_summary_global_by_event_name
+
+import (
+ "database/sql"
+ "fmt"
+ "time"
+
+ "github.com/sjmudd/pstop/lib"
+ "github.com/sjmudd/pstop/p_s"
+)
+
+/*
+
+root@localhost [performance_schema]> select * from events_stages_summary_global_by_event_name where sum_timer_wait > 0;
++--------------------------------+------------+----------------+----------------+----------------+----------------+
+| EVENT_NAME | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT |
++--------------------------------+------------+----------------+----------------+----------------+----------------+
+| stage/sql/After create | 3 | 21706000 | 558000 | 7235000 | 11693000 |
+| stage/sql/checking permissions | 5971 | 92553236000 | 406000 | 15500000 | 12727728000 |
+| stage/sql/cleaning up | 6531 | 4328103000 | 154000 | 662000 | 23464000 |
+| stage/sql/closing tables | 4281 | 18303106000 | 118000 | 4275000 | 71505000 |
+| stage/sql/Creating sort index | 2 | 31300648000 | 14183237000 | 15650324000 | 17117411000 |
+| stage/sql/creating table | 2 | 138276471000 | 64077127000 | 69138235000 | 74199344000 |
+| stage/sql/end | 4254 | 9940694000 | 220000 | 2336000 | 42683000 |
+| stage/sql/executing | 1256 | 252300800000 | 151000 | 200876000 | 59564212000 |
+| stage/sql/freeing items | 3733 | 83966405000 | 5341000 | 22493000 | 2527549000 |
+| stage/sql/init | 4256 | 63836793000 | 1990000 | 14999000 | 7656920000 |
+| stage/sql/Opening tables | 6002 | 1489653915000 | 1411000 | 248192000 | 216300236000 |
+| stage/sql/optimizing | 1257 | 2685426016000 | 255000 | 2136377000 | 2656149827000 |
+| stage/sql/preparing | 1166 | 8626237000 | 1666000 | 7398000 | 91804000 |
+| stage/sql/query end | 4280 | 37299265000 | 411000 | 8714000 | 12018400000 |
+| stage/sql/removing tmp table | 1187 | 11890909000 | 1838000 | 10017000 | 2365358000 |
+| stage/sql/Sending data | 1165 | 3071893676000 | 2925000 | 2636818000 | 63354201000 |
+| stage/sql/Sorting result | 2 | 4128000 | 1930000 | 2064000 | 2198000 |
+| stage/sql/statistics | 1166 | 26655651000 | 2078000 | 22860000 | 8446818000 |
+| stage/sql/System lock | 4263 | 1901250693000 | 584000 | 445988000 | 1651181465000 |
+| stage/sql/update | 4 | 8246608000 | 78145000 | 2061652000 | 7597263000 |
+| stage/sql/updating | 2994 | 1608420140000 | 285867000 | 537214000 | 15651495000 |
+| stage/sql/starting | 6532 | 364087027000 | 2179000 | 55738000 | 23420395000 |
++--------------------------------+------------+----------------+----------------+----------------+----------------+
+22 rows in set (0.01 sec)
+
+*/
+
+// public view of object
+type Object struct {
+ p_s.RelativeStats
+ p_s.InitialTime
+ initial table_rows // initial data for relative values
+ current table_rows // last loaded values
+ results table_rows // results (maybe with subtraction)
+ totals table_row // totals of results
+}
+
+// Collect() collects data from the db, updating initial
+// values if needed, and then subtracting initial values if we want
+// relative values, after which it stores totals.
+func (t *Object) Collect(dbh *sql.DB) {
+ start := time.Now()
+ t.current = select_rows(dbh)
+ lib.Logger.Println("t.current collected", len(t.current), "row(s) from SELECT")
+
+ if len(t.initial) == 0 && len(t.current) > 0 {
+ lib.Logger.Println("t.initial: copying from t.current (initial setup)")
+ t.initial = make(table_rows, len(t.current))
+ copy(t.initial, t.current)
+ }
+
+ // check for reload initial characteristics
+ if t.initial.needs_refresh(t.current) {
+ lib.Logger.Println("t.initial: copying from t.current (data needs refreshing)")
+ t.initial = make(table_rows, len(t.current))
+ copy(t.initial, t.current)
+ }
+
+ t.make_results()
+
+ // lib.Logger.Println( "t.initial:", t.initial )
+ // lib.Logger.Println( "t.current:", t.current )
+ lib.Logger.Println("t.initial.totals():", t.initial.totals())
+ lib.Logger.Println("t.current.totals():", t.current.totals())
+ // lib.Logger.Println("t.results:", t.results)
+ // lib.Logger.Println("t.totals:", t.totals)
+ lib.Logger.Println("Table_io_waits_summary_by_table.Collect() END, took:", time.Duration(time.Since(start)).String())
+}
+
+func (t *Object) Headings() string {
+ return t.totals.headings()
+}
+
+func (t Object) RowContent(max_rows int) []string {
+ rows := make([]string, 0, max_rows)
+
+ for i := range t.results {
+ if i < max_rows {
+ rows = append(rows, t.results[i].row_content(t.totals))
+ }
+ }
+
+ return rows
+}
+
+func (t Object) EmptyRowContent() string {
+ var e table_row
+
+ return e.row_content(e)
+}
+
+func (t Object) TotalRowContent() string {
+ return t.totals.row_content(t.totals)
+}
+
+func (t Object) Description() string {
+ count := t.count_rows()
+ return fmt.Sprintf("Latency by SQL stage (events_stages_summary_global_by_event_name) %d rows", count)
+}
+
+func (t *Object) SyncReferenceValues() {
+}
+
+func (t *Object) make_results() {
+ // lib.Logger.Println( "- t.results set from t.current" )
+ t.results = make(table_rows, len(t.current))
+ copy(t.results, t.current)
+ if t.WantRelativeStats() {
+ t.results.subtract(t.initial)
+ }
+
+ t.results.Sort()
+ t.totals = t.results.totals()
+}
+
+func (t Object) count_rows() int {
+ var count int
+ for row := range t.results {
+ if t.results[row].SUM_TIMER_WAIT > 0 {
+ count++
+ }
+ }
+ return count
+}
git://git.iain.cx/iain / pstop.git / blobdiff