The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problema de memoria en mysql

Discussion in 'Discusión en Español' started by fvillela, Dec 11, 2012.

  1. fvillela

    fvillela Registered

    Joined:
    Dec 11, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hola tengo el siguiente error:

    Your MySQL server is configured to use less than 64 megabytes of physical RAM, which may cause you to experience slow performance.

    Please consider raising this amount in your server's my.cnf file, or ask your system administrator or ISP to do so for you. The variable which must be increased is innodb_buffer_pool_size, and ideally should be half of all the physical RAM your server has installed. (Example: innodb_buffer_pool_size=1G)


    Alguien sabe como puedo cambiar esto mediante ssh con explicación paso a paso seria de mucha ayuda.

    Muchas gracias a la persona que me pueda asesorar en esto.
     
  2. nibb

    nibb Well-Known Member

    Joined:
    Mar 22, 2008
    Messages:
    301
    Likes Received:
    1
    Trophy Points:
    18
    La configuración mysql la puedes encontrar en
    /etc/my.cnf

    Lo que te indica el error es que MySQL esta configurado para utilizar menos de 64 MB ram.

    Dudo mucho que te funcione con tan poca memoria, siendo que MySQL necesita exactamente, eso mucha memoria.

    Debes editar la configuración my.cnf para utilizar mas memoria y no olvides reiniciar el servicio luego de ajustar los valores.
     
  3. speckados

    speckados Well-Known Member

    Joined:
    May 21, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Acequias :: Granada :: España
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Indica que memoria tienes, si vas a usar innodb, si tienes tablas de +1Gb y podemos ayudarte con un my.cnf adecuado.
     
  4. capoinfra

    capoinfra Well-Known Member

    Joined:
    Oct 25, 2007
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Uruguay
  5. guarderiamadrid

    guarderiamadrid Registered

    Joined:
    Jan 28, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    hola, gestiono el sitio - link removed-

    Me esta pasando el mismo error, y estoy un poco desesperado, la verdad. lo del mysql tuner no me funciona. ayuda!!!
     
    #5 guarderiamadrid, Jan 28, 2013
    Last edited by a moderator: Jan 28, 2013
  6. capoinfra

    capoinfra Well-Known Member

    Joined:
    Oct 25, 2007
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Uruguay
    Hola,

    ¿En concreto que error te da?

    Muestranos tu archivo /etc/my.cnf
     
Loading...

Share This Page