MySQL Hidden Treasures

Location: Ballroom H Level: Intermediate

To reach those treasures, we’ll try to answer some cabalistics yet not to senseless questions ;
When are JOIN faster than a LIMIT?
Why anyone would make auto_increment columns to be non-unique?
How to spot the missing rows in a table?
Who can sort b, c, a and still use the ORDER BY clause?
How to break those long running queries into small ones?
What operations can treat lines in batch, with pure SQL?

During this session, we’ll see some lesser known features of MySQL, that were introduced in the server for good reasons, and that will solve even other problems. We’ll stay close with tables, columns and data, for the best of everyone.

Damien Seguy

Nexen Services

Damien Seguy is a founder of Nexen Services, the Open Source hosting company, where he leads the expert and architecture services for the LAMP stack.

Damien Seguy contribue to MySQL through documentation translation, advocacy and technical expertise. He shares his finding on and is author of ‘Securit√© PHP 5 et MySQL 5’ and speaks or co-organize conferences around the world.

  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.