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
Read
4 Comments
31227 Visitors
31227 Views
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. 

Read
41 Comments
294345 Visitors
294345 Views

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.

Read
6145 Visitors
6145 Views

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.

Read
3 Comments
15901 Visitors
15901 Views

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.

Read
5098 Visitors
5098 Views

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. 

Read
5573 Visitors
5573 Views

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.


Read
1 Comments
15008 Visitors
15008 Views

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.

Read
4126 Visitors
4126 Views