[BiO BB] Fwd: MySQL performance tuning

[Pete Marchetto]

Pete Marchetto
Staff Scientist
SoftGenetics, LLC
http://softgenetics.com/

Begin forwarded message:

> Date: July 26, 2008 4:11:35 PM EDT
> Subject: MySQL performance tuning
> Source: Hackszine.com
> Author: Jason Striegel
>
> Jay Pipes, MySQL employee and co-author Pro MySQL, gave a great  
> presentation to Google employees which covers a number of techniques  
> for tuning performance on MySQL. His examples include debugging and  
> analyzing problems as well as best practices for table and index  
> design, query and join operations, and server variable adjustments.
>
> It's a little over 40 minutes long, but incredibly informative,  
> whether you're a casual querier or a power MySQL user. Though some  
> of this stuff is MySQL (or MyISAM or InnoDB) specific, the majority  
> of the content is essential material for the average database  
> application developer.
>
> If you don't have time to sit through it (shame on you) or you're  
> looking to jump right to a specific topic, there's a nice time-coded  
> dissection of the talk over at Peteris Krumins' blog. There's  
> something so appropriate about adding a search index to a video  
> about MySQL optimization.
>
> Performance Tuning Best Practices for MySQL
> Video Index
>
> Read more…
>