MySQL/Optimization

MySQL memory optimization

memory = key_buffer + (sort_buffer_size + read_buffer_size) * max_connections

ie. 64 + (1 + 1) * 200 = 464MB

[mysqld] set-variable = max_connections = 500