Very concrete and easy-to-follow examples
http://hackmysql.com/documents
and also this one
http://20bits.com/articles/10-tips-for-optimizing-mysql-queries-that-dont-suck/
and
helpful blog post on getting Zend Debugger installed on server
http://paulslinuxbox.net/blog/linux/php-zend-debugger-eclipse
and another:
Since the Aptana SFTP plugin isn't very good, I've switched to this one:
http://www.jcraft.com/eclipse-sftp/
using the eclipse plugin location as:
Amazing time lapse or open source projects - gotta see it to believe it:
I came across this very interesting project:
http://www.dangermouse.net/esoteric/piet/samples.html
Makes for some interesting debuggin I bet :)