Dave Stokes

Dave Stokes

Dave Stokes is a MySQL Community Manager for Oracle. Previously he was the MySQL Certification Manager for MySQL AB and SUN. He has worked for companies ranging alphabetically from the American Heart Association to Xerox and work ranging from Anti-submarine warfare to web developer. He is the author of MySQL & JSON - A Practical Programming Guide, now in it is in its second edition

Sessions Online 2021

MySQL 8.0 Update

Session en anglais - Débutant

MySQL 8.0 has a new release every three months and you may have missed new features that could impact you greatly. Such as hash joins, dual passwords, multi-valued indexes, JSON document validation, the Clone plugin, and more. Plus there are major changes in replication plus new utilities for backups. If you use MySQL and have not kept up to date with the latest releases you will be pleasantly surprised.

MySQL Histograms versus Indexes

Session en anglais - Débutant

Nobody complains when the database is too fast. Those in search of ever faster queries will use indexed to speed them. But indexes have overhead and improper understanding of their technology can actually make things slower. Histograms are another technique that can be useful but they do not work for all types of data. This session will cover which to use when and help you understand why each has its place in the MySQL optimizer.

Sessions Montréal 2020

Sessions Montréal 2019

Sessions Vancouver 2017

Sessions Montréal 2017

Sessions Vancouver 2016

Sessions Montréal 2012