As mentioned in a previous post we love HAproxy at Pixl8 its the handy penknife we use for high availability solutions.

Open Bluedragon ?

I thought I'd share some information on one of the technologies we use for our larger sites HAProxy.

Thought this was worth blogging as it's a real gotcha in .NET. Like PHP there is a default file size specified which you need to tweak to allow big file uploads. Unlike PHP, .NET fails silently and also doesn't point out the other settings which need tweaking like request size.

I've been looking at analysing sql server query usage and have used SQL profiler to ascertain long running queries and generally log interaction with the DB.

Dissecting a database again the joys of trying to work out what talks to what.

I was reviewing a SQL Server database application the other day which had 100s of tables many of which I was pretty sure were not being used with the absence of any documentation i needed a way of listing all the tables and then finding out whether or not they contained data.

Trouble shooting some bung code I came across a weird one today. This highlights the need to scope variables.

We had a problem recently with slow connections to a MySQL 5 database on linux. The symptoms were that for the first connection from the client (cfmx /bluedragon/query tool) the response from the MySQL server would be very slow up to 15secs. Then after that the reponse was quick (This was actually a bit random under load with connection pooling).