MySQL Forums
Forum List  »  Performance

Re: Questions about performance for huge table (100M+ rows)
Posted by: Rick James
Date: January 04, 2009 07:35PM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.