… connections as in MySQL. This is very…the top queries with largest impact – longest sum …it matches –limit. # Scores: Apdex = 1.00 [1.0],…10us # 100us ################### # 1ms ################################################################ # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…consuming most MySQL time and that’s how mk-query-digest groups and orders data by default. Fixing top 10 … list me top slowest sessions: mk-query-digest –group-by=Thread_id –order-by=Query_time:sum in > … included in the report because it matches –limit. # Scores: Apdex = 0.97 [1.0], V/M = 19.02 …
