Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Optimize MySQL

Discussion in 'Discusión en Español' started by icp77, Jun 5, 2014.

  1. icp77

    icp77 Member

    Joined:
    Mar 15, 2005
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    153
    cPanel Access Level:
    Root Administrator
    Buenas Noches,

    Solicito su apoyo en la configuración de mysql para optimizarla a traves del archivo mycnf, las caracteristicas del servidor son:

    AMD Procesador de 6 Nùcleos
    16 Gb de Ram

    Actualmente no tiene ninguna configuración optimizada.

    Gracias de nuevo.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,167
    Likes Received:
    1,933
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. icp77

    icp77 Member

    Joined:
    Mar 15, 2005
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    153
    cPanel Access Level:
    Root Administrator
    Re: Optimizar MySQL

    Buenos Días,

    gracias por esta guía la voy a revisar completa, para iniciar la optimización.

    Muchas Gracias
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Felipe M.

    Felipe M. Member

    Joined:
    Jun 6, 2014
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Re: Optimizar MySQL

    Hola

    También puedes usar mysqltuner y modificar las variables del archivo de configuración en tu MySQL, que por defecto está en /etc/my.cnf

    Saludos!
     
  5. icp77

    icp77 Member

    Joined:
    Mar 15, 2005
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    153
    cPanel Access Level:
    Root Administrator
    Re: Optimizar MySQL

    Hola,

    Gracias, si exactamente estoy en la optimización de los recursos de mysql, según la guía es la herramienta recomendada.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. icp77

    icp77 Member

    Joined:
    Mar 15, 2005
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    153
    cPanel Access Level:
    Root Administrator
    Re: Optimizar MySQL

    Buenos Días,

    Solicito su apoyo en la configuración de mysql para optimizarla a traves del archivo mycnf, las caracteristicas del servidor son:

    AMD Procesador de 8 Nùcleos

    16 Gb de Ram

    2 x 1.4 TB

    Actualmente no tiene ninguna configuración optimizada. talvez tienen un ejemplo de los parametros a cambiar.

    Gracias de nuevo.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,167
    Likes Received:
    1,933
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: Optimizar MySQL

    Hello,

    Please run the MySQL tuner and post the output here so that other users can add their feedback.

    Thank you.

    Translation:

    Hola,

    Por favor, ejecute el sintonizador de MySQL y Publicación de la salida de aquí a fin de que otros usuarios pueden agregar sus comentarios.

    Gracias.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. icp77

    icp77 Member

    Joined:
    Mar 15, 2005
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    153
    cPanel Access Level:
    Root Administrator
    Re: Optimizar MySQL

    Buenos Días,

    revisando la información, me encontre con que mySqlTuner no se recomienda para MySQL 5.5 y versiones posteriores. Estás a salvo en 5.1.

    Encontre la siguiente información del desarrollador, que indica que se puede usar en la versión MySQL 5.5:

    http://mysqlmymon.com/performance_schema.html

    cPanel Version 11.46.0 (build 21)
    Apache Version 2.4.10
    PHP Version 5.5.16
    MySQL Version 5.5.40-cll ---- Versión Actual
    Architecture x86_64
    Operating System linux

    Gracias por sus comentarios.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 icp77, Dec 5, 2014
    Last edited: Dec 5, 2014
  9. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,167
    Likes Received:
    1,933
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice