WhiteSites Blog

How to Fix MySQL Error 10055

Sep 5, 2013 by Paul White

This error recently caused me some stress.  However I found a solution.  If you are running MySQL Server on a Windows Box, I am pretty sure i have the solution for you.  So if your web server is kicking out errors like this

ERROR HY000 MySQLODBC 5.1 DriverCan't connect to MySQL server on 'localhost' (10055) ERROR HY000 MySQLODBC 5.1 DriverCan't connect to MySQL server on 'localhost' (10055)

Read this for the solution
31681 Visitors
w3wp.exe using too much memory and resources

w3wp.exe using too much memory and resources

Oct 1, 2009 by Paul White

If you are having problems with the w3wp.exe process using too much memory, I have the solution to your problems.  Not only will this reduce the size of your w3wp.exe but it will also speed up your website and reduce the amount of transfer your site uses. 

294483 Visitors

MySQL 5.1 dump files won't restore on MySQL 5.0

Dec 19, 2008 by Paul White

MySQL DB serverIf you are using MySQL 5.1 ( the latest and greatest stable version as of this posting ) then you are sure to learn the hard way that the dump files from a MySQL 5.1 DB do not restore to a MySQL 5.0 installation.  Of course when you go to MySQL's website they don't give you a very straight forward answer.  Her is the easy fix for this issue.

6177 Visitors

MySQL Got an error reading communication packets

Dec 10, 2008 by Paul White

Aborted Connection to db. If you have ever had this little error in MySql and asp.net, you have most likely spent countless hours googling for an answer.  I have your answer read more the solution.

15989 Visitors

SQL injection IP blacklist from the botnet

Aug 26, 2008 by Paul White

The BotNet seems to be growing faster than ever.  I have included a list of all the IPs, I have caught attempting SQL injection via querystring.  If you have your own blacklist, feel free to add these to your list.

5133 Visitors

protecting against SQL injection attacks using querystring

Aug 15, 2008 by Paul White

If you run a website that is based on SQL, or MySQL. This is a must read.  Some of my websites recently have been under attack by bots that are trying a new method of SQL injection attack. 

5613 Visitors

Using Caching to make your ASP.NET website more scalable

Jul 3, 2008 by Paul White

If you make dozens of SQL queries within a single webpage this is not the most scalable way to build a website.  ASP.NET supports Caching, allowing you to store information directly in the server's memory.  Here I give you a little information on caching and how to use it to make your websites load faster.

15081 Visitors

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.

4162 Visitors