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 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 http://www.nexen.net. and is author of ‘Securité PHP 5 et MySQL 5’ and speaks or co-organize conferences around the world.
View a complete list of MySQL contacts.