addressalign-toparrow-leftarrow-leftarrow-right-10x10arrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcredit-cardcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobe--smallglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1languagelaunch-new-window--smalllight-bulblightning-boltlinklocation-pinlockm-swarmSearchmailmediummessagesminusmobilemoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstar-shapestartickettrashtriangle-downtriangle-uptwitteruserwarningyahooyoutube

Message boards will no longer be available after July 18, 2024.

We recommend saving any important information beforehand. Going forward, you can stay connected with your groups using the Discussions feature (we'll be rolling out some exciting updates soon)!

Learn more about the upcoming changes in this article;

HD 720p video (& presentation slides) of Percona Expert Morgan Tocker presenting MySQL Performance Tuning & 3rd Party Patches to the NYC MySQL Group at Sun Microsystems

From: Eric David B.
Sent on: Monday, 9 November 2009, 5:46 am

Morgan Tocker is Director of Training at Percona where he provides world famous scaling advice to Web 2.0 and Fortune 100 clients. He is a regular presenter on PHP and MySQL, having spoken at conferences such as PHP Quebec, the MySQL Conference, PHP-Tek, PHP-works and International PHP Conference.

Prior to Percona, Morgan worked at MySQL AB (acquired by Sun Microsystems) as a Support Engineer and Technical Instructor teaching courses in Database Administration, High Availability and Performance Tuning.

HD720p video (24fps)

http://www.LeadIT.us/hands-on-tech/Quick-Wins-Performance-Tuning-3rd-Party-Patches-for-MySQL

Please share with others the knowledge gained from this exceptional presentation by Tweeting about this video on Twitter (click-> http://vork.us/go/dfq6 ), posting to your Facebook profile: http://vork.us/go/dpw7 and sharing on LinkedIn: http://vork.us/go/dsvx

Some of the topics that Morgan tackles are:

  • Discovering performance bottlenecks
  • Optimization vs. adding hardware
  • Tuning InnoDB/XtraDB indexes
  • MySQL caching and configuration
  • How to analyze what MySQL is doing under the hood of each query
  • MySQL 3rd Party Patches
  • Finding dead-indexes

Some of the topics covered in Q&A are:

  • MySQL forks and branches
  • Future InnoDB inhancements
  • Statistics generation
  • MySQL vs. MS SQL Server
  • Administration tools for MySQL
  • Dual-Master replication and update patching
  • Real-world high-availability plans

People in this
group are also in: