End user has below parameters set in my.cnf for MySQL server 5.7:
max_connections = 1000
and the DB server has an issue of high memory usage.
Component : UNIFIED INFRASTRUCTURE MGMT
Variables that determine the per-session buffer size are set to a very large value (in bytes).
Typical variables are :
Reduce per-session buffer size.
Since most of such variables are dynamic, run in MySQL prompt:
> set global var = value;
and also concrete these changes in the my.cfg or my.ini file used by MySQL server.
If show process list returns a large number of processes are in sleeping status.
Consider reducing the timeout values: wait_timeout and interactive_timeout and reduce the connection pool size managed by ems, wasp probe.