Description:
I noticed some weird looking values in show global status:
| Innodb_pages_read | 131951 |
| Innodb_pages_written | 1486014 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 18446744073709551517 | <---<-----<
| Innodb_row_lock_time_avg | 1561806280 | <---<-----<
| Innodb_row_lock_time_max | 3133607239 | <---<-----<
| Innodb_row_lock_waits | 11 |
| Innodb_rows_deleted | 617738 |
Note this server was only up for less than an hour, doing some inserts
into innodb tables. The values are documented as:
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html
#Innodb_row_lock_time
The total time spent in acquiring row locks, in milliseconds. Added in MySQL 5.0.3.
#Innodb_row_lock_time_avg
The average time to acquire a row lock, in milliseconds. Added in MySQL 5.0.3.
#Innodb_row_lock_time_max
The maximum time to acquire a row lock, in milliseconds. Added in MySQL 5.0.3.
So, not sure how they can have the shown values..
How to repeat:
not sure. will see if it happens in 5.0.26 and report back.
Suggested fix:
.