Out of memory error

------=_NextPart_000_001C_01CB7C0A.0F35EAA0
Content-Type: text/plain;
charset="ks_c_5601-1987"
Content-Transfer-Encoding: base64

RGVhciBNeVNRTCB1c2VycywNCg0KSSBnb3QgYW4gIk91dCBvZiBtZW1vcnki IGVycm9yIG1lc3Nh
Z2Ugb24gc2VydmVyIHllc3RlcmRheS4NCkkgcmVzdGFydGVkIG15c3FsZCwg YW5kIGV2ZXJ5dGhp
bmcgd2FzIGdvIGJhY2sgdG8gbm9ybWFsIGFuZCBub3cgaXMgZmluZS4NCg0K SXQgaGFwcGVuZWQg
YWxyZWFkeSB0d2ljZSBpbiB0aGlzIHdlZWtlbmQgZXZlbi4NCkJ1dCBJIGRv bid0IGtub3cgd2hh
dCdzIHdyb25nLg0KDQpTZXJ2ZXIgaGFzIFF1YWRDb3JlIFhlb24gQ1BVLCA0 RyBFQ0MgUkFNLCAy
RyB4IDQ5KGVhKSBpYmRhdGEgZmlsZXMsIG1vc3RseSBiYXNlZCBvbiB1c2lu ZyBJbm5vREIgdHlw
ZWQgdGFibGVzLg0KDQpCZWxvdyBpcyBzZXJ2ZXIgY29uZGl0aW9uIGRldGFp bHMuDQoNCltyb290
QHN2cjQwIG15c3FsXSMgdWxpbWl0IC1hDQpjb3JlIGZpbGUgc2l6ZSAgICAg ICAgICAoYmxvY2tz
LCAtYykgMA0KZGF0YSBzZWcgc2l6ZSAgICAgICAgICAgKGtieXRlcywgLWQp IHVubGltaXRlZA0K
c2NoZWR1bGluZyBwcmlvcml0eSAgICAgICAgICAgICAoLWUpIDANCmZpbGUg c2l6ZSAgICAgICAg
ICAgICAgIChibG9ja3MsIC1mKSB1bmxpbWl0ZWQNCnBlbmRpbmcgc2lnbmFs cyAgICAgICAgICAg
ICAgICAgKC1pKSA3NzgyNA0KbWF4IGxvY2tlZCBtZW1vcnkgICAgICAgKGti eXRlcywgLWwpIDMy
DQptYXggbWVtb3J5IHNpemUgICAgICAgICAoa2J5dGVzLCAtbSkgdW5saW1p dGVkDQpvcGVuIGZp
bGVzICAgICAgICAgICAgICAgICAgICAgICgtbikgMTAyNA0KcGlwZSBzaXpl ICAgICAgICAgICAg
KDUxMiBieXRlcywgLXApIDgNClBPU0lYIG1lc3NhZ2UgcXVldWVzICAgICAo Ynl0ZXMsIC1xKSA4
MTkyMDANCnJlYWwtdGltZSBwcmlvcml0eSAgICAgICAgICAgICAgKC1yKSAw DQpzdGFjayBzaXpl
ICAgICAgICAgICAgICAoa2J5dGVzLCAtcykgMTAyNDANCmNwdSB0aW1lICAg ICAgICAgICAgICAg
KHNlY29uZHMsIC10KSB1bmxpbWl0ZWQNCm1heCB1c2VyIHByb2Nlc3NlcyAg ICAgICAgICAgICAg
KC11KSA3NzgyNA0KdmlydHVhbCBtZW1vcnkgICAgICAgICAgKGtieXRlcywg LXYpIHVubGltaXRl
ZA0KZmlsZSBsb2NrcyAgICAgICAgICAgICAgICAgICAgICAoLXgpIHVubGlt aXRlZA0KW3Jvb3RA
c3ZyNDAgbXlzcWxdIyB1bmFtZSAtYQ0KTGludXggc3ZyNDAuaHNsLmNvLmty IDIuNi4xOC0xNjQu
MTEuMS5lbDVQQUUgIzEgU01QIFdlZCBKYW4gMjAgMDg6MTY6MTMgRVNUIDIw MTAgaTY4NiBpNjg2
IGkzODYgR05VL0xpbnV4DQpbcm9vdEBzdnI0MCBteXNxbF0jIGNhdCAvZXRj L3JlZGhhdC1yZWxl
YXNlIA0KQ2VudE9TIHJlbGVhc2UgNS40IChGaW5hbCkNCltyb290QHN2cjQw IG15c3FsXSMgcnBt
IC1xYSB8IGdyZXAgTXlTUUwNCk15U1FMLWRldmVsLWNvbW11bml0eS01LjEu NDItMC5yaGVsNQ0K
TXlTUUwtY2xpZW50LWNvbW11bml0eS01LjEuNDItMC5yaGVsNQ0KTXlTUUwt c2VydmVyLWNvbW11
bml0eS01LjEuNDItMC5yaGVsNQ0KW3Jvb3RAc3ZyNDAgbXlzcWxdIyB0YWls IC01MCBzdnI0MC54
eHh4LmVyciANCjEwMTEwMyAxNToxMjoyNSBbRVJST1JdIC91c3Ivc2Jpbi9t eXNxbGQ6IE91dCBv
ZiBtZW1vcnkgKE5lZWRlZCAyMDk1MTMyIGJ5dGVzKQ0KMTAxMTAzIDE1OjEy OjI1IFtFUlJPUl0g
L3Vzci9zYmluL215c3FsZDogT3V0IG9mIG1lbW9yeSAoTmVlZGVkIDIwOTUx MzIgYnl0ZXMpDQox
MDExMDMgMTU6MTI6MjUgW0VSUk9SXSAvdXNyL3NiaW4vbXlzcWxkOiBPdXQg b2YgbWVtb3J5IChO
ZWVkZWQgMjA5NTEzMiBieXRlcykNCjEwMTEwMyAxNToxMjoyNSBbRVJST1Jd IC91c3Ivc2Jpbi9t
eXNxbGQ6IE91dCBvZiBtZW1vcnkgKE5lZWRlZCAyMDk1MTMyIGJ5dGVzKQ0K MTAxMTAzIDE1OjEy
OjI4IFtFUlJPUl0gL3Vzci9zYmluL215c3FsZDogT3V0IG9mIG1lbW9yeSAo TmVlZGVkIDIwOTUx
MTYgYnl0ZXMpDQoxMDExMDMgMTU6MTI6MzggW0VSUk9SXSAvdXNyL3NiaW4v bXlzcWxkOiBPdXQg
b2YgbWVtb3J5IChOZWVkZWQgMjA5NTEzMiBieXRlcykNCjEwMTEwMyAxNTox MjozOCBbRVJST1Jd
IC91c3Ivc2Jpbi9teXNxbGQ6IE91dCBvZiBtZW1vcnkgKE5lZWRlZCAyMDk1 MTMyIGJ5dGVzKQ0K
MTAxMTAzIDE1OjEyOjQyIFtFUlJPUl0gL3Vzci9zYmluL215c3FsZDogT3V0 IG9mIG1lbW9yeSAo
TmVlZGVkIDIwOTUyMzYgYnl0ZXMpDQoxMDExMDMgMTU6MTI6NDMgW0VSUk9S XSAvdXNyL3NiaW4v
bXlzcWxkOiBPdXQgb2YgbWVtb3J5IChOZWVkZWQgMjA5NTU4NCBieXRlcykN CjEwMTEwMyAxNTox
Mjo0NSBbRVJST1JdIC91c3Ivc2Jpbi9teXNxbGQ6IE91dCBvZiBtZW1vcnkg KE5lZWRlZCAyMDk1
MTMyIGJ5dGVzKQ0KMTAxMTAzIDE1OjEyOjQ1IFtFUlJPUl0gL3Vzci9zYmlu L215c3FsZDogT3V0
IG9mIG1lbW9yeSAoTmVlZGVkIDIwOTUxMzIgYnl0ZXMpDQoxMDExMDMgMTU6 MTI6NDcgW0VSUk9S
XSAvdXNyL3NiaW4vbXlzcWxkOiBPdXQgb2YgbWVtb3J5IChOZWVkZWQgMjA5 NTIwMCBieXRlcykN
CjEwMTEwMyAxNToxMjo1MSBbRVJST1JdIC91c3Ivc2Jpbi9teXNxbGQ6IE91 dCBvZiBtZW1vcnkg
KE5lZWRlZCAyMDk1MTE2IGJ5dGVzKQ0KMTAxMTAzIDE1OjEzOjEyIFtFUlJP Ul0gL3Vzci9zYmlu
L215c3FsZDogT3V0IG9mIG1lbW9yeSAoTmVlZGVkIDIwOTUxMjAgYnl0ZXMp DQoxMDExMDMgMTU6
MTM6MTYgW0VSUk9SXSAvdXNyL3NiaW4vbXlzcWxkOiBPdXQgb2YgbWVtb3J5 IChOZWVkZWQgMjA5
NTEzMiBieXRlcykNCjEwMTEwMyAxNToxMzoxNiBbRVJST1JdIC91c3Ivc2Jp bi9teXNxbGQ6IE91
dCBvZiBtZW1vcnkgKE5lZWRlZCAyMDk1MTMyIGJ5dGVzKQ0KMTAxMTAzIDE1 OjEzOjE5IFtFUlJP
Ul0gL3Vzci9zYmluL215c3FsZDogT3V0IG9mIG1lbW9yeSAoTmVlZGVkIDIw OTUxMjAgYnl0ZXMp
DQoxMDExMDMgMTU6MTM6MjIgW0VSUk9SXSAvdXNyL3NiaW4vbXlzcWxkOiBP dXQgb2YgbWVtb3J5
IChOZWVkZWQgMjA5NTU0OCBieXRlcykNCjEwMTEwMyAxNToxMzoyMyBbRVJS T1JdIC91c3Ivc2Jp
bi9teXNxbGQ6IE91dCBvZiBtZW1vcnkgKE5lZWRlZCAyMDk1MTMyIGJ5dGVz KQ0KMTAxMTAzIDE1
OjEzOjIzIFtFUlJPUl0gL3Vzci9zYmluL215c3FsZDogT3V0IG9mIG1lbW9y eSAoTmVlZGVkIDIw
OTUxMzIgYnl0ZXMpDQoxMDExMDMgMTU6MTM6MjggW0VSUk9SXSAvdXNyL3Ni aW4vbXlzcWxkOiBP
dXQgb2YgbWVtb3J5IChOZWVkZWQgMjA5NTU0OCBieXRlcykNCjEwMTEwMyAx NToxMzozMiBbRVJS
T1JdIC91c3Ivc2Jpbi9teXNxbGQ6IE91dCBvZiBtZW1vcnkgKE5lZWRlZCAy MDk1MTMyIGJ5dGVz
KQ0KMTAxMTAzIDE1OjEzOjM0IFtFUlJPUl0gL3Vzci9zYmluL215c3FsZDog T3V0IG9mIG1lbW9y
eSAoTmVlZGVkIDIwOTU1MDAgYnl0ZXMpDQoxMDExMDMgMTU6MTM6MzggW0VS Uk9SXSAvdXNyL3Ni
aW4vbXlzcWxkOiBPdXQgb2YgbWVtb3J5IChOZWVkZWQgMjA5NTU0OCBieXRl cykNCjEwMTEwMyAx
NToxMzozOCBbRVJST1JdIC91c3Ivc2Jpbi9teXNxbGQ6IE91dCBvZiBtZW1v cnkgKE5lZWRlZCAy
MDk1MzkyIGJ5dGVzKQ0KMTAxMTAzIDE1OjEzOjQwIFtFUlJPUl0gL3Vzci9z YmluL215c3FsZDog
T3V0IG9mIG1lbW9yeSAoTmVlZGVkIDIwOTUxMjAgYnl0ZXMpDQoxMDExMDMg MTU6MTM6NDAgW0VS
Uk9SXSAvdXNyL3NiaW4vbXlzcWxkOiBPdXQgb2YgbWVtb3J5IChOZWVkZWQg MjA5NTEyMCBieXRl
cykNCjEwMTEwMyAxNToxMzo0MSBbRVJST1JdIC91c3Ivc2Jpbi9teXNxbGQ6 IE91dCBvZiBtZW1v
cnkgKE5lZWRlZCAyMDk1MTMyIGJ5dGVzKQ0KMTAxMTAzIDE1OjEzOjQxIFtF UlJPUl0gL3Vzci9z
YmluL215c3FsZDogT3V0IG9mIG1lbW9yeSAoTmVlZGVkIDIwOTUxMzIgYnl0 ZXMpDQoxMDExMDMg
MTU6MTM6NDUgW0VSUk9SXSAvdXNyL3NiaW4vbXlzcWxkOiBPdXQgb2YgbWVt b3J5IChOZWVkZWQg
MjA5NTU0OCBieXRlcykNCjEwMTEwMyAxNToxMzo0OSBbRVJST1JdIC91c3Iv c2Jpbi9teXNxbGQ6
IE91dCBvZiBtZW1vcnkgKE5lZWRlZCAyMDk1MjAwIGJ5dGVzKQ0KMTAxMTAz IDE1OjEzOjUxIFtF
UlJPUl0gL3Vzci9zYmluL215c3FsZDogT3V0IG9mIG1lbW9yeSAoTmVlZGVk IDIwOTUxMjggYnl0
ZXMpDQoxMDExMDMgMTU6MTM6NTEgW0VSUk9SXSAvdXNyL3NiaW4vbXlzcWxk OiBPdXQgb2YgbWVt
b3J5IChOZWVkZWQgMjA5NTI4NCBieXRlcykNCjEwMTEwMyAxNToxMzo1MiBb RVJST1JdIC91c3Iv
c2Jpbi9teXNxbGQ6IE91dCBvZiBtZW1vcnkgKE5lZWRlZCAyMDk1NTQ4IGJ5 dGVzKQ0KMTAxMTAz
IDE1OjEzOjU3IFtFUlJPUl0gL3Vzci9zYmluL215c3FsZDogT3V0IG9mIG1l bW9yeSAoTmVlZGVk
IDIwOTUxMjggYnl0ZXMpDQoxMDExMDMgMTU6MTM6NTcgW0VSUk9SXSAvdXNy L3NiaW4vbXlzcWxk
OiBPdXQgb2YgbWVtb3J5IChOZWVkZWQgMjA5NTI4NCBieXRlcykNCjEwMTEw MyAxNToxNDowMiBb
Tm90ZV0gL3Vzci9zYmluL215c3FsZDogTm9ybWFsIHNodXRkb3duDQoNCjEw MTEwMyAxNToxNDow
MiBbTm90ZV0gRXZlbnQgU2NoZWR1bGVyOiBQdXJnaW5nIHRoZSBxdWV1ZS4g MCBldmVudHMNCjEw
MTEwMyAxNToxNDowNCAgSW5ub0RCOiBTdGFydGluZyBzaHV0ZG93bi4uLg0K MTAxMTAzIDE1OjE0
OjA4ICBJbm5vREI6IFNodXRkb3duIGNvbXBsZXRlZDsgbG9nIHNlcXVlbmNl IG51bWJlciAxMCA0
Mzc2NTQ2NzYNCjEwMTEwMyAxNToxNDowOCBbTm90ZV0gL3Vzci9zYmluL215 c3FsZDogU2h1dGRv
d24gY29tcGxldGUNCg0KMTAxMTAzIDE1OjE0OjA4IG15c3FsZF9zYWZlIG15 c3FsZCBmcm9tIHBp
ZCBmaWxlIC92YXIvbGliL215c3FsL3N2cjQwLnh4eC5waWQgZW5kZWQNCjEw MTEwMyAxNToxNDox
NSBteXNxbGRfc2FmZSBTdGFydGluZyBteXNxbGQgZGFlbW9uIHdpdGggZGF0 YWJhc2VzIGZyb20g
L3Zhci9saWIvbXlzcWwNCjEwMTEwMyAxNToxNDoxNSBbTm90ZV0gUGx1Z2lu ICdGRURFUkFURUQn
IGlzIGRpc2FibGVkLg0KMTAxMTAzIDE1OjE0OjE2ICBJbm5vREI6IFN0YXJ0 ZWQ7IGxvZyBzZXF1
ZW5jZSBudW1iZXIgMTAgNDM3NjU0Njc2DQoxMDExMDMgMTU6MTQ6MTYgW05v dGVdIEV2ZW50IFNj
aGVkdWxlcjogTG9hZGVkIDAgZXZlbnRzDQoxMDExMDMgMTU6MTQ6MTYgW05v dGVdIC91c3Ivc2Jp
bi9teXNxbGQ6IHJlYWR5IGZvciBjb25uZWN0aW9ucy4NClZlcnNpb246ICc1 LjEuNDItY29tbXVu
aXR5LWxvZycgIHNvY2tldDogJy92YXIvbGliL215c3FsL215c3FsLnNvY2sn ICBwb3J0OiAzMzA2
ICBNeVNRTCBDb21tdW5pdHkgU2VydmVyIChHUEwpDQoNCltyb290QHN2cjQw IG15c3FsXSMgY2F0
IC9ldGMvbXkuY25mDQoNCi4NCi4NCi4NCi4NCltteXNxbGRdDQptYXhfY29u bmVjdGlvbnMgPSA1
MDANCm1heF9jb25uZWN0X2Vycm9ycyA9IDMwDQp0YWJsZV9vcGVuX2NhY2hl ID0gNDA5Ng0KbWF4
X2FsbG93ZWRfcGFja2V0ID0gMTZNDQpiaW5sb2dfY2FjaGVfc2l6ZSA9IDFN DQptYXhfYmlubG9n
X3NpemUgPSAxMDBNDQpleHBpcmVfbG9nc19kYXlzID0gNw0KbWF4X2hlYXBf dGFibGVfc2l6ZSA9
IDY0TQ0Kc29ydF9idWZmZXJfc2l6ZSA9IDhNDQpqb2luX2J1ZmZlcl9zaXpl ID0gOE0NCnRocmVh
ZF9jYWNoZV9zaXplID0gOA0KdGhyZWFkX2NvbmN1cnJlbmN5ID0gOA0KcXVl cnlfY2FjaGVfc2l6
ZSA9IDY0TQ0KcXVlcnlfY2FjaGVfbGltaXQgPSAyTQ0KdG1wX3RhYmxlX3Np emUgPSA2NE0NCmxv
Zy1iaW49bXlzcWwtYmluDQpiaW5sb2dfZm9ybWF0PW1peGVkDQpzbG93X3F1 ZXJ5X2xvZw0KbG9u
Z19xdWVyeV90aW1lID0gMzBcDQoNCmtleV9idWZmZXJfc2l6ZSA9IDMyTQ0K cmVhZF9idWZmZXJf
c2l6ZSA9IDJNDQpyZWFkX3JuZF9idWZmZXJfc2l6ZSA9IDE2TQ0KYnVsa19p bnNlcnRfYnVmZmVy
X3NpemUgPSA2NE0NCm15aXNhbV9zb3J0X2J1ZmZlcl9zaXplID0gMTI4TQ0K bXlpc2FtX21heF9z
b3J0X2ZpbGVfc2l6ZSA9IDEwRw0KbXlpc2FtX3JlcGFpcl90aHJlYWRzID0g MQ0KDQppbm5vZGJf
YWRkaXRpb25hbF9tZW1fcG9vbF9zaXplID0gMTZNDQppbm5vZGJfYnVmZmVy X3Bvb2xfc2l6ZSA9
IDJHDQppbm5vZGJfZGF0YV9maWxlX3BhdGggPSBpYmRhdGExOjJHO2liZGF0 YTI6Mkc7Li4uLi4u
Li4uLi4uLi4uLmliZGF0YTQ1OjJHO2liZGF0YTQ2OjEwME06YXV0b2V4dGVu ZA0KaW5ub2RiX2Zp
bGVfaW9fdGhyZWFkcyA9IDQNCmlubm9kYl90aHJlYWRfY29uY3VycmVuY3kg PSAxNg0KaW5ub2Ri
X2ZsdXNoX2xvZ19hdF90cnhfY29tbWl0ID0gMQ0KaW5ub2RiX2xvZ19idWZm ZXJfc2l6ZSA9IDhN
DQppbm5vZGJfbG9nX2ZpbGVfc2l6ZSA9IDUxMk0gDQppbm5vZGJfbG9nX2Zp bGVzX2luX2dyb3Vw
ID0gMw0KaW5ub2RiX21heF9kaXJ0eV9wYWdlc19wY3QgPSA5MA0KaW5ub2Ri X2xvY2tfd2FpdF90
aW1lb3V0ID0gMTIwDQouDQouDQouDQoNCkkgZXhwZWN0IHRoZSB0cm91Ymxl LXNob290aW5nIHNv
b24sIGF0IGxlYXN0IHRoZSByZWFzb24gY2F0Y2hpbmcuDQoNCg0KVGhhbmsg eW91Lg0KDQpLaW0g
Q2hp

------=_NextPart_000_001C_01CB7C0A.0F35EAA0--

Re: Out of memory error

upgrade to the lastest MySQL 5.1.x branch GA and try again.

Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)



2010/11/4 김수ì˜=81 :
> Dear MySQL users,
>
> I got an "Out of memory" error message on server yesterday.
> I restarted mysqld, and everything was go back to normal and now is fine.
>
> It happened already twice in this weekend even.
> But I don't know what's wrong.
>
> Server has QuadCore Xeon CPU, 4G ECC RAM, 2G x 49(ea) ibdata files, mostl=
y based on using InnoDB typed tables.
>
> Below is server condition details.
>
> [root@svr40 mysql]# ulimit -a
> core file size          (blocks, -c) 0
> data seg size           (kbytes, -d) unlimited
> scheduling priority             (-e) 0
> file size               (blocks, -f) u=
nlimited
> pending signals                 (=
-i) 77824
> max locked memory       (kbytes, -l) 32
> max memory size         (kbytes, -m) unlimited
> open files                  =
   (-n) 1024
> pipe size            (512 bytes, -p) 8
> POSIX message queues     (bytes, -q) 819200
> real-time priority              (-r) 0
> stack size              (kbytes, -s) 1=
0240
> cpu time               (seconds, -t) u=
nlimited
> max user processes              (-u) 7=
7824
> virtual memory          (kbytes, -v) unlimited
> file locks                  =
   (-x) unlimited
> [root@svr40 mysql]# uname -a
> Linux svr40.hsl.co.kr 2.6.18-164.11.1.el5PAE #1 SMP Wed Jan 20 08:16:13 E=
ST 2010 i686 i686 i386 GNU/Linux
> [root@svr40 mysql]# cat /etc/redhat-release
> CentOS release 5.4 (Final)
> [root@svr40 mysql]# rpm -qa | grep MySQL
> MySQL-devel-community-5.1.42-0.rhel5
> MySQL-client-community-5.1.42-0.rhel5
> MySQL-server-community-5.1.42-0.rhel5
> [root@svr40 mysql]# tail -50 svr40.xxxx.err
> 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:25 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:28 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095116 b=
ytes)
> 101103 15:12:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:42 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095236 b=
ytes)
> 101103 15:12:43 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095584 b=
ytes)
> 101103 15:12:45 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:45 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:12:47 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095200 b=
ytes)
> 101103 15:12:51 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095116 b=
ytes)
> 101103 15:13:12 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 b=
ytes)
> 101103 15:13:16 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:13:16 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:13:19 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 b=
ytes)
> 101103 15:13:22 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 b=
ytes)
> 101103 15:13:23 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:13:23 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:13:28 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 b=
ytes)
> 101103 15:13:32 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:13:34 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095500 b=
ytes)
> 101103 15:13:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 b=
ytes)
> 101103 15:13:38 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095392 b=
ytes)
> 101103 15:13:40 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 b=
ytes)
> 101103 15:13:40 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095120 b=
ytes)
> 101103 15:13:41 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:13:41 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095132 b=
ytes)
> 101103 15:13:45 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 b=
ytes)
> 101103 15:13:49 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095200 b=
ytes)
> 101103 15:13:51 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095128 b=
ytes)
> 101103 15:13:51 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095284 b=
ytes)
> 101103 15:13:52 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095548 b=
ytes)
> 101103 15:13:57 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095128 b=
ytes)
> 101103 15:13:57 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 2095284 b=
ytes)
> 101103 15:14:02 [Note] /usr/sbin/mysqld: Normal shutdown
>
> 101103 15:14:02 [Note] Event Scheduler: Purging the queue. 0 events
> 101103 15:14:04  InnoDB: Starting shutdown...
> 101103 15:14:08  InnoDB: Shutdown completed; log sequence number 10 =
437654676
> 101103 15:14:08 [Note] /usr/sbin/mysqld: Shutdown complete
>
> 101103 15:14:08 mysqld_safe mysqld from pid file /var/lib/mysql/svr40.xxx=
..pid ended
> 101103 15:14:15 mysqld_safe Starting mysqld daemon with databases from /v=
ar/lib/mysql
> 101103 15:14:15 [Note] Plugin 'FEDERATED' is disabled.
> 101103 15:14:16  InnoDB: Started; log sequence number 10 437654676
> 101103 15:14:16 [Note] Event Scheduler: Loaded 0 events
> 101103 15:14:16 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.1.42-community-log'  socket: '/var/lib/mysql/mysql.sock'=
 port: 3306  MySQL Community Server (GPL)
>
> [root@svr40 mysql]# cat /etc/my.cnf
>
> .
> .
> .
> .
> [mysqld]
> max_connections =3D 500
> max_connect_errors =3D 30
> table_open_cache =3D 4096
> max_allowed_packet =3D 16M
> binlog_cache_size =3D 1M
> max_binlog_size =3D 100M
> expire_logs_days =3D 7
> max_heap_table_size =3D 64M
> sort_buffer_size =3D 8M
> join_buffer_size =3D 8M
> thread_cache_size =3D 8
> thread_concurrency =3D 8
> query_cache_size =3D 64M
> query_cache_limit =3D 2M
> tmp_table_size =3D 64M
> log-bin=3Dmysql-bin
> binlog_format=3Dmixed
> slow_query_log
> long_query_time =3D 30\
>
> key_buffer_size =3D 32M
> read_buffer_size =3D 2M
> read_rnd_buffer_size =3D 16M
> bulk_insert_buffer_size =3D 64M
> myisam_sort_buffer_size =3D 128M
> myisam_max_sort_file_size =3D 10G
> myisam_repair_threads =3D 1
>
> innodb_additional_mem_pool_size =3D 16M
> innodb_buffer_pool_size =3D 2G
> innodb_data_file_path =3D ibdata1:2G;ibdata2:2G;................ibdata45:=
2G;ibdata46:100M:autoextend
> innodb_file_io_threads =3D 4
> innodb_thread_concurrency =3D 16
> innodb_flush_log_at_trx_commit =3D 1
> innodb_log_buffer_size =3D 8M
> innodb_log_file_size =3D 512M
> innodb_log_files_in_group =3D 3
> innodb_max_dirty_pages_pct =3D 90
> innodb_lock_wait_timeout =3D 120
> .
> .
> .
>
> I expect the trouble-shooting soon, at least the reason catching.
>
>
> Thank you.
>
> Kim Chi

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

Re: Out of memory error

--001636c5a7a51379a2049435d9c4
Content-Type: text/plain; charset=ISO-8859-1

Out of your 4 gigabyte of memory, you allocate 2G to the innodb pool.
Assuming you're using mostly innoDB, that's good. Say there's also about
300M allocated to the OS - assuming a dedicated server; that leaves about
1.7G for non-InnoDB operations.

You have configured your server for 500 connections, and specified both
join_buffer_size and sort_buffer_size as 8M.

Every session that needs to do a sort allocates one sort buffer of the
specified size. One join buffer of *minimum* this size is allocated for
every full join between two tables, so multiple buffers may be needed for a
single query.

8M * 500 connections = 2G.

Do you see where this is going ? :-)

Not every connection will need to allocate join or sort buffers, but it may
be well worth to see what's happening on your server when you get these out
of memory errors, and maybe you can optimize some queries to use indices for
sorting, add indices to remove full joins, et cetera.

I keep telling people this: set up Munin or Cacti, and graph anything you
can find about your server. Trending gives you both the ability to look back
at what was going on when a problem occured, and look forward to see
problems coming ahead of time.

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--001636c5a7a51379a2049435d9c4--