MySQL Forums
Forum List  »  Performance

Re: How do the enterprise web applications do it?
Posted by: James Day
Date: January 31, 2005 07:06PM

First step is to cover the things you have probably already done:

Are you using a my.cnf file to tall MySQL to use your RAM? Without one it's not going to perform very well because it's unlikely to keep much of the index in RAM and that's crucial for performance.

Are you warming the cache first? Initial loading of index nodes from disk is slow but once they are in RAM performance can be substantially faster. It can take many minutes to many hours to fully load/warm a cache, depending on the nature of the queries, the RAM involved and whether you're telling the server to load the index into RAM.

Have you used ANALYZE TABLE to update the query optimizer statistics? If you haven't it might incorrectly think that a full table scan is best.

Beyond that, providing specific example queries which work badly for you, and the results of EXPLAIN SELECT for them, are the way to go.

Options: ReplyQuote

Written By
Re: How do the enterprise web applications do it?
January 31, 2005 07:06PM

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.