October 2024
Intermediate to advanced
974 pages
27h 14m
Spanish
Content preview from Libro de cocina de MySQL, 4ª ediciónBecome 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 22. Administración del servidor
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
22.0 Introducción
Este capítulo explica cómo realizar las operaciones necesarias para administrar un servidor MySQL en :
Configuración general del servidor
La interfaz del plug-in
Controlar el registro del servidor
Configurar motores de almacenamiento
El capítulo no cubre la gestión de cuentas de usuario MySQL. Esa es una tarea administrativa y se trata en el Capítulo 24.
Nota
Muchas de las técnicas que se muestran aquí requieren acceso administrativo, como la capacidad de modificar tablas en la base de datos del sistema mysql o utilizar sentencias que requieren el privilegio SUPER. Por este motivo, para realizar las operaciones que aquí se describen, es probable que necesites conectarte al servidor como rooten lugar de como cbuser.
22.1 Configurar el servidor
Problema
Quieres cambiar la configuración del servidor y también verificar que tus cambiossurtieron efecto.
Solución
Para cambiar los ajustes, especifícalos al iniciar el servidor o en tiempo de ejecución. Para verificar los cambios, examina las variables relevantes del sistema en tiempo de ejecución.
Debate
El servidor MySQL pone muchos parámetros de configuración bajo tu control. Por ejemplo, los recursos que requieren memoria pueden ajustarse hacia arriba o hacia abajo para adaptar el uso de los recursos. Un servidor muy utilizado requiere más memoria; uno poco utilizado, menos. ...
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.