Percentage Of Max Allowed Reached

[peterlaursen]

Please try to execute the statements (from any client): 

SHOW GLOBAL STATUS LIKE 'Max_used_connections';

SHOW GLOBAL VARIABLES LIKE 'max_connections';

That is what MONyog does.  The formula is “Max_used_connections / max_connections”.

Note that this counter does not tell a shapshot of what situation is *now* – but tells what was the 'worst' situation in this respect that has occurred since server was restarted or FLUSH STATUS was executed.

[mauso]

Is true

thank

this problem is solved

'peterlaursen' wrote on '31:

Please try to execute the statements (from any client): 

SHOW GLOBAL STATUS LIKE 'Max_used_connections';

SHOW GLOBAL VARIABLES LIKE 'max_connections';

That is what MONyog does.  The formula is “Max_used_connections / max_connections”.

Note that this counter does not tell a shapshot of what situation is *now* – but tells what was the 'worst' situation in this respect that has occurred since server was restarted or FLUSH STATUS was executed.

[steven11]

Yes the solution works. I had the same problem. This is very quick to do. Thank you. 😉

'peterlaursen' wrote:

Please try to execute the statements (from any client): 

SHOW GLOBAL STATUS LIKE 'Max_used_connections';

SHOW GLOBAL VARIABLES LIKE 'max_connections';

That is what MONyog does.  The formula is “Max_used_connections / max_connections”.

Note that this counter does not tell a shapshot of what situation is *now* – but tells what was the 'worst' situation in this respect that has occurred since server was restarted or FLUSH STATUS was executed.

[Shalmali]

We are working on clearing alerts with out executing FLUSH STATUS.

This feature should be out in the next few weeks.

–Shalmali

[Author]

Posts