Mem use upgrade from MySQL 5.1 to 5.5

jhave

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

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,907
95
78
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
mysqladmin proc stat