Monthly Archives: October 2009

Installing Facebook Open Platform on Fedora 8

This is a step by step I wrote ages ago whilst installing Facebook Open Platform on Fedora 8. I did the FBOP working in the end, although found little to no use for it – there were parts missing (mainly the fbml form parser) so I couldn’t get it set up to create a local facebook testing environment, which is what I wanted to do. I haven’t developed a Facebook App for a while, so I’m not sure if they’ve made any ground releasing a more complete version of the open platform.
Continue reading

Efficiently Truncate InnoDB Tables

I was sent a great article today on performance tuning for MySQL’s InnoDB Storage Engine.

I thought the last point was particularly interesting – I always thought that a TRUNCATE TABLE was always better than a DELETE FROM as it can just drop all the data without looking at each individual row – apparently that’s not the case and they’re pretty much equivalent for InnoDB.
Continue reading