What is the best use of memory in MySQL? I have a MySql server with 2Gb of memory. What's the best configuration to use then with best results? How can I "distribute" this memory fine to MySql server?
This strongly depends on the application using the database. A good starting point for optimization is the MySQL Performance Tuning Primer Script