At 09:36 AM 11/11/2008, you wrote:
>Thanks for the answer.
>Maximum five users will work. The machine on which I am testing is the
>minimum configuration my client has. Attached is the "My.ini" file.
> > Date: Tue, 11 Nov 2008 16:21:07 +0100
> > From: Joerg.Bruehe@stripped
> > Subject: Re: Tuning a MySQL desktop database
> > To: passionate_programmer@stripped
> > CC: mysql@stripped
> > Rohit,
Have you looked at "High Performance MySQL: Optimization, Backups,
Replication, and More" from O'Reilly Books? It's available from Amazon. I
believe Google Books has a few chapters of the previous version online at
> > 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 Enterprise.
> > >
> > > 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
> > 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
> > bottlenecks.
> > 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
> > strategies, ...
> > 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.
> > Jörg
> > --
> > 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
>What's on the ramp today could be on the streets tomorrow. Keep up with
>trends on MSN Lifestyle Try it!
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1