Alert Persist And Doesn't Clear Itself

[peterlaursen]

 This alert does not alert about 'current situation' but about 'the worst situation that occurred in this respect since server was restarted lst time or FLUSH STATUS was executed last time (what btw. is obvious from the formula “Max_used_connections / max_connections”)

Execute 

1) SHOW GLOBAL STATUS LIKE 'Max_used_connections'

2)  SHOW GLOBAL VARIABLES LIKE 'max_connections'

.. perform the division yourself and you will get same result.

To reset  'Max_used_connections' status variable execute FLUSH STATUS.  But if it happens frequently you should investigate the reason for this. It could be an intrusion attempt for instance.

Please see how the counter/advisor is defined:

[attachment=1441:max.jpg]

[Aaron Lee]

Thanks Peter,

That solved the problem, would it be possible to include this in pop up help dialog box? This would help other users tremendously in the future versions.

-Aaron

'peterlaursen' wrote:

 This alert does not alert about 'current situation' but about 'the worst situation that occurred in this respect since server was restarted lst time or FLUSH STATUS was executed last time (what btw. is obvious from the formula “Max_used_connections / max_connections”)

Execute 

1) SHOW GLOBAL STATUS LIKE 'Max_used_connections'

2)  SHOW GLOBAL VARIABLES LIKE 'max_connections'

.. perform the division yourself and you will get same result.

To reset  'Max_used_connections' status variable execute FLUSH STATUS.  But if it happens frequently you should investigate the reason for this. It could be an intrusion attempt for instance.

Please see how the counter/advisor is defined:

[attachment=1441:max.jpg]

[Shalmali]

Currently we are working on clearing alerts with out executing FLUSH STATUS.

This enhancement should be out in the next couple of weeks.

Thanks!

-Shalmali

[Author]

Posts