FOSDEM '09 is a free and non-commercial event organized by the community, for the community. Its goal is to provide Free and Open Source developers a place to meet.

Giuseppe Maxia
Day Sunday
Room AW1.126
Start time 15:00
End time 16:00
Duration 01:00
Event type Podium
Track MySQL
Language English
Boost performance with MySQL 5.1 partitions

MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. This session explains the benefits of partitioning and shows in practice how to take advantage of its features.

Topics include:

  • Benefits and limits of partitioning
  • Understanding the partitioning types (RANGE, LIST, HASH and KEY)
  • Partitioning pruning and EXPLAIN additions
  • Benchmarking partitions
  • How to partition by dates
  • Partitioning with MyISAM tables
  • Partitioning with InnoDB tables
  • Partitioning with Archive tables
  • Use cases
  • Partition maintenance:
    • converting partitioned tables to normal ones;
    • adding and dropping partitions
    • reorganizing partitions
    • checking and repairing partitions

Other events at the same time:

When Event Track Where
14:00-16:00 Mozilla Marketing Café Mozilla AW1.105
14:30-15:15 Xfce as a Platform CrossDesktop H.1301
14:45-15:30 Architecture of Collaboration openSUSE H.2214
14:45-15:15 JNode Free Java AW1.125
14:45-15:30 Drupal Showcase: Cultural Activities in Flanders Drupal H.1302
14:45-15:15 Ruby and Java: What are the differences? Ruby and Rails AW1.120
14:45-15:30 Mobile/Fennec Mozilla H.1308
15:00-16:00 Easy Integration with plugin frameworks for open source Zarafa Groupware and advanced replication Collaboration Chavanne
15:00-16:00 Ext4 Kernel Janson
15:00-15:15 PyRoom - distraction free writing Lightning Talks Ferrer
15:00-16:30 LPI exam session 5 LPI Certification Guillissen
15:00-16:00 GNATBench: Ada programming with Eclipse Ada AW1.124
15:00-16:00 Cobbler & Koan Fedora+CentOS H.2213
15:00-16:00 LLVM + Gallium 3D: Mixing a compiler with a graphics framework H.1309
15:00-16:00 The long road to KDE4 in Debian Debian AW1.121
15:00-16:30 Emdebian 1.0 release - small & super small Debian Embedded Lameere
15:00-16:00 Filesystem I/O From a Database Perspective BSD+PostgreSQL UA2.114
15:15-15:30 Putting Apache Solr to work: eZ Find, a powerful eZ Publish search plugin Lightning Talks Ferrer
15:15-16:00 Why logs are important CrossDesktop H.1301
15:15-15:30 Zero/Shark Free Java AW1.125
15:30-15:45 The XWiki Wysiwyg Editor: Rich Cross-Browser Editing, Take Two Lightning Talks Ferrer
15:30-16:15 Bits from your GNOME team (with build service fun inside!) openSUSE H.2214
15:30-16:15 Automated Web Translation Workflow for Multilingual Drupal Sites Drupal H.1302
15:30-16:15 Embedding Mozilla H.1308
15:30-16:15 Internationalization in Rails 2.2 Ruby and Rails AW1.120
15:45-16:00 Recruiting people to FOSS Java projects Free Java AW1.125