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
1678 Visitors
3298 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
146658 Visitors
235351 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
2087 Visitors
4122 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
5688 Visitors
9966 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
1288 Visitors
2506 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
1912 Visitors
3463 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
5827 Visitors
9743 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
1199 Visitors
2102 Views