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 4. Optimización del sistema operativo y del hardware
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
Tu servidor MySQL sólo puede funcionar tan bien como su eslabón más débil, y el sistema operativo y el hardware en el que se ejecuta suelen ser factores limitantes. El tamaño del disco, la memoria disponible y los recursos de la CPU, la red y los componentes que los conectan limitan la capacidad final del sistema. Por tanto, tienes que elegir el hardware con cuidado y configurar el hardware y el sistema operativo adecuadamente. Por ejemplo, si tu carga de trabajo está ligada a la E/S, un enfoque es diseñar tu aplicación para minimizar la carga de trabajo de E/S de MySQL. Sin embargo, a menudo es más inteligente actualizar el subsistema de E/S, instalar más memoria o reconfigurar los discos existentes. Si estás ejecutando en un entorno alojado en la nube, la información de este capítulo puede seguir siendo muy útil, especialmente para comprender las limitaciones del sistema de archivos y los programadores de E/S de Linux.
¿Qué limita el rendimiento de MySQL?
Muchos diferentes componentes de hardware pueden afectar al rendimiento de MySQL, pero el cuello de botella más frecuente que vemos es el agotamiento de la CPU. La saturación de la CPU puede ocurrir cuando MySQL intenta ejecutar demasiadas consultas en paralelo o cuando un número menor de consultas se ejecuta durante demasiado tiempo en la CPU.
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.