RE: MyISAM index missing rows

2013-08-12 Thread Rick James
-Original Message- > From: Dolan Antenucci [mailto:antenucc...@gmail.com] > Sent: Monday, August 12, 2013 10:26 AM > To: mysql@lists.mysql.com > Subject: MyISAM index missing rows > > Hi Everyone, > > I have a MyISAM table with 25 billion rows (structure: score float&

MyISAM index missing rows

2013-08-12 Thread Dolan Antenucci
Hi Everyone, I have a MyISAM table with 25 billion rows (structure: ), and after I create an index on id1, certain rows can no longer be found. I've posted a detailed summary of my problem at dba.stackexchange.com, but haven't had success with finding a solution thus far. Here's the URL to that