Bug #26410 InnoDB row operations counters wraps around at 2^32
| Submitted: | 15 Feb 2007 15:32 | Modified: | 13 May 2010 16:04 |
|---|---|---|---|
| Reporter: | Per Hallström | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S4 (Feature request) |
| Version: | 5.0.27 | OS: | Any (Any) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[15 Feb 2007 15:32]
Per Hallström
[15 Feb 2007 16:18]
Mark Leith
Indeed you are correct: ulint srv_n_rows_inserted = 0; ulint srv_n_rows_updated = 0; ulint srv_n_rows_deleted = 0; ulint srv_n_rows_read = 0; Thank you for the reasonable feature request.
[15 Feb 2007 17:31]
Heikki Tuuri
The counters are 64-bit in a 64-bit computer, but only 32-bit in a 32-bit computer.
5.0:
./include/univ.i:182:#define ULINTPF "%I64u"
./include/univ.i:186:#define ULINTPF "%lu"
fprintf(file,
"Number of rows inserted " ULINTPF
", updated " ULINTPF ", deleted " ULINTPF ", read " ULINTPF "\n",
srv_n_rows_inserted,
srv_n_rows_updated,
srv_n_rows_deleted,
srv_n_rows_read);
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 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.