Page History

...

In the event that you would like SQL DM for MySQL to use SSH when communicating with this server, you can configure it from this tab. SQL DM for MySQL disables SSH communications by default. In order to use it, you need to click the Enable System Metrics switch. Doing so provides a series of configuration options needed to enable SSH on the server.

Please refer to System PriviledgesPrivileges for further details of privileges needed for this feature.

...

• If you have specified, Authentication type as Key - You should note that SQL DM for MySQL only supports ''OpenSSH standard key format'' for key based authentication in SSH connections.
• Private Key: Paste the content of your private key file. Again, don’t do not specify the path to your private key file.
• Passphrase: Enter the passphrase for your private key file (if any). This can be left blank, if no passphrase was given for the private key.

...

If you want to collect data from the server, you need to select "Enable Data Collection", so that SQL DM for MySQL will collect and store various MySQL and OS metrics.

...

SQL DM for MySQL is designed for storing large amounts of data for long periods of time. Data collected before the specified timeframe is purged automatically. Timeframe may be specified in seconds, minutes, hours and days for a particular server.

Base time

For calculation of uptime-based counters the current value of each status variable will be is compared with either of those,

...

If SQL DM for MySQL 'base time' setting is defined and server status variable uptime_since_flush_status is available then, uptime_since_flush_status will be is used, if it is not available then base time will be is used.

The reason for this implementation is that if FLUSH STATUS is executed with a MySQL server, the server status variables will be reset to the same value as would be after a server restart. There is one important exception however and that is the 'uptime' status variable itself. This single status variable is not affected by FLUSH STATUS.

...