Re: Questions about performance for huge table (100M+ rows)

[Rick James]

Turn on the slowlog and report on what is interesting there.

If you are doing
SELECT * FROM WHERE name IS NOT NULL ORDER BY hits DESC LIMIT 100;
That will be a killer when there are 100M rows. It will scan the entire table, collecting everything, then sort it on "hits", then deliver 100 rows. Not a pretty sight. Please spell out the specific SELECTs (other than WHERE name = '...'); we need to concentrate on them.