Forum for MySQL Enterprise Monitor & Oracle Enterprise Manager for MySQL https://forums.mysql.com/list.php?142 Fri, 06 Mar 2026 14:14:49 +0000 Phorum 5.2.23 https://forums.mysql.com/read.php?142,725339,725339#msg-725339 https://forums.mysql.com/read.php?142,725339,725339#msg-725339 - https://blogs.oracle.com/observability/post/capacity-plan-sql-performance-insights-heatwave-mysql]]> Edwin Desouza MySQL Monitoring & Oracle Enterprise Manager Thu, 01 Aug 2024 14:33:53 +0000 https://forums.mysql.com/read.php?142,723844,723844#msg-723844 https://forums.mysql.com/read.php?142,723844,723844#msg-723844 - https://blogs.oracle.com/observability/post/enterprise-manager-how-comcast-enhanced-monitoring-for-mysql-innodb-clusters]]> Edwin Desouza MySQL Monitoring & Oracle Enterprise Manager Mon, 22 Apr 2024 20:59:02 +0000 https://forums.mysql.com/read.php?142,708715,708715#msg-708715 https://forums.mysql.com/read.php?142,708715,708715#msg-708715
Problem running post-install step. Installation may not complete correctly
Error running /opt/mysql/enterprise/monitor/mysql/bin/mysql --defaults-file=/opt/mysql/enterprise/monitor/mysql/my.cnf -S /opt/mysql/enterprise/monitor/mysql/tmp/mysql.sock -u root -D mysql -e "DELETE FROM user WHERE user = 'root' AND host NOT IN ('localhost', '127.0.0.1'); ALTER USER 'root'@'localhost' IDENTIFIED BY '****'; UPDATE user SET User = 'service_manager' WHERE User = 'root'; DELETE FROM user WHERE User = ''; FLUSH PRIVILEGES;": /opt/mysql/enterprise/monitor/mysql/bin/mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory]]> Ryan von Fiedler MySQL Monitoring & Oracle Enterprise Manager Tue, 11 Apr 2023 21:45:00 +0000 https://forums.mysql.com/read.php?142,708611,708611#msg-708611 https://forums.mysql.com/read.php?142,708611,708611#msg-708611
Thank you]]> David Dalle MySQL Monitoring & Oracle Enterprise Manager Fri, 31 Mar 2023 18:34:34 +0000 https://forums.mysql.com/read.php?142,707319,707319#msg-707319 https://forums.mysql.com/read.php?142,707319,707319#msg-707319
I have a need where I have numerous tables that receive many records in the database and I'm arriving now as a database administrator for Mysql.
With that, I would like to monitor the limit of use of the sequences to prevent the system from stopping, does anyone know how?]]> Marco Antonio borges MySQL Monitoring & Oracle Enterprise Manager Sun, 12 Feb 2023 12:20:15 +0000 https://forums.mysql.com/read.php?142,703512,703512#msg-703512 https://forums.mysql.com/read.php?142,703512,703512#msg-703512 — https://twitter.com/TanelPoder/status/1504550386195222531
— https://tanelpoder.com/posts/mysql-now-shows-thread-names-at-os-level/]]> Edwin Desouza MySQL Monitoring & Oracle Enterprise Manager Fri, 18 Mar 2022 01:20:42 +0000 https://forums.mysql.com/read.php?142,698515,698515#msg-698515 https://forums.mysql.com/read.php?142,698515,698515#msg-698515 y s MySQL Monitoring & Oracle Enterprise Manager Fri, 27 Aug 2021 14:22:09 +0000 https://forums.mysql.com/read.php?142,695079,695079#msg-695079 https://forums.mysql.com/read.php?142,695079,695079#msg-695079
He investigado y la única forma de mostrar un resultado parecido es utilizar show processlist o show full processlist, pero quisiera saber si existe otra consulta para obtener mas detalle de lo que está sucediendo en mi base de datos.]]> Rosco VarOc MySQL Monitoring & Oracle Enterprise Manager Sat, 27 Feb 2021 17:01:03 +0000 https://forums.mysql.com/read.php?142,688363,688363#msg-688363 https://forums.mysql.com/read.php?142,688363,688363#msg-688363
How to interpret it?

Thanks]]> Kok Aik Ung MySQL Monitoring & Oracle Enterprise Manager Wed, 17 Jun 2020 17:00:18 +0000 https://forums.mysql.com/read.php?142,688361,688361#msg-688361 https://forums.mysql.com/read.php?142,688361,688361#msg-688361 Kok Aik Ung MySQL Monitoring & Oracle Enterprise Manager Tue, 16 Jun 2020 07:36:05 +0000 https://forums.mysql.com/read.php?142,686257,686257#msg-686257 https://forums.mysql.com/read.php?142,686257,686257#msg-686257
I am trying to figure the best way to monitor. I have done a lot of searching and see that there are third party tools. This outfit has MySQL running on Windows Server. They are running MySQL 8 Enterprise.

It's a small outfit and I'm dipping my toes in the water and would like to help and figure out how to monitor, improve things.

1) Does Enterprise include some tools, including monitoring tools ? It kinda reads like it, but at the same time it doesn't seem to EXCPLICITLY say this. They do not have any tools installed.

2) Are there good, free tools that would work well ?

3) and/or inexpensive tool.

Thanks for your input.

I'd love to be able to discuss some things verbally with an experienced MySQL(8) DBA for pointers, etc.. I learn so much better from real example at least.]]> R Farris MySQL Monitoring & Oracle Enterprise Manager Thu, 09 Apr 2020 22:39:29 +0000 https://forums.mysql.com/read.php?142,678173,678173#msg-678173 https://forums.mysql.com/read.php?142,678173,678173#msg-678173
I am using telegraf and prometheus to monitor number of select command in mysql in interaval time by Select_full_join metric, but it gives me wrong value. Anyone had done it, please give me an advice. Thanks!]]> quang vu MySQL Monitoring & Oracle Enterprise Manager Thu, 09 Apr 2020 16:01:33 +0000 https://forums.mysql.com/read.php?142,674605,674605#msg-674605 https://forums.mysql.com/read.php?142,674605,674605#msg-674605
I am working with some project which includes MySQL in it.I just wanted to monitor the metrics of MySQL like Memory usage,Disk usage,Network in & out etc or some other which are related to MySQL .
I am aware that we can use many application monitoring ,server monitoring, command line tools to get these metrics. i am wondering is there any way or option to monitor these metrics without using any tools.
If yes, can someone help me how to do that? that will be very helpful.


Thank you]]> Nisharunnisa Shaik MySQL Monitoring & Oracle Enterprise Manager Mon, 06 May 2019 14:09:36 +0000 https://forums.mysql.com/read.php?142,673811,673811#msg-673811 https://forums.mysql.com/read.php?142,673811,673811#msg-673811
Would I need a license to monitor MySQL community edition (GPL) with Oracle Enterprise Manager for MySQL.]]> David Nunns MySQL Monitoring & Oracle Enterprise Manager Thu, 04 Apr 2019 15:10:37 +0000 https://forums.mysql.com/read.php?142,672240,672240#msg-672240 https://forums.mysql.com/read.php?142,672240,672240#msg-672240 https://blogs.oracle.com/mysql/mysql-enterprise-monitor-8014-has-been-released]]> Edwin Desouza MySQL Monitoring & Oracle Enterprise Manager Wed, 23 Jan 2019 01:09:20 +0000 https://forums.mysql.com/read.php?142,668568,668568#msg-668568 https://forums.mysql.com/read.php?142,668568,668568#msg-668568
Currently, we are using two different MySQL version 5.5 and and 5.7 databases.

We are looking to install MySQL Enterprise Monitor (MEM), and want to know which MEM version can be used to monitor both these version databases?

Thank you in advance.]]> Ashish Shah MySQL Monitoring & Oracle Enterprise Manager Mon, 27 Aug 2018 20:09:51 +0000 https://forums.mysql.com/read.php?142,668163,668163#msg-668163 https://forums.mysql.com/read.php?142,668163,668163#msg-668163 I have built a two node cluster with an active VIP. The first node has the VIP loaded which is the active node and it’s called ranger1988. The second node ranger1989 being the inactive node.

Questions
1.How do I get MySQL enterprise monitor to monitor both without the monitor showing any errors for the passive node since MySQL is not running on there?]]> kwabena bempah MySQL Monitoring & Oracle Enterprise Manager Tue, 07 Aug 2018 16:09:36 +0000 https://forums.mysql.com/read.php?142,666525,666525#msg-666525 https://forums.mysql.com/read.php?142,666525,666525#msg-666525 http://support.oracle.com]]> Edwin Desouza MySQL Monitoring & Oracle Enterprise Manager Thu, 24 May 2018 21:18:10 +0000 https://forums.mysql.com/read.php?142,666517,666517#msg-666517 https://forums.mysql.com/read.php?142,666517,666517#msg-666517
Thank you]]> David Dalle MySQL Monitoring & Oracle Enterprise Manager Mon, 28 May 2018 18:01:52 +0000 https://forums.mysql.com/read.php?142,666367,666367#msg-666367 https://forums.mysql.com/read.php?142,666367,666367#msg-666367 Please Disregard - Problem Has Been Solved
**********************************************

I created a password on the keystore and I just needed to make a small change to the tomcat server.xml file.

**********************************************

Hello,

We’re running MySQL Monitor 3.3.3.1199. The original self-signed certificate on our MySQL Monitor server has expired and I was trying to generate a new one using the instructions here:

https://dev.mysql.com/doc/mysql-monitor/3.4/en/mem-ssl-installation.html

It appears the default keystore password is the empty string. Anyway, I’m able to examine the keystore using this command and entering an blank password:

$INSTALL_ROOT/java/bin/keytool -list -v -keystore $INSTALL_ROOT/apache-tomcat/conf/keystore

However, when I try to recreate the keystore with a new certificate with this command:

$INSTALL_ROOT/java/bin/keytool -genkey -keyalg RSA -sigalg SHA256withRSA -keystore $INSTALL_ROOT/apache-tomcat/conf/keystore -alias tomcat -validity 365 -keysize 2048

I’m unable to recreate it using an empty password, as the password must be at least six characters. Is there anyway around this? I’d rather not have to fiddle around with the existing tomcat configuration files.

Thanks,
Preston]]> Preston Durrer MySQL Monitoring & Oracle Enterprise Manager Fri, 18 May 2018 14:28:10 +0000 https://forums.mysql.com/read.php?142,665817,665817#msg-665817 https://forums.mysql.com/read.php?142,665817,665817#msg-665817
I was just wondering if there were any plans to expose more of MEM's functionality through REST APIs? The only reference I've seen in the documentation is specific to creating blackouts

Apart from installing an agent on a target and registering it with the monitor, it'll be nice to be able to manage events, metrics etc. via curl commands as part of automated build processes without having to go through the browser

Regards,
Dayo]]> Dayo Lasode MySQL Monitoring & Oracle Enterprise Manager Tue, 24 Apr 2018 13:59:07 +0000 https://forums.mysql.com/read.php?142,664805,664805#msg-664805 https://forums.mysql.com/read.php?142,664805,664805#msg-664805 OS version: Ubuntu 16.04 LTS (x86_64)
OS Kernel: 4.4.0-116-generic


Hi,

Currently evaluating the MEM within a sandbox environment for demonstration before purchase consideration and I got the below error while trying an unattended install of the agent on a test target.


root@dbbox1:~# ./agent.sh
Unable to create symbolic link /opt/mysql/enterprise/agent/java/lib/amd64/server/libjsig.so -> ../libjsig.so
Abort
There has been an error.
Unable to create symbolic link /opt/mysql/enterprise/agent/java/lib/amd64/server/libjsig.so -> ../libjsig.so


root@dbbox1:~# cat agent.sh
./mysqlmonitoragent-4.0.3.5192-linux-x86-64bit-installer.bin \
--agent_installtype database \
--agentpassword testpass \
--agentuser agentlogin \
--generalpassword pa55word \
--generaluser memGeneral \
--limitedpassword pa55word \
--limiteduser memLimited \
--managerhost memsrv \
--mode unattended \
--mysqlconnectiongroup lab \
--mysqlconnmethod socket \
--mysqlport 3306 \
--agent_autocreate 0 \
--mysqlhost localhost \
--mysqluser memAdmin \
--mysqlpassword pa55word \
--mysqlsocket /var/run/mysqld/mysqld.sock

The file is actually missing from the package:

root@dbbox1:~# ls -l /opt/mysql/enterprise/agent/java/lib/amd64/server/libjsig.so
ls: cannot access '/opt/mysql/enterprise/agent/java/lib/amd64/server/libjsig.so': No such file or directory
root@dbbox1:~#




The MEM server is running fine on the same OS version on a separate box

root@memsrv:~# mysqlmonitorctl.sh status
MySQL Enterprise MySQL is running
MySQL Enterprise Tomcat is running


I initially tried a GUI based installation and got the same error before attempting this. Any hints will be appreciated

Regards,

Dayo]]> Dayo Lasode MySQL Monitoring & Oracle Enterprise Manager Mon, 12 Mar 2018 10:23:34 +0000 https://forums.mysql.com/read.php?142,664300,664300#msg-664300 https://forums.mysql.com/read.php?142,664300,664300#msg-664300 I've been trying to find the way of seeing the execution plan of a stored procedure through MySQL Workbench and I was not able to do it.
I'm proccessing large XML files inside the procedures (with ExtracValue function) and I would like to see what's going on inside the procedure because it takes a long time to run.
If anybody knows any way to see what is happening inside my procedure, the run times of every call to the ExtractValue, I willl be greatful.

Thanks]]> Ismael Jebril MySQL Monitoring & Oracle Enterprise Manager Fri, 09 Feb 2018 12:04:03 +0000 https://forums.mysql.com/read.php?142,658804,658804#msg-658804 https://forums.mysql.com/read.php?142,658804,658804#msg-658804
In the MySQL Monitor Agent configuration we would like to define: keystoreFile and keystorePass (to work in conjunction with the existing ssl-ca-keystore-path and ssl-ca-keystore-password)

In the MySQL Monitor configuration we would like to define the following variables, for Tomcat: clientAuth, sslProtocols, keystoreFile, keystorePass, truststoreFile, truststorePass, sslEnabledProtocols, sslProtocols]]> Jason Miele MySQL Monitoring & Oracle Enterprise Manager Thu, 13 Jul 2017 18:08:57 +0000 https://forums.mysql.com/read.php?142,658754,658754#msg-658754 https://forums.mysql.com/read.php?142,658754,658754#msg-658754
in our MySQL Enterprise Monitor 3.4 installation, we had an issue during the stress test.
That issue became apparent by the holes in the graphs regarding the connections to the database.

I have checked the agent logs and I see these error messages:
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
..........
java.net.SocketTimeoutException: Read timed out

Do you know why this happens?]]> Nadia Baldrighi MySQL Monitoring & Oracle Enterprise Manager Thu, 13 Jul 2017 09:34:36 +0000 https://forums.mysql.com/read.php?142,657957,657957#msg-657957 https://forums.mysql.com/read.php?142,657957,657957#msg-657957
When a user is set up in MySQL Enterprise Monitor they seem to not have permissions to change their own password unless they are allocated the Administer Roles and Users privilege, which is then too much access. Can anyone confirm if this is the case?]]> K DBA MySQL Monitoring & Oracle Enterprise Manager Tue, 06 Jun 2017 14:53:39 +0000 https://forums.mysql.com/read.php?142,653372,653372#msg-653372 https://forums.mysql.com/read.php?142,653372,653372#msg-653372
I executed the below step to recover one of the crashed table in my MySql Database, which is having 140 GB size.

mysql> recover table table_name;

It is running since 8 days...

Now, I want to know whether the query is processing in background or not and I had checked in PROCESSLIST, which is showing the TIME and STATE as Repair by Sorting.

Also, I had checked in Global Status, here I observed that, handler_read_rnd_next column is getting increased every time (approx: 9 crores).

Kindly help me to find out a way to check still how many records need to be processed

Thanks in advance...


Rajasekhar]]> Rajasekhar Raju Muppala MySQL Monitoring & Oracle Enterprise Manager Mon, 12 Dec 2016 14:44:42 +0000 https://forums.mysql.com/read.php?142,652750,652750#msg-652750 https://forums.mysql.com/read.php?142,652750,652750#msg-652750
i am new to MySQL and need some help in installing the MySQL Enterprise Service Manager on windows. I am following the steps mentioned in the below link : https://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-sm-gui-installer.html , however after completing the installation, i am not able to open the Enterprise monitor GUI at localhost:18443. In the Repository configuration section, i am entering the user name and other db details same which i am using in the DBeaver to connect to the MySQL DB which is hosted on a linux box.]]> Raghavendra Kumar MySQL Monitoring & Oracle Enterprise Manager Mon, 21 Nov 2016 11:18:06 +0000 https://forums.mysql.com/read.php?142,649647,649647#msg-649647 https://forums.mysql.com/read.php?142,649647,649647#msg-649647
Is it possbile to monitor DRBD replication status using mysql enterprise monitoring or oracle enterprise monitoring.]]> Sathish R MySQL Monitoring & Oracle Enterprise Manager Thu, 25 Aug 2016 14:07:12 +0000 https://forums.mysql.com/read.php?142,647309,647309#msg-647309 https://forums.mysql.com/read.php?142,647309,647309#msg-647309
I wanted to be clear on what ports are needs to be open for MySQL Enterprise server and Agent to communicate.

Can someone clearly fill up the table below.

Source Destination Port
MEM Server Agent server
Agent server MEM server

my understanding is, 18443 is the main port for communication and needs to be open at both the ends( MEM and agent ). Please correct me if I'm wrong.


Thanks,
Guru]]> Guruprasad D S MySQL Monitoring & Oracle Enterprise Manager Mon, 27 Jun 2016 21:29:29 +0000