Versions Compared

Old Version 2

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 3

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • By utilizing Performance Schema tables (events_statements_summary_by_digest, events_statements_history_long) and collecting snapshots at regular intervals.
  • By sending the query SHOW FULL PROCESSLIST to the MySQL server.
  • Or, by connecting to a running instance of the MySQL-Proxy program that is used by one or more clients to connect to a MySQL server.

Image Added

Tip
For MySQL 5.6.14 and above you can use Performance schema, Proxy, and Processlist for query analysis. If using MySQL version less than 5.6.14 then only Proxy or Processlist can be used in SQL DM for MySQL.

...