WHITESITES BLOG PHOTOS PLACES POPULAR CATEGORIES

MySQL Programming Websites

How to Fix MySQL Error 10055

Sep 5, 2013 by Author

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
1521 Visitors
3048 Views
w3wp.exe using too much memory and resources

w3wp.exe using too much memory and resources

Oct 1, 2009 by Author

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
39 Comments
145417 Visitors
233044 Views

MySQL 5.1 dump files won't restore on MySQL 5.0

Dec 19, 2008 by Author

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
2064 Visitors
4083 Views

MySQL Got an error reading communication packets

Dec 10, 2008 by Author

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
5615 Visitors
9818 Views

SQL injection IP blacklist from the botnet

Aug 26, 2008 by Author

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
1268 Visitors
2466 Views

protecting against SQL injection attacks using querystring

Aug 15, 2008 by Author

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
1890 Visitors
3424 Views

Using Caching to make your ASP.NET website more scalable

Jul 3, 2008 by Author

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
5742 Visitors
9578 Views

How to find Slow MySQL queries and Optimize your Tables

Feb 12, 2008 by Author


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
1176 Visitors
2065 Views