MySQL Performance Workshop, September 22, Kiev

Sun Microsystems and i ∙ klass Education Center invite you to the MySQL Performance seminar.



Speaker:

Dmitry Kravchuk, Principal Benchmark Engineer, Sun Microsystems, Paris, France



Location:

Educational center i ∙ klass

Kiev, st. Mazepa, 34



Time spending:

September 22, 2009, 10:00 - 18:00

')

Visitor Registration:

If you want to attend this event, fill out the registration form .



Please register beforehand. On the day of the event registration and payment at the box office is possible, but we do not guarantee availability.



Cost of participation:

100 hryvnia



Discounts:

Those who fill out the form http://dou.wufoo.com/forms/-nn/ , will be sent a discount code -15%. The number of discount codes is limited.



The event is free for partners and certified professionals of Sun Microsystems.

Workshop Plan:

• MySQL history / development milestones
• MySQL Architecture overview
• MySQL Storage Engines (Pros / Cons):
  
  
  • MyISAM
  • InnoDB
  • NDB
  • PBXT
  • XtraDB
  • Falcon
  
  
  
• MySQL Bottlenecks:
  
  
  • Data model / design
  • Multi-threaded model
  • Storage engine
  • Internals
  • etc.
  
  
  
• MySQL Performance:
  
  
  • Solutions
  
  
  
• InnoDB Performance:
  
  
  • Bottlenecks
  • Internals
  • Google SMP patches
  • XtraDB
  • etc.
  
  
  
• MySQL 5.4
  
  
  • Improvements
  • Internals
  • I / O capacity
  • I / O threads
  • Thread concurrency model
  • Benchmark results
  • etc.
  
  
  
• Incoming InnoDB improvements:
  
  
  • Ahead flushing / Adaptive checkpoint
  • Purge lag
  • Splitted locks
  • Multiple rollbacks
  • etc.
  
  
  
• MySQL Performance Tuning:
  
  
  • Monitoring
  • Configuration
  • Best practices
  • DTrace
  • ZFS
  • etc.
  
  
  
• MySQL & dim_STAT
  
  
  • mysqlSTAT
  • innodbSTAT
  • innodbIO
  • mysqlLOAD
  
  
  
• Q & A

Visit event page .