| |
How to find Slow MySQL queries and Optimize your TablesFeb 12, 2008 by Paul White
After you see good growth in your site for months, suddenly things start to get slow. If your site is driven by a MySQL database, this is most likely the problem. Bandwidth, Transfer, or even your home internet connection is not the problem. The problem is you have some slow queries driving your site. When I say slow we are talking computer terms. Slow could be a fast as 15 ms. One slow query isn't the problem its when you get hundreds of slow queries made by hundreds of users at the same time that it becomes a problem. MySQL is very powerful but only if you create the right indexes. I recently applied these techniques on one of my websites. Here is the step by step guide ( by me ) on how to optimize your MySQL tables. If your ASP.NET site is dragging this can make it 10 times faster.
|
|
|