Mem use upgrade from MySQL 5.1 to 5.5

jhave

Member
PartnerNOC
Mar 14, 2013
8
0
51
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?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
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.
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
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
 

24x7server

Well-Known Member
Apr 17, 2013
1,912
99
78
India
cPanel Access Level
Root Administrator
Twitter
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
mysqladmin proc stat