Something Awesome is coming your way. This post says about the basic architecture of MySQL and its internals.