EM监控MYSQL用户权限

郑全

1.登录数据库
   mysql -u root -p


2.创建监控用户   cREATE USER 'monitoring'@'%' IDENTIFIED BY 'cloud_4U';


3.授权
  

   GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, PROCESS, EXECUTE ON *.* TO 'monitoring'@'%' IDENTIFIED BY 'cloud_4U';

4.刷新权限生效
   FLUSH PRIVILEGES;


5.使用 Sys Schema Table Metadata Lock Waits 度量
   [mysqld]
   performance-schema-instrument='wait/lock/metadata/sql/mdl=ON'