Performance schema useful queries

query.sql

# Locked threads
SELECT * FROM `events_waits_current` LIMIT 0,10000;

# top used queries with UPDATE and their percentage
SELECT
  digest_text,
  count_star / update_total * 100 as percentage_of_all
FROM events_statements_summary_by_digest,
( SELECT sum(count_star) update_total
  FROM events_statements_summary_by_digest
  WHERE digest_text LIKE 'UPDATE%'
) update_totals
WHERE digest_text LIKE 'UPDATE%'
ORDER BY percentage_of_all DESC
LIMIT 10

# info about triggers and their running time
SELECT * FROM `events_statements_summary_by_program` LIMIT 0,10000;