256MB小内存MySQL配置优化

 1 [client]
 2 port = 3306
 3 socket = /var/run/mysqld/mysqld.sock
 4 
 5 [mysqld_safe]
 6 socket = /var/run/mysqld/mysqld.sock
 7 nice = 0
 8 
 9 [mysqld]
10 user = mysql
11 pid-file = /var/run/mysqld/mysqld.pid
12 socket = /var/run/mysqld/mysqld.sock
13 port = 3306
14 basedir = /usr
15 datadir = /var/lib/mysql
16 tmpdir = /tmp
17 language = /usr/share/mysql/english
18 skip-external-locking
19 bind-address = 127.0.0.1
20 default-storage-engine=MYISAM
21 skip-innodb
22 key_buffer = 16k
23 max_allowed_packet = 1M
24 thread_stack = 64K
25 thread_cache_size = 4
26 table_cache = 4
27 sort_buffer_size = 32K
28 read_buffer_size = 256K
29 read_rnd_buffer_size = 256K
30 net_buffer_length = 2K
31 query_cache_limit = 1M
32 query_cache_size = 5M
33 
34 [mysqldump]
35 quick
36 quote-names
37 max_allowed_packet = 16M
38 
39 [mysql]
40 no-auto-rehash
41 #safe-updates
42 
43 [isamchk]
44 key_buffer = 8M
45 sort_buffer_size = 8M
46 
47 [myisamchk]
48 key_buffer = 8M
49 sort_buffer_size = 8M
50 
51 [mysqlhotcopy]
52 interactive-timeout

 

转载于:https://www.cnblogs.com/imzye/p/5084297.html