Á¦¸ñ |
109 : [MySQL] mysql memory setting table |
À̸§ |
»êÀÌ [Ȩ]http://linuxchannel.net/ |
[mysql memory setting table]
key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connection => total memory
512 + (3 + 3) * 80 => 1G
512 + (3 + 2) * 100 => 1G
512 + (2 + 2) * 128 => 1G
512 + (2 + 1) * 170 => 1G
512 + (1 + 1) * 256 => 1G
384 + (3 + 3) * 100 => 1G
384 + (3 + 2) * 128 => 1G
384 + (2 + 2) * 160 => 1G
384 + (2 + 1) * 210 => 1G
384 + (1 + 1) * 320 => 1G
256 + (3 + 3) * 128 => 1G
256 + (3 + 2) * 150 => 1G
256 + (2 + 2) * 192 => 1G
256 + (2 + 1) * 256 => 1G
256 + (1 + 1) * 380 => 1G
*)
max_connection => number of httpd ESTABLESHED(or MaxClient) |
2005³â 01¿ù 03ÀÏ 02:04:43 ¿ù(»õº®) from 61.254.75.78 |