作者 主題: FC3 oom-killer 殺死mysqld, 造成當機  (閱讀 4978 次)

0 會員 與 1 訪客 正在閱讀本文。

benwu

  • 懷疑的國中生
  • **
  • 文章數: 71
  • 性別: 男
    • 檢視個人資料
    • 吳北北Xoops網站
FC3 oom-killer 殺死mysqld, 造成當機
« 於: 2008-03-23 11:01 »

FC3 記憶體4GB, swap 4GB
最近一直發生oom-killer 殺死mysqld, 造成當機, 必須重開機
請問高手們, 有何解決知道?

messages log如下:

Mar 22 23:36:32 educ kernel: oom-killer: gfp_mask=0x1d2
Mar 22 23:36:32 educ kernel: Mem-info:
Mar 22 23:36:32 educ kernel: DMA per-cpu:
Mar 22 23:36:32 educ kernel: cpu 0 hot: low 2, high 6, batch 1
Mar 22 23:36:32 educ kernel: cpu 0 cold: low 0, high 2, batch 1
Mar 22 23:36:32 educ kernel: cpu 1 hot: low 2, high 6, batch 1
Mar 22 23:36:32 educ kernel: cpu 1 cold: low 0, high 2, batch 1
Mar 22 23:36:32 educ kernel: Normal per-cpu:
Mar 22 23:36:32 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 22 23:36:32 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 22 23:36:32 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 22 23:36:32 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 22 23:36:32 educ kernel: HighMem per-cpu:
Mar 22 23:37:09 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 22 23:37:11 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 22 23:37:11 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 22 23:37:12 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 22 23:37:13 educ kernel:
Mar 22 23:37:14 educ kernel: Free pages:      116756kB (496kB HighMem)
Mar 22 23:37:15 educ kernel: Active:935844 inactive:37808 dirty:0 writeback:0 unstable:0 free:29189 slab:5873 mapped:977797 pagetables:6180
Mar 22 23:37:17 educ kernel: DMA free:12412kB min:68kB low:84kB high:100kB active:0kB inactive:0kB present:16384kB pages_scanned:12 all_unreclaimable? yes
Mar 22 23:37:22 educ kernel: lowmem_reserve[]: 0 880 4015
Mar 22 23:38:35 educ kernel: Normal free:103848kB min:3756kB low:4692kB high:5632kB active:564800kB inactive:149672kB present:901120kB pages_scanned:8199248 all_unreclaimable? yes
Mar 22 23:39:04 educ kernel: lowmem_reserve[]: 0 0 25083
Mar 22 23:39:35 educ kernel: HighMem free:496kB min:512kB low:640kB high:768kB active:3178576kB inactive:1560kB present:3210688kB pages_scanned:32064717 all_unreclaimable? yes
Mar 22 23:39:44 educ kernel: lowmem_reserve[]: 0 0 0
Mar 22 23:39:44 educ kernel: DMA: 19*4kB 20*8kB 19*16kB 19*32kB 14*64kB 7*128kB 7*256kB 5*512kB 1*1024kB 0*2048kB 1*4096kB = 12412kB
Mar 22 23:39:44 educ kernel: Normal: 478*4kB 7606*8kB 2176*16kB 42*32kB 3*64kB 3*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 1*4096kB = 103848kB
Mar 22 23:39:53 educ kernel: HighMem: 0*4kB 0*8kB 1*16kB 1*32kB 1*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 496kB
Mar 22 23:40:14 educ kernel: Swap cache: add 2125492, delete 2125252, find 405348/488474, race 5+40
Mar 22 23:40:39 educ kernel: Free swap  = 0kB
Mar 22 23:41:04 educ kernel: Total swap = 4173872kB
Mar 22 23:41:06 educ kernel: Free swap:            0kB
Mar 22 23:41:06 educ kernel: 1032048 pages of RAM
Mar 22 23:41:49 educ kernel: 802672 pages of HIGHMEM
Mar 22 23:41:51 educ kernel: 9525 reserved pages
Mar 22 23:41:53 educ kernel: 76699 pages shared
Mar 22 23:41:54 educ kernel: 240 pages swap cached
Mar 22 23:41:54 educ kernel: Out of Memory: Killed process 18642 (cronolog).
Mar 22 23:41:54 educ kernel: oom-killer: gfp_mask=0xd2
Mar 22 23:41:54 educ kernel: Mem-info:
Mar 22 23:41:55 educ kernel: DMA per-cpu:
Mar 22 23:41:56 educ kernel: cpu 0 hot: low 2, high 6, batch 1
Mar 22 23:41:59 educ kernel: cpu 0 cold: low 0, high 2, batch 1
Mar 22 23:41:59 educ kernel: cpu 1 hot: low 2, high 6, batch 1
Mar 22 23:42:00 educ kernel: cpu 1 cold: low 0, high 2, batch 1
Mar 22 23:42:00 educ kernel: Normal per-cpu:
Mar 22 23:42:02 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 22 23:42:03 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 22 23:42:03 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 22 23:42:04 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 22 23:42:04 educ kernel: HighMem per-cpu:
Mar 22 23:42:05 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 22 23:42:05 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 22 23:42:06 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 22 23:42:06 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 22 23:42:06 educ kernel:
Mar 22 23:42:06 educ kernel: Free pages:      116756kB (496kB HighMem)
Mar 22 23:42:06 educ kernel: Active:935435 inactive:38217 dirty:0 writeback:14 unstable:0 free:29189 slab:5873 mapped:977783 pagetables:6174
Mar 22 23:42:06 educ kernel: DMA free:12412kB min:68kB low:84kB high:100kB active:0kB inactive:0kB present:16384kB pages_scanned:12 all_unreclaimable? yes
Mar 22 23:42:06 educ kernel: lowmem_reserve[]: 0 880 4015
Mar 22 23:42:06 educ kernel: Normal free:103848kB min:3756kB low:4692kB high:5632kB active:564720kB inactive:149752kB present:901120kB pages_scanned:8200906 all_unreclaimable? yes
Mar 22 23:42:06 educ kernel: lowmem_reserve[]: 0 0 25083
Mar 22 23:42:06 educ kernel: HighMem free:496kB min:512kB low:640kB high:768kB active:3177020kB inactive:3116kB present:3210688kB pages_scanned:32065120 all_unreclaimable? yes
Mar 22 23:42:06 educ kernel: lowmem_reserve[]: 0 0 0
Mar 22 23:42:06 educ kernel: DMA: 19*4kB 20*8kB 19*16kB 19*32kB 14*64kB 7*128kB 7*256kB 5*512kB 1*1024kB 0*2048kB 1*4096kB = 12412kB
Mar 22 23:42:06 educ kernel: Normal: 478*4kB 7606*8kB 2176*16kB 42*32kB 3*64kB 3*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 1*4096kB = 103848kB
Mar 22 23:42:06 educ kernel: HighMem: 0*4kB 0*8kB 1*16kB 1*32kB 1*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 496kB
Mar 22 23:42:06 educ kernel: Swap cache: add 2125506, delete 2125252, find 405348/488475, race 5+40
Mar 22 23:42:06 educ kernel: Free swap  = 0kB
Mar 23 03:16:55 educ kernel: Total swap = 4173872kB
Mar 23 03:16:55 educ kernel: Free swap:            0kB
Mar 23 03:16:55 educ kernel: 1032048 pages of RAM
Mar 23 03:16:55 educ kernel: 802672 pages of HIGHMEM
Mar 23 03:16:55 educ kernel: 9525 reserved pages
Mar 23 03:16:55 educ kernel: 76629 pages shared
Mar 23 03:16:55 educ kernel: 253 pages swap cached
Mar 23 03:16:55 educ kernel: Out of Memory: Killed process 18643 (cronolog).
Mar 23 03:16:55 educ kernel: oom-killer: gfp_mask=0x80d2
Mar 23 03:16:55 educ kernel: Mem-info:
Mar 23 03:16:55 educ kernel: DMA per-cpu:
Mar 23 03:16:55 educ kernel: cpu 0 hot: low 2, high 6, batch 1
Mar 23 03:16:55 educ kernel: cpu 0 cold: low 0, high 2, batch 1
Mar 23 03:16:55 educ kernel: cpu 1 hot: low 2, high 6, batch 1
Mar 23 03:16:55 educ kernel: cpu 1 cold: low 0, high 2, batch 1
Mar 23 03:16:55 educ kernel: Normal per-cpu:
Mar 23 03:16:55 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 23 03:16:55 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 23 03:16:55 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 23 03:16:55 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 23 03:16:55 educ kernel: HighMem per-cpu:
Mar 23 03:16:55 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 23 03:16:55 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 23 03:16:55 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 23 03:16:55 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 23 03:16:55 educ kernel:
Mar 23 03:16:55 educ kernel: Free pages:      116880kB (496kB HighMem)
Mar 23 03:16:55 educ kernel: Active:773536 inactive:200660 dirty:0 writeback:0 unstable:0 free:29220 slab:5870 mapped:977765 pagetables:6168
Mar 23 03:16:56 educ kernel: DMA free:12412kB min:68kB low:84kB high:100kB active:0kB inactive:0kB present:16384kB pages_scanned:12 all_unreclaimable? yes
Mar 23 03:16:56 educ kernel: lowmem_reserve[]: 0 880 4015
Mar 23 03:16:56 educ kernel: Normal free:103972kB min:3756kB low:4692kB high:5632kB active:8832kB inactive:706944kB present:901120kB pages_scanned:4095547 all_unreclaimable? no
Mar 23 03:16:56 educ kernel: lowmem_reserve[]: 0 0 25083
Mar 23 03:16:56 educ kernel: HighMem free:496kB min:512kB low:640kB high:768kB active:3085312kB inactive:95696kB present:3210688kB pages_scanned:32894536 all_unreclaimable? yes
Mar 23 03:16:56 educ kernel: lowmem_reserve[]: 0 0 0
Mar 23 03:16:56 educ kernel: DMA: 19*4kB 20*8kB 19*16kB 19*32kB 14*64kB 7*128kB 7*256kB 5*512kB 1*1024kB 0*2048kB 1*4096kB = 12412kB
Mar 23 03:16:56 educ kernel: Normal: 509*4kB 7606*8kB 2176*16kB 42*32kB 3*64kB 3*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 1*4096kB = 103972kB
Mar 23 03:16:56 educ kernel: HighMem: 0*4kB 0*8kB 1*16kB 1*32kB 1*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 496kB
Mar 23 03:16:56 educ kernel: Swap cache: add 2125518, delete 2125278, find 405348/488475, race 5+40
Mar 23 03:16:56 educ kernel: Free swap  = 0kB
Mar 23 03:16:56 educ kernel: Total swap = 4173872kB
Mar 23 03:16:56 educ kernel: Free swap:            0kB
Mar 23 03:16:56 educ kernel: 1032048 pages of RAM
Mar 23 03:16:56 educ kernel: 802672 pages of HIGHMEM
Mar 23 03:16:56 educ kernel: 9525 reserved pages
Mar 23 03:16:56 educ kernel: 75984 pages shared
Mar 23 03:16:56 educ kernel: 240 pages swap cached
Mar 23 03:16:56 educ kernel: Out of Memory: Killed process 18644 (cronolog).
Mar 23 03:16:56 educ kernel: oom-killer: gfp_mask=0x80d2
Mar 23 03:16:56 educ kernel: Mem-info:
Mar 23 03:16:56 educ kernel: DMA per-cpu:
Mar 23 03:16:56 educ kernel: cpu 0 hot: low 2, high 6, batch 1
Mar 23 03:16:56 educ kernel: cpu 0 cold: low 0, high 2, batch 1
Mar 23 03:16:56 educ kernel: cpu 1 hot: low 2, high 6, batch 1
Mar 23 03:16:56 educ kernel: cpu 1 cold: low 0, high 2, batch 1
Mar 23 03:16:56 educ kernel: Normal per-cpu:
Mar 23 03:16:56 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 23 03:16:56 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 23 03:16:56 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 23 03:16:56 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 23 03:16:56 educ kernel: HighMem per-cpu:
Mar 23 03:16:56 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 23 03:16:57 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 23 03:16:57 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 23 03:16:57 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 23 03:16:57 educ kernel:
Mar 23 03:16:57 educ kernel: Free pages:      116880kB (496kB HighMem)
Mar 23 03:16:57 educ kernel: Active:775117 inactive:199072 dirty:0 writeback:12 unstable:0 free:29220 slab:5870 mapped:977746 pagetables:6162
Mar 23 03:16:57 educ kernel: DMA free:12412kB min:68kB low:84kB high:100kB active:0kB inactive:0kB present:16384kB pages_scanned:12 all_unreclaimable? yes
Mar 23 03:16:57 educ kernel: lowmem_reserve[]: 0 880 4015
Mar 23 03:16:57 educ kernel: Normal free:103972kB min:3756kB low:4692kB high:5632kB active:15312kB inactive:700464kB present:901120kB pages_scanned:4097230 all_unreclaimable? no
Mar 23 03:16:57 educ kernel: lowmem_reserve[]: 0 0 25083
Mar 23 03:16:57 educ kernel: HighMem free:496kB min:512kB low:640kB high:768kB active:3085284kB inactive:95696kB present:3210688kB pages_scanned:32894536 all_unreclaimable? yes
Mar 23 03:16:57 educ kernel: lowmem_reserve[]: 0 0 0
Mar 23 03:16:57 educ kernel: DMA: 19*4kB 20*8kB 19*16kB 19*32kB 14*64kB 7*128kB 7*256kB 5*512kB 1*1024kB 0*2048kB 1*4096kB = 12412kB
Mar 23 03:16:57 educ kernel: Normal: 509*4kB 7606*8kB 2176*16kB 42*32kB 3*64kB 3*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 1*4096kB = 103972kB
Mar 23 03:16:57 educ kernel: HighMem: 0*4kB 0*8kB 1*16kB 1*32kB 1*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 496kB
Mar 23 03:16:57 educ kernel: Swap cache: add 2125530, delete 2125278, find 405348/488475, race 5+40
Mar 23 03:16:57 educ kernel: Free swap  = 0kB
Mar 23 03:16:57 educ kernel: Total swap = 4173872kB
Mar 23 03:16:57 educ kernel: Free swap:            0kB
Mar 23 03:16:57 educ kernel: 1032048 pages of RAM
Mar 23 03:16:57 educ kernel: 802672 pages of HIGHMEM
Mar 23 03:16:57 educ kernel: 9525 reserved pages
Mar 23 03:16:57 educ kernel: 75903 pages shared
Mar 23 03:16:57 educ kernel: 252 pages swap cached
Mar 23 03:16:57 educ kernel: Out of Memory: Killed process 18648 (httpd).
Mar 23 03:16:57 educ kernel: oom-killer: gfp_mask=0xd2
Mar 23 03:16:57 educ kernel: Mem-info:
Mar 23 03:16:57 educ kernel: DMA per-cpu:
Mar 23 03:16:57 educ kernel: cpu 0 hot: low 2, high 6, batch 1
Mar 23 03:16:57 educ kernel: cpu 0 cold: low 0, high 2, batch 1
Mar 23 03:16:57 educ kernel: cpu 1 hot: low 2, high 6, batch 1
Mar 23 03:16:58 educ kernel: cpu 1 cold: low 0, high 2, batch 1
Mar 23 03:16:58 educ kernel: Normal per-cpu:
Mar 23 03:16:58 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 23 03:16:58 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 23 03:16:58 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 23 03:16:58 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 23 03:16:58 educ kernel: HighMem per-cpu:
Mar 23 03:16:58 educ kernel: cpu 0 hot: low 62, high 186, batch 31
Mar 23 03:16:58 educ kernel: cpu 0 cold: low 0, high 62, batch 31
Mar 23 03:16:58 educ kernel: cpu 1 hot: low 62, high 186, batch 31
Mar 23 03:16:58 educ kernel: cpu 1 cold: low 0, high 62, batch 31
Mar 23 03:16:58 educ kernel:
Mar 23 03:16:58 educ kernel: Free pages:      116960kB (496kB HighMem)
Mar 23 03:16:58 educ kernel: Active:622844 inactive:350874 dirty:0 writeback:0 unstable:0 free:29240 slab:5676 mapped:977826 pagetables:6171
Mar 23 03:16:58 educ kernel: DMA free:12412kB min:68kB low:84kB high:100kB active:0kB inactive:0kB present:16384kB pages_scanned:850 all_unreclaimable? yes
Mar 23 03:16:58 educ kernel: lowmem_reserve[]: 0 880 4015
Mar 23 03:16:58 educ kernel: Normal free:104052kB min:3756kB low:4692kB high:5632kB active:726304kB inactive:4kB present:901120kB pages_scanned:1347969 all_unreclaimable? yes
Mar 23 03:16:58 educ kernel: lowmem_reserve[]: 0 0 25083
Mar 23 03:16:58 educ kernel: HighMem free:496kB min:512kB low:640kB high:768kB active:1765072kB inactive:1403492kB present:3210688kB pages_scanned:10120989 all_unreclaimable? yes
Mar 23 03:16:58 educ kernel: lowmem_reserve[]: 0 0 0
Mar 23 03:16:58 educ kernel: DMA: 19*4kB 20*8kB 19*16kB 19*32kB 14*64kB 7*128kB 7*256kB 5*512kB 1*1024kB 0*2048kB 1*4096kB = 12412kB
Mar 23 03:16:58 educ kernel: Normal: 385*4kB 7582*8kB 2222*16kB 43*32kB 3*64kB 3*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 1*4096kB = 104052kB
Mar 23 03:16:58 educ kernel: HighMem: 0*4kB 0*8kB 1*16kB 1*32kB 1*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 496kB
Mar 23 03:16:58 educ kernel: Swap cache: add 2180372, delete 2180132, find 410825/498057, race 6+42
Mar 23 03:16:58 educ kernel: Free swap  = 0kB
Mar 23 03:16:58 educ kernel: Total swap = 4173872kB
Mar 23 03:16:58 educ kernel: Free swap:            0kB
Mar 23 03:16:58 educ kernel: 1032048 pages of RAM
Mar 23 03:16:58 educ kernel: 802672 pages of HIGHMEM
Mar 23 03:16:58 educ kernel: 9525 reserved pages
Mar 23 03:16:58 educ kernel: 76749 pages shared
Mar 23 03:16:58 educ kernel: 240 pages swap cached
Mar 23 03:16:58 educ kernel: Out of Memory: Killed process 18617 (mysqld).
Mar 23 10:11:31 educ syslogd 1.4.1: restart.

湯姆貓

  • 活潑的大學生
  • ***
  • 文章數: 475
    • 檢視個人資料
回覆: FC3 oom-killer 殺死mysqld, 造成當機
« 回覆 #1 於: 2008-03-23 11:51 »
Mar 22 23:41:54 educ kernel: Out of Memory: Killed process 18642 (cronolog).

Mar 23 03:16:57 educ kernel: Out of Memory: Killed process 18648 (httpd).

Mar 23 03:16:58 educ kernel: Out of Memory: Killed process 18617 (mysqld).

這兒不是寫了嗎??
記憶體不足,亂砍啦~~~
Swap 4G都吃光,加一下記憶體.
要不就看那兒可以把記憶體用量減少.

剛才重看原來記憶體已經是4G了,
一共8G通通吃光,
有誇張到~~~~先看那幾支程式吃最兇..
« 上次編輯: 2008-03-23 11:53 由 湯姆貓 »

benwu

  • 懷疑的國中生
  • **
  • 文章數: 71
  • 性別: 男
    • 檢視個人資料
    • 吳北北Xoops網站
回覆: FC3 oom-killer 殺死mysqld, 造成當機
« 回覆 #2 於: 2008-03-24 20:52 »
經過一天的奮鬥, 終於稍微減緩httpd 及 mysqld 消耗太多記憶體,而導致oom-kuller 停掉httpd 及 mysqld
造成當機

解決的方法是:
1.因為當機造成強迫關機,致使xoops資料庫某個資料表毀損,使得xoops網站無法順利登入

2.用myisamchk修復所有資料庫 *MYI檔

3.重新開機後,網站恢復正常,以前4GB記憶體都快用到滿,現在僅佔用1.7G左右,但偶而httpd 及 mysqld 偶而會佔用CPU 99.8%, 不知是否正常,觀察了一天, 不再發生oom-killer 了

僅供参考 ,持續觀察中

湯姆貓

  • 活潑的大學生
  • ***
  • 文章數: 475
    • 檢視個人資料
回覆: FC3 oom-killer 殺死mysqld, 造成當機
« 回覆 #3 於: 2008-03-24 21:08 »
如果沒有什麼特別的原因,
把資料庫格式換成InnoDB.
可以降低資料表毀損的機率,
也可以增加資料庫的效能.

benwu

  • 懷疑的國中生
  • **
  • 文章數: 71
  • 性別: 男
    • 檢視個人資料
    • 吳北北Xoops網站
回覆: FC3 oom-killer 殺死mysqld, 造成當機
« 回覆 #4 於: 2008-03-24 21:59 »
如果沒有什麼特別的原因,
把資料庫格式換成InnoDB.
可以降低資料表毀損的機率,
也可以增加資料庫的效能.

謝謝你的建議
但我完全不懂mysql, 不知如何下手 ?
可否指導一下?

湯姆貓

  • 活潑的大學生
  • ***
  • 文章數: 475
    • 檢視個人資料
回覆: FC3 oom-killer 殺死mysqld, 造成當機
« 回覆 #5 於: 2008-03-25 11:05 »
完全不懂.....那.....就從設定開始吧....
請參考~~
http://dev.mysql.com/doc/refman/5.0/en/innodb.html

damon

  • 管理員
  • 俺是博士!
  • *****
  • 文章數: 4227
    • 檢視個人資料
    • http://blog.damon.tw/
回覆: FC3 oom-killer 殺死mysqld, 造成當機
« 回覆 #6 於: 2008-03-25 11:22 »
換架構吧,你現在調好了,之後上線人數在成長的話也是一樣搞不定,換3層式架構吧
r proxy <--> http server(apache + php or iis + asp) <--> db server
硬擠在同一台,早晚這樣的問題還是會一再發生,還不如一次改成這樣的架構,之後哪裡不夠就加哪裡

湯姆貓

  • 活潑的大學生
  • ***
  • 文章數: 475
    • 檢視個人資料
回覆: FC3 oom-killer 殺死mysqld, 造成當機
« 回覆 #7 於: 2008-03-25 11:52 »
支持+1
雖然換InnoDB會好一些,
但http server跟db server弄在同一台,
怎麼跑都會遇到一樣的問題.

如果沒預算弄3層式....最起碼先把http及db分開.