INNODB是MySQL被ORACLE收购后开发的，支持事务和行级锁等高级功能，但是并不是所有人都需要INNODB的，对大部分人来说，以前的MYISAM引擎就够了，一般会选择将默认引擎改为MYISAM，但是INNODB还是会耗费内存和硬盘，这时候，就需要把INNODB彻底禁用。
在以前的MySQL中，一般可以这么设置就行了：
|
1
2
|
default
-
storage
-
engine
=
MYISAM
skip
-
innodb
|
但是在最新的MySQL5.6里，这么设置是没法启动的，需要再增加一句设置：
|
1
|
default
-
tmp
-
storage
-
engine
=
MYISAM
|
不仅如此，还需要添加以下配置，否则程序会很容易退出的：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
loose
-
innodb
-
trx
=
0
loose
-
innodb
-
locks
=
0
loose
-
innodb
-
lock
-
waits
=
0
loose
-
innodb
-
cmp
=
0
loose
-
innodb
-
cmp
-
per
-
index
=
0
loose
-
innodb
-
cmp
-
per
-
index
-
reset
=
0
loose
-
innodb
-
cmp
-
reset
=
0
loose
-
innodb
-
cmpmem
=
0
loose
-
innodb
-
cmpmem
-
reset
=
0
loose
-
innodb
-
buffer
-
page
=
0
loose
-
innodb
-
buffer
-
page
-
lru
=
0
loose
-
innodb
-
buffer
-
pool
-
stats
=
0
loose
-
innodb
-
metrics
=
0
loose
-
innodb
-
ft
-
default
-
stopword
=
0
loose
-
innodb
-
ft
-
inserted
=
0
loose
-
innodb
-
ft
-
deleted
=
0
loose
-
innodb
-
ft
-
being
-
deleted
=
0
loose
-
innodb
-
ft
-
config
=
0
loose
-
innodb
-
ft
-
index
-
cache
=
0
loose
-
innodb
-
ft
-
index
-
table
=
0
loose
-
innodb
-
sys
-
tables
=
0
loose
-
innodb
-
sys
-
tablestats
=
0
loose
-
innodb
-
sys
-
indexes
=
0
loose
-
innodb
-
sys
-
columns
=
0
loose
-
innodb
-
sys
-
fields
=
0
loose
-
innodb
-
sys
-
foreign
=
0
loose
-
innodb
-
sys
-
foreign
-
cols
=
0
|
摘自http://docs.oracle.com/cd/E17952_01/refman-5.6-en/innodb-turning-off.html
210
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
