StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>One thing that can have a huge impact is how you allocate memory to MySQL for you given usage pattern.</p> <p>The relative size of your query cache, innodb buffer, etc should be tuned for your specific needs.</p> <p>Here are a few links that helped me resolve the same type of issue.</p> <p><a href="http://www.linux-mag.com/id/924" rel="nofollow noreferrer">MySQL Server Performance</a> (requires free registration)</p> <p><a href="https://web.archive.org/web/1/http://blogs.techrepublic%2ecom%2ecom/opensource/?p=56" rel="nofollow noreferrer">10 MySQL Variables that You Should Monitor</a></p> <p><a href="https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-5211760.html?tag=rbxccnbtr1" rel="nofollow noreferrer">Understanding Performance Statistics</a></p> <p><a href="http://blog.mysqltuner.com/" rel="nofollow noreferrer">MySQLTuner</a> is a great (free) tuning diagnosis tool written perl.</p> <p>Make sure you have enabled the slow query log and review it periodically. As your data volume grows, things that used to be fast will be slow. After you re-tune your memory parameters, fast queries can also become slow and vice versa as you shift resources from one type of query to another.</p> <p>Even though your queries look good to you, make sure and run the Explain command to verify that the indexes are being used.</p> <p>Additionally I purchased MySQL Enterprise from Sun and find their included performance monitor and query analyzer very useful.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload