Mysql eat a huge amount of memory

Mysql eat a huge amount of memory

am 23.03.2009 21:20:25 von Tadeu Alves

--0016e644cdd68d263a0465ceff8a
Content-Type: multipart/alternative; boundary=0016e644cdd68d26330465ceff88

--0016e644cdd68d26330465ceff88
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi there guys, latelly our server is suffering from a very big memory eat
problem, when i start mysql it goes with about 2GB of memory, but about
20h-30h later the server is eating about 8GB, this is a huge problem i know
that some memory variables have an sort of calculation and i think that the
problem is this but i'm not finding where to fix thismy server configuratio=
n
is

2x Quad Core Intel=AE Xeon=AE E5450, 2x6MB
Cache ache>,
3.0GHz, 1333MHz FSB
8GB 800MHz Memory
2x SAS 73GB 15000RPM in RAID 1

I'm Running moodle 1.7.2+ with
MYSQL ySQL>
5.0.45
and our database size is about 9gb with
PHP >
5.1.6

i'll send our my.cnf configuration so anyone who can help please lend me a
hand or a head :D

--0016e644cdd68d26330465ceff88
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi there guys, latelly our server is suffering from a very big memory eat p=
roblem, when i start mysql it goes with about 2GB of memory, but about 20h-=
30h later the server is eating about 8GB, this is a huge problem i know tha=
t some memory variables have an sort of calculation and i think that the pr=
oblem is this but i'm not finding where to fix this


my server configuration is

yle-span" style=3D"color: rgb(68, 68, 68); font-family: 'Lucida Sans Un=
icode'; line-height: 18px; ">

t: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; bord=
er-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; bord=
er-style: initial; border-color: initial; outline-width: 0px; outline-style=
: initial; outline-color: initial; font-weight: inherit; font-style: inheri=
t; font-size: 100%; font-family: inherit; background-image: none; vertical-=
align: baseline; margin-top: 0px; margin-right: 0px; margin-bottom: 1em; ma=
rgin-left: 0px; ">
2x Quad Core Intel=AE Xeon=AE E5450, 2x6MB=A0 glossaryid5" title=3D"Glossary of common terms: Cache" href=3D"http://moodl=
e.org/mod/glossary/showentry.php?courseid=3D5&concept=3D Cache" onclick=
=3D"return openpopup('/mod/glossary/showentry.php?courseid=3D5\&con=
cept=3DCache', 'entry', 'menubar=3D0,location=3D0,scrollbar=
s,resizable,width=3D600,height=3D450', 0);" style=3D"margin-top: 0px; m=
argin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; p=
adding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width=
: 0px; border-right-width: 0px; border-left-width: 0px; border-style: initi=
al; border-color: initial; outline-width: 0px; outline-style: initial; outl=
ine-color: initial; font-weight: inherit; font-style: inherit; font-size: 1=
00%; font-family: inherit; vertical-align: baseline; text-decoration: none;=
color: rgb(0, 0, 0); background-image: none !important; background-repeat:=
initial !important; background-attachment: initial !important; -webkit-bac=
kground-clip: initial !important; -webkit-background-origin: initial !impor=
tant; background-color: initial !important; border-bottom-width: 2px; borde=
r-bottom-style: dotted; border-bottom-color: rgb(255, 203, 68); background-=
position: initial initial !important; ">Cache
, 3.0GHz, 1333MHz FSB

8GB 800MHz Memory
2x SAS 73GB 15000RPM in RAID 1

top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; borde=
r-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border=
-left-width: 0px; border-style: initial; border-color: initial; outline-wid=
th: 0px; outline-style: initial; outline-color: initial; font-weight: inher=
it; font-style: inherit; font-size: 100%; font-family: inherit; background-=
image: none; vertical-align: baseline; margin-top: 0px; margin-right: 0px; =
margin-bottom: 1em; margin-left: 0px; ">
I'm Running moodle 1.7.2+ with=A0 id5" title=3D"Glossary of common terms: MySQL" href=3D"http://moodle.org/mo=
d/glossary/showentry.php?courseid=3D5&concept=3DMySQL" onclick=3D"retur=
n openpopup('/mod/glossary/showentry.php?courseid=3D5\&concept=3DMy=
SQL', 'entry', 'menubar=3D0,location=3D0,scrollbars,resizab=
le,width=3D600,height=3D450', 0);" style=3D"margin-top: 0px; margin-rig=
ht: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-ri=
ght: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; bo=
rder-right-width: 0px; border-left-width: 0px; border-style: initial; borde=
r-color: initial; outline-width: 0px; outline-style: initial; outline-color=
: initial; font-weight: inherit; font-style: inherit; font-size: 100%; font=
-family: inherit; vertical-align: baseline; text-decoration: none; color: r=
gb(0, 0, 0); background-image: none !important; background-repeat: initial =
!important; background-attachment: initial !important; -webkit-background-c=
lip: initial !important; -webkit-background-origin: initial !important; bac=
kground-color: initial !important; border-bottom-width: 2px; border-bottom-=
style: dotted; border-bottom-color: rgb(255, 203, 68); background-position:=
initial initial !important; ">MYSQL
=A05.0.45 and our database size is =
about 9gb with=A0 to interesting resources: PHP" href=3D"http://moodle.org/mod/glossary/show=
entry.php?courseid=3D5&concept=3DPHP" onclick=3D"return openpopup('=
/mod/glossary/showentry.php?courseid=3D5\&concept=3DPHP', 'entr=
y', ' menubar=3D0,location=3D0,scrollbars,resizable,width=3D600,he ig=
ht=3D450', 0);" style=3D"margin-top: 0px; margin-right: 0px; margin-bot=
tom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-b=
ottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0=
px; border-left-width: 0px; border-style: initial; border-color: initial; o=
utline-width: 0px; outline-style: initial; outline-color: initial; font-wei=
ght: inherit; font-style: inherit; font-size: 100%; font-family: inherit; v=
ertical-align: baseline; text-decoration: none; color: rgb(0, 0, 0); backgr=
ound-image: none !important; background-repeat: initial !important; backgro=
und-attachment: initial !important; -webkit-background-clip: initial !impor=
tant; -webkit-background-origin: initial !important; background-color: init=
ial !important; border-bottom-width: 2px; border-bottom-style: dotted; bord=
er-bottom-color: rgb(255, 203, 68); background-position: initial initial !i=
mportant; ">PHP
=A05.1.6


ing-left: 0px; border-top-width: 0px; border-right-width: 0px; border-botto=
m-width: 0px; border-left-width: 0px; border-style: initial; border-color: =
initial; outline-width: 0px; outline-style: initial; outline-color: initial=
; font-weight: inherit; font-style: inherit; font-size: 100%; font-family: =
inherit; background-image: none; vertical-align: baseline; margin-top: 0px;=
margin-right: 0px; margin-bottom: 1em; margin-left: 0px; ">
i'll send our my.cnf configuration so anyone who can help please lend m=
e a hand or a head :D



--0016e644cdd68d26330465ceff88--

--0016e644cdd68d263a0465ceff8a
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--0016e644cdd68d263a0465ceff8a--

Re: Mysql eat a huge amount of memory

am 23.03.2009 21:39:07 von Claudio Nanni - TomTom

post the my.cnf
and the output from 'SHOW STATUS'

Claudio

Tadeu Alves wrote:
> Hi there guys, latelly our server is suffering from a very big memory
> eat problem, when i start mysql it goes with about 2GB of memory, but
> about 20h-30h later the server is eating about 8GB, this is a huge
> problem i know that some memory variables have an sort of calculation
> and i think that the problem is this but i'm not finding where to fix
> this
> my server configuration is
>
> 2x Quad Core Intel® Xeon® E5450, 2x6MB Cache
> ,
> 3.0GHz, 1333MHz FSB
> 8GB 800MHz Memory
> 2x SAS 73GB 15000RPM in RAID 1
>
> I'm Running moodle 1.7.2+ with MYSQL
> 5.0.45
> and our database size is about 9gb with PHP
> 5.1.6
>
> i'll send our my.cnf configuration so anyone who can help please lend
> me a hand or a head :D
>
> ------------------------------------------------------------ ------------
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org