Software Engineer

This a nice & short article: “Micro Optimizations That Matter” by Brandon Savage.

It’s like roadmap to optimize your web applications rather than the php code by itself, “micro” tricks that can definitely impact performance positively.

The best answers come from measurable data, don’t let the “I think that “, “I believe”, “IF…” drive your decisions when it comes to performance.

Where to look? Well, don’t try to reinvent the wheel, there are plenty of tools that can provide enough data so you can make informed decisions regarding mysql performance.

SQL Performance Tips: There is lack on benchmarks about most of the suggestions here, still, many of them are obvious and can help you about what to test.

How to profile a query in mysql: this is self explanatory

Using the New MySQL Query Profiler: SQL diagnostic tool that assists in the debugging and analysis of running SQL.

I’ve been using some tools for mysql administration (either web or desktop applications), the more used are:

1. phpmyAdmin: default web administrator in many bundle installations, useful, basic; not ajax-y which sometimes makes me feel like that’s a boring place to be.. kinda ugly too, Still backup function are easy to find and use.
2. turbodbadmin: nice web application with ajax all around, looks like a desktop applications and it is very efficient.
3. SQL Yog: desktop application, very easy to use when you try to copy a whole database from a server to another remotely.

Here you will find some other tools and overviews about them.