I’ve been developing a system for a while now and it’s currently in the testing stage, I noticed that a SQL injection vulnerability had crept in. I was quite surprised because my filtering methods are generally quite good and I’ve not seen any SQL errors in the logs for quite some time. Luckly the site […]

Continuing from my earlier post on PHP performance, I thought I’d share a few Mysql tips that I’ve learnt over the years. Hope it helps someone and please leave a comment with your own tips or provide any corrections to the ones mentioned. Word searching 1. SELECT * FROM table WHERE MATCH (`field`) AGAINST (‘Keyword’) […]

Mysql Caching I’ve been modifying a large insurance database system recently for a big client and I have encountered a few performance problems with mysql. I have been messing around with my.cnf for quite a while and I think I’ve been able to significantly increase performance of repeated queries. Now the problem is that the […]