Jaime Crespo

Jaime Crespo

Jaime Crespo

Sr Database Administrator, Wikimedia Foundation

Biography:

Jaime is the Senior DBA of the Wikimedia Foundation, managing Wikipedia databases.


All Sessions

TLS for MySQL at large scale

At the Wikimedia Foundation, we aim for perfect privacy of our users. That means not only enforcing TLS (https) between our users and the datacenters but all intermediate steps, including database access.

When you are a top 5 website with hundreds of thousands of queries per second and billions of users but a very limited budget, that is not easy, especially for MySQL. This is a description of our experience, including operational and performance pain points, of rolling out encryption.

We also talk about what has changed in the ecosystem since the introduction of MySQL 8.0 and MariaDB 10.3.

Query Optimization with MySQL 8.0 and MariaDB 10.3: The Basics

Tutorial on the foundations of query optimization to speed up query execution with MySQL 8.0 and MariaDB 10.3:

* Example database and environment setup
* Query profiling (what queries to optimize first?)
* Access types and basic indexing
- How indexes work to speed-up queries
- BTREE indexes
- EXPLAIN
- InnoDB peculiarities
* Multi-column indexing
- Column order
- Index condition pushdown
- Index_merge
* FULLTEXT indexing
* Join execution and optimization
- Nested-loop
- Other strategies and variants: MRR and hash joins
* Subquery issues
- Issues with subqueries in older versions
- Semi-Join execution and other optimizations

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863