Are you actually querying the table (select count(*) from table_name), or just the stats
(show table status)? Is the table Innodb?
If you're using Innodb and aren't doing a select count (or other select query) on the
table, then yes you'll have varying results. This is because unlike MyISAM, Innodb does
not keep a count of the records. Using show table status gives just an estimation. This
would be my first path of investigation.
"The number of rows. Some storage engines, such as MyISAM, store the exact count. For
other storage engines, such as InnoDB, this value is an approximation, and may vary from
the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an
From: Zachary Stern [mailto:zs@stripped]
Sent: Tuesday, February 26, 2013 12:42 PM
Subject: data loss due to misconfiguration
Is such a thing possible? There are no errors or issues, but we can query a table, get X
number of rows, query it later, and all of the sudden be missing a thousand rows.
I know this isn't much to go on, but I'm not even sure what information to provide. Will
be happy to give anything you guys might be able to think of.
Notice: This communication may contain privileged and/or confidential information. If you
are not the intended recipient, please notify the sender by email, and immediately delete
the message and any attachments without copying or disclosing them. LBI may, for any
reason, intercept, access, use, and disclose any information that is communicated by or
through, or which is stored on, its networks, applications, services, and devices.