From: Benjamin Stillman Date: February 26 2013 7:04pm Subject: RE: data loss due to misconfiguration List-Archive: http://lists.mysql.com/mysql/229042 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Are you actually querying the table (select count(*) from table_name), or j= ust the stats (show table status)? Is the table Innodb? If you're using Innodb and aren't doing a select count (or other select qu= ery) on the table, then yes you'll have varying results. This is because un= like 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 investigati= on. http://dev.mysql.com/doc/refman/5.5/en/show-table-status.html "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 approxim= ation, and may vary from the actual value by as much as 40 to 50%. In such = cases, use SELECT COUNT(*) to obtain an accurate count." -----Original Message----- From: Zachary Stern [mailto:zs@stripped] Sent: Tuesday, February 26, 2013 12:42 PM To: mysql@stripped 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 miss= ing 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. TIA. -Zachary ________________________________ Notice: This communication may contain privileged and/or confidential infor= mation. If you are not the intended recipient, please notify the sender by = email, and immediately delete the message and any attachments without copyi= ng or disclosing them. LBI may, for any reason, intercept, access, use, and= disclose any information that is communicated by or through, or which is s= tored on, its networks, applications, services, and devices.