You are here

Advanced MySQL Developer Workshop

Workshop topics

Duration: 3 days, Exercises
  • Partitioning
    • Partitioning by time (temporal data)
    • Optimizer and Partitioning
    • Limitations
    • New 5.5 and 5.6 features of Partitioning
  • InnoDB Architecture
    • Clustered PK
    • InnoDB Internals
    • InnoDB Online features
    • New Performance Features in 5.5 and 5.6
    • Operations of InnoDB
  • Performance Tuning and Benchmarking
    • Basics, Latency and Throughput
    • Profiling
    • Benchmarking
    • Benchmarking Tools
  • Memcached
    • Caching strategies
    • Operations
    • ding
  • HA and replication solutions
    • Replication
    • Scale-Out
    • DRBD
  • Blob streaming engine
  • Handler Socket and Memcached-API