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.

Image Removed

SQL DM for MySQL query sniffer is a functionality that records a pseudo server log and stores it in the SQL DM for MySQL embedded database. With Sniffer enabled, SQL DM for MySQL can populate the pseudo server log in three different ways at the intervals you specify:

  • 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

For MySQL 5.6.14 and above you can use Performance schema(if Performance Schema is enabled), Proxy and Processlist for query analysis. If using MySQL version less than 5.6.14 then you can use Processlist mode.

...