How to find Slow MySQL queries and Optimize your Tables
Feb 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.
Feb 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.
| Read Full Blog | 0 Comments |
Stop Spam in SmarterMail with RBL SBL and BL
Feb 08, 2008 by Paul White
Once you get a VPS box from HostMySite and you are running your own mail server, the first thing you will notice is how much spam is getting through. This is because there are not advanced spam filters setup when Smartermail was installed on your VPS. So its time to take things into your own hands. Here is the list of RBL SBL BL servers I use to block 99% of all spam. It works so well I was able to cancel my account with postini.
Feb 08, 2008 by Paul White
Once you get a VPS box from HostMySite and you are running your own mail server, the first thing you will notice is how much spam is getting through. This is because there are not advanced spam filters setup when Smartermail was installed on your VPS. So its time to take things into your own hands. Here is the list of RBL SBL BL servers I use to block 99% of all spam. It works so well I was able to cancel my account with postini.
| Read Full Blog | 7 Comments |
Sony PS3 cures Cancer
Feb 06, 2008 by Paul White
Aside from making a dent in the productivity of millions. The PS3 is now helping to do medical research. A program called Folding at Home distributed by Standford University is now on your PS3 after you do the lastest system update. I have left my PS3 on for several days now, to help do my part.
Feb 06, 2008 by Paul White
Aside from making a dent in the productivity of millions. The PS3 is now helping to do medical research. A program called Folding at Home distributed by Standford University is now on your PS3 after you do the lastest system update. I have left my PS3 on for several days now, to help do my part.
| Read Full Blog | 0 Comments |
Time for blog 2.0
Feb 02, 2008 by Paul White
The SEO world was rocked in January when google changed the way it runs SERPS. They are basically cracking down on how people load keywords into their titles, and pages to increase their rank. I was going to recode my blog engine anyway to make it more efficient. Thanks to google my blog 2.0 engine is now a priority on my todo list.
Feb 02, 2008 by Paul White
The SEO world was rocked in January when google changed the way it runs SERPS. They are basically cracking down on how people load keywords into their titles, and pages to increase their rank. I was going to recode my blog engine anyway to make it more efficient. Thanks to google my blog 2.0 engine is now a priority on my todo list.
| Read Full Blog | 0 Comments |
| 1 | 2 |
| Home | Blogs | Photos | Places |