PUBLIC MARKS from mbertier with tags performance & "groupe:clever age"

I gave a tutorial at OSCON last week on tuning MySQL queries, the EXPLAIN statement, the optimizer, and benchmarking. I've gone ahead and put the tutorial materials online now:

talks about current state behavior and performance properties of Innodb, Falcon, PBXT and SolidDB Storage Engines

I was trying to improve performance for a web application recently keeping them in mind. Let me describe how to do some of them technically.

Yahoo!'s Exceptional Performance team evangelizes best practices for improving web performance. They conduct research, build tools, write articles and blogs, and speak at conferences. Their best practices center around the rules for high performance web sites.

In this article, we're going to go through the entire process of installing, configuring and testing DRBD, Heartbeat and MySQL running in a 2 node cluster environment. This will be a bare bones configuration, best practices and security will take a back seat while we learn how all the different pieces work together.

WEDJE is similar to the innerHTML method above except it creates what is effectively a cross-platform, cross-browser defer, enabling your script to load and execute asynchronously across all environments.

Minify attempts to fix this problem by combining multiple CSS or JavaScript files into one download. By default, it also removes comments and unnecessary whitespace to decrease the amount of data that must be sent to the browser. Most importantly, it does all of this on the fly and requires only a few simple changes to your existing web pages.

Zend_Memory is a component that offers API for managing data in limited memory mode.

I have given a number of presentations, both at conferences and internally at various jobs. Where possible I've made available both the presentations themselves as well as written notes available.

The Important Link between Performance and Physical Database Design