MyISAM index missing rows

2013-08-12 Thread Dolan Antenucci
Hi Everyone, I have a MyISAM table with 25 billion rows (structure: id1 int, id2 int, score float), 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

RE: MyISAM index missing rows

2013-08-12 Thread Rick James
- 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: id1 int, id2 int, score float), and after I create an index