Skip to main content
Share Your Experience: Take the 2024 Developer Survey
2 votes
Accepted

are my expectations for mysql unrealistic?

Q: What does the query plan show? A: Use EXPLAIN ANALYZE to see. My guess is it's scanning a large portion of, if not the entire table to locate your data. This is because of the following issues: ...
J.D.'s user avatar
  • 37.8k
1 vote

are my expectations for mysql unrealistic?

Assuming column "delta" is randomly distributed, your query is selecting 100k random rows out of the 400M row table. There is an index on delta, but it will still have to read 100k randomly ...
bobflux's user avatar
  • 1,511
1 vote

are my expectations for mysql unrealistic?

General remarks: Where is your PRIMARY KEY? It looks to me as if this data is immutable? By that I mean a given call is a matter of historical record rather than being subject to multiple updates? ...
Vérace's user avatar
  • 30.1k
1 vote

are my expectations for mysql unrealistic?

That query will probably use INDEX(delta), which you have. It will be performed as follows (pseudo-code): 1. Reach into the B+Tree of INDEX(delta) to find 0.4 (fast) 2. Scan forward until 0.6. 2a. ...
Rick James's user avatar
  • 78.4k

Only top scored, non community-wiki answers of a minimum length are eligible