Andrew Gatenby

Increase max_connections in MySQL

This is a really quick “howto” guide based on experience in the office, where we had pages and queries that were unable to run properly, purely because of the number of queries that we were trying to pass to MySQL at once.

Read the rest of this entry »

10 Things you can do with Robots.txt for SEO

Robots.txt is a very useful and underutilised tool that allows web designers to control how their site handles spiders from search engines. The majority of search engine spiders take robots.txt and will parse the instructions prior to indexing a website.

Using robots.txt you can ensure that spiders only index certain parts of your website, and you can further specify as to which spiders are allowed to do so, and what pages they index.

Read the rest of this entry »

Prevent Image Hotlinking via .htaccess

Hotlinking to images on another domain is something that is frowned upon. Leeching other peoples bandwidth isn’t a polite thing to do, so if you find someone hotlinking images from your site, what can you do?

Well, you can edit your .htaccess file and have a little fun with them!

Read the rest of this entry »