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.

Mem use upgrade from MySQL 5.1 to 5.5

Discussion in 'Workarounds and Optimization' started by jhave, Jun 15, 2013.

  1. jhave

    jhave Member

    Joined:
    Mar 14, 2013
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    hi,

    After I upgraded MySQL from version 5.1 to 5.5 is the beginning to use 3 times as much memory. It has gone from 51MB to 160MB of memory. All I have done is upgraded in WHM.

    Why?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    I have moved this thread over to the "Optimization" forum for you, as you will likely get more input here. Have you made any modifications to your /etc/my.cnf file? If not, the following thread is a good place to start:

    mysqlmymonlite.sh server stats gathering tool for cPanel Server

    This will help with generating data so we know more about MySQL usage on your system.

    Thank you.
     
  3. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Its most likely becouse you have as default enabled InnoDB now with bigger buffers
    If you don't use it, you can disable it, by adding skip-innodb to my.cnf
     
  4. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Also I will suggest you monitor your MySQL process list. May be your one of the MySQL DB is consuming the high memory on your server

    Show MySQL Processes

    You can check the through SSH
     
Loading...

Share This Page