|
发表于 2013-9-3 10:26:20
|
显示全部楼层
本帖最后由 terranboy 于 2013-9-3 10:27 编辑
! k: Z. g* N# L8 h) r( A) A4 c$ Q' l) S6 y+ D( R) X& F* i1 @7 y; G
几个参数改一下" K" J- }7 Q/ ^+ ?8 s4 |2 C
# vim /etc/my.cnf
% S4 \0 z$ }# \/ _4 c: y& \0 r 9 g1 h2 \6 i# W: k _ j( y# E& `
key_buffer_size = 256M: f2 Z/ ^0 F8 T* ? [; S' _
max_allowed_packet = 4M* U8 |% K0 x3 k; i- u
table_open_cache = 10243 \* z' B6 J0 c; a. Y
sort_buffer_size = 6M
" {* G1 z# l2 o: Hnet_buffer_length = 8K
; \, y1 S" N8 ~read_buffer_size = 4M
- r o" J' ~ X: pjoin_buffer_size = 8M4 e' H! T1 M' w+ N9 _5 N8 c" z
read_rnd_buffer_size = 32M
" X& s3 r6 |; J3 a- A: c4 q, \tmp_table_size = 256M
; E6 M( J Z; N) G1 D; W: @myisam_sort_buffer_size =64M/ w, f0 y) J/ E8 U
query_cache_size= 128M
4 i8 h" h; i- D( v- r, y
' f4 O9 D9 e6 m8 X/ ?. C- E重启MYSQL: g3 w( m$ n& o; k5 W
" o, F+ x/ V9 J1 k2 b. c; ?
现在都从MYSQL转到MARIADB了 性能比MYSQL好 完全兼容的) `9 I% p9 m; ?! O P! V
* B6 I7 W" c6 I9 g& O5 i* R7 @
i O" q5 [/ B( V4 r |
|