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 .