Thursday, September 14, 2023

Using MySQL Enterprise Monitor to monitor MySQL Heatwave Service

This tutorials walk through the process to monitor the MySQL Heatwave Service using MySQL Enterprise Monitor(MEM) , Below are steps you needed to follow. 


1. Installed MySQL Enterprise Monitor(MEM). 
2. Putty - 
3. Up & Running MySQL Heatwave Service on Oracle Cloud Infrastructure (OCI). 
4. Up and Running Compute instance in OCI. 

Note:- To download MySQL Enterprise Monitor trail version by below links:- 

Note:- download only service manager , AGENT is not required for MySQL Heatwave Service 

 How to Install MySQL Enterprise Monitor? 

Below steps is to be followed (assuming installation host is Linux- OL/RHEL/CentOS) 

Installation of Service Manager on Compute Instance of OCI 

Step 1:-goto location of downloaded location of service manager & Give the persmission 

#cd /home/opc/bootcamp/Monitor/ 

#chmod +x mysqlmonitor- 

Step 2:- Execute the file 


Step 3:- Follow the instructions prompted on screen, always keep default value so keep pressing ENTER 

Please keep all password as example like this:- MySQL8.0 # one Caps , Number ,Special Character ,Letters, 8 long 

Step 4:- To Check Service Running or not:- 

#service mysql-monitor-server status 

#####In case any error occurred below while installation , please execute below to fix it 

Error: error while loading 

shared libraries: cannot open shared object file: No such file 


#sudo yum install ncurses-compat-libs 

Step 5 : Login to MySQL Enterprise Monitor(MEM) 

To Login Web Browser , assume google chrome running on your local machine 

make sure IP address is whitelisted to access from your local machine. #<use your public IP address> 

Create User “Manager” Role:- manager/manager 

Create User “Agent” Role:- agent/agent 

Open MySQL Enterprise Monitor(MEM) 

Go to Configuration >>MySQL Instances >> Add MySQL Instance 

Monitoring From:- Built-in Agent 

Connection Using:- TCP/IP 

Instance Address:- You needed to give MySQL Heatwave Service Private IP Address 

Admin User :- MySQL Heatwave Service User Name 

Port :- MySQL Heatwave Port number 

MySQL User Name :- <give user name of MySQL database> 

Admin Password :- <give the password>********* 

Auto-Create Less Privileged Users : NO 

Enter above details as below. 

Once connection to heatwave service established then below output look like.

Visual Query Analysis 

Monitor real-time query performance, check execution statistics, filter and pinpoint SQL code that is causing a slow-down. Using the Performance Schema with MySQL Server 5.6, data is gather 

Find and Fix Expensive Queries 

Correlated graphs enable developers and DBAs to compare execution parameters, such as the server load, thread statistics, or RAM usage against the queries that were executing at that time. Simply highlight a time slice on a graph to find the most expensive queries and locate a potential cause for the larger performance issue. 

To review the list of queries running from MySQL Heatwave Service , click on "Query" tab to review it 

and click on each individual queries to get deep insight about what's going on with the queries.

some of screenshot as below


MySQL Enterprise Monitor provides real-time visibility into the performance and availability of all your MySQL databases 

including hybrid environment (OnP and Cloud) and Start monitoring MySQL within 10 minutes with zero configuration and no agents. 

MySQL Heatwave Database Service is a fully managed database service that enables organizations to deploy cloud-native applications using the world's most popular open source database. 

It is 100% developed, managed and supported by the MySQL Team. 

You will get one database for OLTP ,OLAP,ML,Lakehouse which is very unique solutions available in multi-cloud environment(OCI ,AWS,Azure).

No comments:

Post a Comment