Skip to content

Category Archives: mysql

Reflected SQL injection

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 [...]

Posted 23 July 2007 † Gareth Heyes § Security § php ‡ Comments (9)

PHP Mysql tips

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’)
(Fastest)
2.
SELECT * FROM table [...]

Posted 23 July 2007 † Gareth Heyes § php ‡ Comments (26)

Mysql performance tuning

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 current database [...]

Posted 15 February 2007 † Gareth Heyes § ‡ Comments (0)