Re: data loss due to misconfiguration

2013-02-26 Thread shawn green
Hello Zachary, On 2/26/2013 4:42 PM, Zachary Stern wrote: Any idea what can cause this? Can it be misconfiguration? Could it be because I'm messing with MySQL's memory usage so much, or the thread settings? My config is linked at the bottom, for reference. I might be doing something terribly du

Re: data loss due to misconfiguration

2013-02-26 Thread Reindl Harald
Am 26.02.2013 22:16, schrieb Zachary Stern: > It's InnoDB but it's not just about the number of rows. > > The data literally isn't there. It's like rows at the end are being > dropped. We have a frontend that queries and shows the data, but it ends up > missing results. > > I've asked the devs

RE: data loss due to misconfiguration

2013-02-26 Thread Stillman, Benjamin
e.com] Sent: Tuesday, February 26, 2013 5:11 PM To: mysql@lists.mysql.com Subject: Re: data loss due to misconfiguration Hello Zachary, On 2/26/2013 4:42 PM, Zachary Stern wrote: > Any idea what can cause this? Can it be misconfiguration? Could it be > because I'm messing with My

Re: data loss due to misconfiguration

2013-02-26 Thread Zachary Stern
Any idea what can cause this? Can it be misconfiguration? Could it be because I'm messing with MySQL's memory usage so much, or the thread settings? My config is linked at the bottom, for reference. I might be doing something terribly dumb. The stuff I've done under "# * Fine Tuning" worries me t

Re: data loss due to misconfiguration

2013-02-26 Thread Zachary Stern
quot; in row count as SHOW TABLE STATUS > for InnoDB. > > > -Original Message- > > From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com] > > Sent: Tuesday, February 26, 2013 11:04 AM > > To: Zachary Stern; mysql@lists.mysql.com > > Subject: RE: dat

RE: data loss due to misconfiguration

2013-02-26 Thread Rick James
ands.com] > Sent: Tuesday, February 26, 2013 11:04 AM > To: Zachary Stern; mysql@lists.mysql.com > Subject: RE: data loss due to misconfiguration > > Are you actually querying the table (select count(*) from table_name), > or just the stats (show table status)? Is the table Innodb

RE: data loss due to misconfiguration

2013-02-26 Thread Stillman, Benjamin
ent: Tuesday, February 26, 2013 12:42 PM To: mysql@lists.mysql.com 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

data loss due to misconfiguration

2013-02-26 Thread Zachary Stern
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 mig