MySQL Forums
Forum List  »  Other Migration

duplicating mysql setup - Out-Of-Memory problem.... eek
Posted by: A Stokes
Date: July 28, 2006 08:49AM

Hi - I am copying all my websites etc from my old server (linux debian 3.0 kernel 2.4, apache 1.3, mysql 4.0.18) to my new server (linux debian 3.1 kernel 2.6, Apache 2.0, mysql 4.0.24).

I stopped mysql and copied the data file structure over replacing ALL the database files on the new system (ie mysql db & tables as well), in order to get the same users and dbs on the new system.

It appeared to be running fine, but whenever I make a change to a particular database (I am using a site management gui called 42goisp which stores it's values in a mysql db - it also restarts services such as postfix and apache when changes are made), I get a system freeze for a few seconds... looking at the logs (an excert appears below), it appears that oom-killer is cutting in implying a memory leak somewhere.

Have I created this problem by the method in which I overwrote the default mysql database files (ie is there significant difference between the format of 4.0.18 & 4.0.24 files, or some machine-specific content I have overwritten?).
(if not then perhaps it is just a problem with the particular db file belonging to 42goisp).

Can anyone advise me if this is the case, and if so what I can do to retroactively cure the problem....

Thanks a bundle
Andy

<snip>
Jul 26 11:51:50 localhost kernel: oom-killer: gfp_mask=0x1d2
Jul 26 11:51:50 localhost kernel: DMA per-cpu:
Jul 26 11:51:50 localhost kernel: cpu 0 hot: low 2, high 6, batch 1
Jul 26 11:51:50 localhost kernel: cpu 0 cold: low 0, high 2, batch 1
Jul 26 11:51:50 localhost kernel: Normal per-cpu:
Jul 26 11:51:50 localhost kernel: cpu 0 hot: low 32, high 96, batch 16
Jul 26 11:51:50 localhost kernel: cpu 0 cold: low 0, high 32, batch 16
Jul 26 11:51:50 localhost kernel: HighMem per-cpu: empty
Jul 26 11:51:50 localhost kernel:
Jul 26 11:51:50 localhost kernel: Free pages: 2752kB (0kB HighMem)
Jul 26 11:51:50 localhost kernel: Active:61090 inactive:60234 dirty:0 writeback:0 unstable:0 free:688 slab:2778 mapped:121210 pagetables:889
Jul 26 11:51:50 localhost kernel: DMA free:1424kB min:20kB low:40kB high:60kB active:6012kB inactive:5992kB present:16384kB
Jul 26 11:51:50 localhost kernel: protections[]: 10 356 356
Jul 26 11:51:50 localhost kernel: Normal free:1328kB min:692kB low:1384kB high:2076kB active:238348kB inactive:234944kB present:498560kB
Jul 26 11:51:50 localhost kernel: protections[]: 0 346 346
Jul 26 11:51:50 localhost kernel: HighMem free:0kB min:128kB low:256kB high:384kB active:0kB inactive:0kB present:0kB
Jul 26 11:51:50 localhost kernel: protections[]: 0 0 0
Jul 26 11:51:50 localhost kernel: DMA: 0*4kB 0*8kB 33*16kB 14*32kB 1*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 1424kB
Jul 26 11:51:50 localhost kernel: Normal: 0*4kB 0*8kB 1*16kB 1*32kB 0*64kB 0*128kB 1*256kB 0*512kB 1*1024kB 0*2048kB 0*4096kB = 1328kB
Jul 26 11:51:50 localhost kernel: HighMem: empty
Jul 26 11:51:50 localhost kernel: Swap cache: add 11543237, delete 11543217, find 1415125/1447558, race 4+38
Jul 26 11:51:50 localhost kernel: Out of Memory: Killed process 981 (mysqld).
</snip>


Occasionaly getting:
'Out of Memory: Killed process 1631 (grpconv).'
instead of mysqld

Options: ReplyQuote


Subject
Views
Written By
Posted
duplicating mysql setup - Out-Of-Memory problem.... eek
6173
July 28, 2006 08:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.