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 very tiny text file (MONyog.ini), that only has what minimal information is required for SQL DM for MySQL to start.
connection.data
There is a Preferences table in connection.data which is used for storing the default processlist query.
Code Block |
---|
|
CREATE TABLE IF NOT EXISTS [preferences] (
[name] VARCHAR(50) DEFAULT '' NOT NULL PRIMARY KEY UNIQUE,
[value] TEXT DEFAULT ''); |
The server_names table is used for storing all the connection details.
Code Block |
---|
|
CREATE TABLE [server_names]
(id INTEGER DEFAULT 0 NOT NULL PRIMARY KEY UNIQUE,
key VARCHAR(255) DEFAULT '' NOT NULL,
value VARCHAR(255) DEFAULT '' NOT NULL); |