blog’s amazing Rotating Header Image

Posts under ‘performance’

MySQL – limitations you never heard of

We all know MySQL has its limits – it works fine in general, but has its weaknesses too. The authors of MySQL Performance blog started a miniseries about such limitations for experienced users. Okay, I guess you know there’s no way to create fulltext index on InnoDB tables – but bid you know, that MySQL [...]

HipHop for PHP – the buzz summary you should really read

HipHop for PHP from Facebook hit the streets several days ago resulting in dozens of posts about the technology. Let’s see what the PHP community says:

Marco Tabini enlists the HipHop features and encourages using it
the echolibre blog talks about possible security/buffer overflow implications, and mentions similar available solutions
Ilia Alshanetsky provides an excellent and thorough overview: [...]

Google Closure: How not to write JavaScript

Dmitry Baranovskiy, the creator of the Raphaël and gRaphaël JavaScript libraries has serious criticism against the Google Closure JS library.
According to Dmitry:

“It’s a JavaScript library written by Java developers who clearly don’t get JavaScript.”
poorly optimized loops and unoptimized switch statements
memory caching with unlimited size: “I’m not sure what this pattern is called in Java, but [...]

“Micro” Optimizations That Matter

Brandon Savage compiled a good summary of application performance tips. Definitely not the difference between using single and double quotes in your code: these are easy to implement and effective (=”micro”) methods to improve responsiveness of your code, like:

Caching
Eliminate Any Sort Of Logged Errors
Enable Output Buffering For Everything
Make Use Of A Content-Delivery Network
Determine What Data [...]

Watch out for your CRON jobs

Running CRON jobs is not an easy task if you want to do it perfectly: fortunately we’re doing it similarly as it’s recommended by the Percona guys:
- prevent running multiple copies using file locks
- watch for errors
- store historical run times (use logging)
Further details and code sample in Watch out for your CRON jobs at [...]