The MONyog.ini is the configuration file used by SQL DM for MySQL to read the configuration and is created when MONyog(SQL DM for MySQL) service is started for the first…
The session data that are recorded by SQL DM by MySQL Real-Time are stored in SQLite in Monyog directories data folder. The Real-time database has many tables. Schema details are…
You can rebuild the embedded SQLite database for a server by clicking the arrow icon on the left panel next to the server name and selecting the Rebuild Database option. Using this…
sniffer.data Here, you see the same pattern as above: the [id] column in the [query_snapshot] table identifies a row in the [query_master] where the actual/textual query is saved. Also note,…
mysql.data and system.data These two databases have a completely identical structure: CREATE TABLE IF NOT EXISTS [metric_master] ( [metric_id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, [metric_desc] TEXT ASC UNIQUE…
Preferences and global settings In addition to the data stored on a per-server basis; SQL DM for MySQL has a database storing global user preferences (preferences.config database) and also a…
SQL DM for MySQL uses SQLite for storing all the data. With ‘data’ – we are referring to: There is one of each of those database files for every connection…
Database Schema reveals the SQLite schema details which are used for managing SQL DM for MySQL connections (copying connections/creating new connections etc.). Also, with this information you get the basic…
