Turn down the lights
Turn up the lights
Watch this video in a new window

Performance Tuning Best Practices for MySQL

Channel Icon
Partner Video
googletechtalks
October 08, 2007
Google TechTalks April 28, 2006 Jay Pipes Jay Pipes is a co-author of the recently published Pro MySQL (Apress, 2005), which covers all of the newest MySQL 5 features, as well as in-depth discussi...
Google TechTalks
April 28, 2006

Jay Pipes
Jay Pipes is a co-author of the recently published Pro MySQL (Apress, 2005), which covers all of the newest MySQL 5 features, as well as in-depth discussion and analysis of the MySQL server architecture, storage engines, transaction procesing, benchmarking, and advanced SQL scenarios. You can also see his name on articles appearing in Linux Magazine and can read more articles about MySQL at his website. ABSTRACT
Learn where to best focus your attention when tuning the performance of your applications and database servers, and how to effectively find the "low hanging fruit" on the tree of bottlenecks. It's not rocket science, but with a bit of acquired...
Category:  Howto & Style
Tags: 
Customize
25 ratings
11,365 views
Flag
Statistics & Data
Loading...
Post a Video Response
Video Responses (0)
This video has no Responses. Be the first to Post a Video Response.
Post a Text Comment
Text Comments (4)  Options
Loading...
fisher041082 (1 month ago) Show Hide
 0
Marked as spam
very much detailed and helpful....
C7B27D7B4 (8 months ago) Show Hide
 0
Marked as spam
i love the fact that the top three categories of performance issues are all related to the SQL code (DML & DDL) which is used to build and query the database; this has always been my experience; if properly programmed, even an unscalable server (MsAccess, SQLite, dBase, ...) can be pushed to its theoretical limit of performance; if poorly programmed, even a scalable server (Oracle, MsSqlServer, Sybase, ...) can bog down and become unresponsive;
aloktherocker (1 year ago) Show Hide
 0
Marked as spam
Very informative...thanks
suyuIdareliHarca (1 year ago) Show Hide
 0
Marked as spam
Wow, thanks guys :)
Post a Video Response

Comment on this video


Remaining character count:


Web annotations