Page History
MySQL Privileges
Whether you 're are running a single MySQL database server or multiple servers in a cluster, SQL DM for MySQL provides a comprehensive list of performance variables that you can monitor in real-time to check the health and performance of your MySQL server or servers.
In order to access the data for these metrics, SQL DM for MySQL requires a dedicated user on each MySQL database server it monitors, with the appropriate privileges to collect the information it needs.
Privileges
Most SQL DM for MySQL functionalities don't do not require any privileges at all for the user it uses in establishing client connections with MySQL. You can create it without any special global or object privileges, using the following command:
...
| Note |
|---|
For an example of granting full functionality to the SQL DM for MySQL user, see Database Configuration <db-config> below. |
Security Counters
SQL DM for MySQL user requires SELECT privileges to the mysql.user table to enable SQL DM for MySQL security counters.
Additionally, if the server was started with the skip_show_databases configuration variable, you must also explicitly grant the SHOW DATABASES privilege.
Replication Counters
In order to collect replication metrics from a slave, the MySQL user on the slave requires the REPLICATION_CLIENT privilege. You can also enable this functionality using the SUPER privilege.
When registering MySQL servers with SQL DM for MySQL, there is an option Is this a Replication Slave? to include replication information. You must set this to Yes, when registering the server. It defaults to No. When , when set to No, SQL DM for MySQL ignores replication data.
...
You can ignore this error if the given MySQL server is not a replication slave or if you don't do not want to monitor replication.
InnoDB Deadlock Monitoring
Depending on the MySQL server version, the SUPER or PROCESS privileges allow you to monitor for deadlocks with the InnoDB storage engine.
| Note |
|---|
Beginning in the 5.1.24 version of MySQL, you can enable this feature using |
Processlist Feature
In order to collect data on the MySQL server processes for all users, you must enable the PROCESS privilege. Additionally, when granted the SUPER privilege, you can use SQL DM for MySQL to kill running processes.
In order to use the EXPLAIN option on the processlist, you need to grant SELECT and SHOW VIEW to the objects accessed by the statements you want to explain, or , more simply, grant the global SELECT privilege.
| Note |
|---|
SQL DM for MySQL displays |
Performance Schema-based Sniffer
Collecting data on the Performance schema requires SELECT, DROP and UPDATE privileges.
SQL DM for MySQL uses the SELECT privilege to read the Performance Schema tables. The DROP privilege allows it to truncate these tables. The UPDATE privilege enables the statement digest and statement history log in the performance schema tables.
Log Retrieval
In order to retrieve log information when stored in a table, (which is supported in version 5.1 and newer of MySQL), the SQL DM for MySQL user requires the SELECT privilege on the log tables.
Flush Status
In order to execute FLUSH STATUS commands, the SQL DM for MySQL user also requires the RELOAD privilege.