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 that post: http://dba.stackexchange.com/questions/47906/mysql-myisam-index-causes-query-to-match-no-rows-indexes-disabled-rows-match
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 64 bit..")
Any help is greatly appreciated! Just let me know if you need more details
Sincerely,
Dolan Antenucci
Aug 12
Rick James RE: MyISAM index missing rows
Aug 12, 2013; 19:53
Rick James
RE: MyISAM index missing rows
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!