We have an active and important InnoDB table with about 8M rows. We just noticed that for several months, the primary key value (a BIGINT) has been jumping by hundreds at a time.
I turned on query logging while watching for a jump and found no deletions from the table during the time. (We don't often delete historical data, anyway.)
MySQL version: mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (i386) using readline 5.1
OS: Centos 6.3
Any ideas how or why this could happen?
Any other information you might need to assess the situation?