Tech Presentations

I didn’t know that it’s possible to work with MySQL using Visual Studio. Apparently MySQL AB is developing a good integration tools for it, definitely targeting corporate markets.

See it on TechPresentations.org: Developing for .NET using Visual Studio

Tons of presentations from MySQL Conference and Expo 2007 (and more coming).

• Capacity planning for LAMP
• Developing High Performance Applications Using NDB/J
• Developing High Performance Applications Using NDBAPI
• Implementing Performant Databases for Multi-Play Service Architectures
• InnoDB Performance Optimization
• InnoDB performance potential in high-end environments
• Interconnect Matters for Scalability and Performance
• Lucene with MySQL
• MySQL Performance CookBook
• MySQL Server Settings Tuning
• MySQL for Oracle DBAs and Developers
• MySQL query optimizer internals and upcoming features in v5.2
• Scale-out Options with MySQL and Java
• Scaling the World’s Largest Photo Blogging Community
• The 7 Stages of Scaling Web Apps - Strategies for Architects

Google Talk by Jay Pipes on Performance tuning in MySQL (video). Given in many other places as well. Slides from different presentation available (PDF).

Google TechTalks presentation by Stewart Smith, MySQL AB (video) on April 28, 2006

Interesting quotes:

• Variable (really) size VARCHAR
• Significantly different and faster index add/drop (coming in 5.1)
• User defined cluster partitioning:
  • by key
  • by range (might not be in 5.1 but in future releases)
  • by list (future, not 5.1)
• Replicate one cluster to another cluster (note node-to-node replication)
• much more … really for MySQL powerusersDBAs and large setups.