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 far. Here's the URL to
As that post describes, one oddity is with an EXPLAIN I run on the same
query with indexes enabled vs. disabled. When disabled, "rows" = 25
billion; when enabled, "rows" = 170 million. Based on this, I'm wondering
if some restriction is causing only 170 million rows to index. (Of course,
I could be completely misinterpreting this EXPLAIN result).
Here is my server version: 5.5.31-0ubuntu0.12.04.2 (Ubuntu), which should
also be 64-bit (i've verified by running "file /usr/sbin/mysqld" (says "ELF
Any help is greatly appreciated! Just let me know if you need more details