Bug #50422 Purge allows gradually falling behind by ignoring (LIMIT X == rows purged)
| Submitted: | 18 Jan 2010 16:40 | Modified: | 29 Jun 2010 11:27 |
|---|---|---|---|
| Reporter: | Mark Leith | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Enterprise Monitor: Server | Severity: | S2 (Serious) |
| Version: | 2.1.0.1093 | OS: | Any |
| Assigned to: | Darren Oldag | CPU Architecture: | Any |
| Tags: | purge, windmill | ||
[18 Jan 2010 16:40]
Mark Leith
[18 Jan 2010 16:48]
Simon Mudd
Suggestion: Alert on the dashboard. the tomcat log is not really a good place for this... (or send out an email). You NEED to catch our attention on this (dba/sysadmins)
[20 Jan 2010 17:16]
Enterprise Tools JIRA Robot
Eric Herman writes: rather than wait the full delay cycle before doing additional purge, we will purge as many chunks as needed at the time the purge is called.
[20 Jan 2010 17:31]
Enterprise Tools JIRA Robot
Keith Russell writes: Patch installed in versions => 2.1.1.1141
[29 Jun 2010 11:27]
MC Brown
A note has been added to the 2.1.1 and 2.2.0 changelogs:
When purging old data, the purging process could fail to
remove all of the data if the inflow of new information was
very high. Purging now removes all outdated information at
each execution.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.