September 2024
Intermediate to advanced
388 pages
12h 42m
Spanish
Content preview from MySQL de Alto Rendimiento, 4ª Edición
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capítulo 7. Indexación de alto rendimiento
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
Los índices (también llamados claves en MySQL) son estructuras de datos que los motores de almacenamiento utilizan para encontrar filas rápidamente. También tienen otras propiedades beneficiosas que exploraremos en este capítulo.
Índices son fundamentales para un buen rendimiento y adquieren mayor importancia a medida que tus datos aumentan de tamaño. Las bases de datos pequeñas y poco cargadas suelen funcionar bien incluso sin índices adecuados, pero a medida que el conjunto de datos crece, el rendimiento puede caer muy rápidamente.1 Por desgracia, los índices suelen olvidarse o malinterpretarse, por lo que una indexación deficiente es una de las principales causas de problemas de rendimiento en el mundo real. Por eso hemos colocado este material al principio del libro, incluso antes que nuestra discusión sobre la optimización de consultas.
La optimización de los índices es quizá la forma más potente de mejorar el rendimiento de las consultas. Los índices pueden mejorar el rendimiento en muchos órdenes de magnitud, y los índices óptimos a veces pueden aumentar el rendimiento unos dos órdenes de magnitud más que los índices que son simplemente "buenos". Crear índices realmente óptimos a menudo requerirá que reescribas las consultas, por lo que este capítulo y el siguiente están estrechamente relacionados.
Este capítulo ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.