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 6. Diseño y gestión de esquemas
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
Un buen diseño lógico y físico es la piedra angular del alto rendimiento, y debes diseñar tu esquema para las consultas concretas que vayas a ejecutar. Esto a menudo implica compromisos. Por ejemplo, un esquema desnormalizado puede acelerar algunos tipos de consultas, pero ralentizar otros. Añadir contadores y tablas resumen es una buena forma de optimizar las consultas, pero su mantenimiento puede resultar costoso. Las características particulares de MySQL y los detalles de implementación influyen bastante en esto.
Del mismo modo, tu esquema evolucionará con el tiempo, como resultado de lo que aprendas sobre cómo almacenas y accedes a los datos, así como de cómo cambien con el tiempo tus requisitos empresariales. Esto significa que debes planificar los cambios de esquema como un acontecimiento frecuente. Más adelante, en este capítulo, te ayudaremos a evitar que esta actividad se convierta en un cuello de botella operativo para tu organización.
Este capítulo -y el siguiente, que se centra en la indexación- cubre las partes del diseño de esquemas específicas de MySQL. Suponemos que sabes diseñar bases de datos, así que éste no es un capítulo introductorio, ni siquiera avanzado, sobre el diseño de bases de datos. Como capítulo sobre el diseño de bases de datos MySQL, trata de lo que es diferente cuando se diseñan bases de ...
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.