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.

Mysql Mega Load

Discussion in 'General Discussion' started by DarkHipno, Jul 20, 2006.

  1. DarkHipno

    DarkHipno Member

    Joined:
    Jun 29, 2005
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Genebra, Switzerland
    Expensive friends, I am with 1 problem with mysql. Mysql when it is used reaches loads of 40-50 i am not knows what to make, i'am install and update for cpanel and nothing. The version of mysql is the 4.1.19. The server is 1 Intel Dual Core 3,0 1 GB MEM. Please helps me Traduct by Google
     
  2. AlexandreVeezon

    AlexandreVeezon Well-Known Member

    Joined:
    Dec 9, 2005
    Messages:
    99
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    /br/sc/rionegrinho
    cPanel Access Level:
    Root Administrator
    English

    Try to verify the simultaneos connection. You can install a tool called MyTOP to see who is using too much CPU. To see the simultaneos connections, type

    mysql

    show status;


    Search for Max_used_connections variable and make sure this number is not too high. Another thing is to configure correctly the my.cnf file. Try to optimize it in according to your necessity. Hope it helps ;)

    :cool:

    Portuguese

    Verifique as conexões simultâneas que você está tendo. Você também pode instalar uma ferramenta chamada MyTOP para verificar quem está abusando de CPU. Para verificar seu número máximo de conexões, digite

    mysql

    show status;


    Procure pela variável Max_used_connections e verifique se este número está muito alto.
    Outra coisa seria configurar corretamente o arquivo my.cnf. Procure no otimizá-lo de acordo com sua necessidade. Espero ter ajudado. ;)
     
Loading...

Share This Page