RP Khare wrote:
> We are testing MySQL in production environment with real data. When the application
> is ready and all tests have been conducted well, we will finally migrate to MySQL
> At present our application is running on a desktop machine with MySQL 5.1 Community
> Edition installed on it. MySQL 5.1 is using default settings.
> Machine is: Pentium 4 with 256 MB RAM.
> What settings I need to change to tune MySQL?
I really do not want to offend you, but the question is silly.
If there were some way to definitely improve MySQL's performance without
causing any drawbacks or problems, it would be used in the default settings.
Default settings are meant to be usable for many installations, but
cannot be optimum for all. Users can leave them as provided and start
running their application, watch them, and check whether there are some
Once they see these, they can change the settings so as to avoid or at
least reduce these bottlenecks (as much as the hardware permits).
We readers here will never know what your bottlenecks are unless you
tell us. It might be cache sizes, number of concurrent users, select
The only general remark I dare make: 256 MB may be very little RAM for
most database servers, will be sufficient only if you have few users,
not much data, or can tolerate slow response times.
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@stripped
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028