Apr 22, 2022 to Apr 24, 2022
USA
David Stokes (Technical Evangelist, Percona) will be presenting 2 of his talks at LinuxFest Northwest on April 22 – 24, 2022.
Nobody complains that that database is too fast. But when things get slow, wow do they complain. The two easiest (and most productive) ways to increase query speed are indexes and histograms. But there is a lot of bad/old information and superstition clouding the information on how to add indexes. This talk will cover what your indexing options are (and there are many), how they really work, why you need a PRIMARY KEY, and more. Histograms help speed queries too, but they are best for data with a low churn rate, and you will see how they can help the query optimizer do its work. So if your database is already too fast, this is not the session for you. But if you need faster queries, then you know which session you need to attend!
MySQL 8.0 has a lot of new features and four times a year updates are made available. There are a lot of powerful new features, but do you know how to take advantage of hash joins, invisible columns or indexes, dual passwords, JSON document validation, new backup utilities, or new locking options? This session will cover many of the new changes so that you can get more out of your MySQL instances.
About the event.
LinuxFest Northwest is an annual open-source event co-produced by Bellingham Linux Users Group and the Information Technology department at BTC. LFNW features presentations and exhibits on free and open source topics, as well as Linux distributions & applications, InfoSec, and privacy; something for everyone from the novice to the professional! LFNW22 will be conducted virtually this year.
