Negative numbers in InnoDB Status There are some negative numbers displayed in the InnoDB Engine Status output.
Anybody has encountered this or know why this happens ?

----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1467883704; in additional pool allocated 26603520
Dictionary memory allocated 7134560
Buffer pool size 79552
Free buffers 0
Database pages 74624
Modified db pages 15997
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 12607789, created 151074, written 3737768
-7.21 reads/s, -0.17 creates/s, -1.10 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
1 queries inside InnoDB, 0 queries in queue
6 read views open inside InnoDB
Main thread id 7652, state: sleeping
Number of rows inserted 10757341, updated 2461678, deleted 1189294, read 7916897438
-14.00 inserts/s, -5.18 updates/s, -0.00 deletes/s, -14185.96 reads/s


I am using MySQL Version 5.1.51 (64 bit) on Windows Server 2008
I was able to replicate a similar condition by setting the system clock on a server (not Windows) to a time before the time when the MySQL Server process was started.  The numbers in my SHOW ENGINE INNODB STATUS are small since this is a test machine, but they're suddenly negative after changing the clock.

-0.00 inserts/s, -0.00 updates/s, -0.00 deletes/s, -0.01 reads/s


You might try this:

mysql&gt; SHOW STATUS LIKE 'uptime';


This is a value in seconds that appears to be calculated as the difference between the current system time and what the system time was when the server was started... and may be the same number used to calculate these stats.

If you see a massive number (an artifact of unsigned subtraction) that seems completely inconsistent with the server's true uptime then that would be confirmation that this is the cause.

If this is what you find, then I suspect the only remedy is to restart MySQL Server with the system clock set accurately.