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.
.........
Rohit.
> Date: Tue, 11 Nov 2008 16:21:07 +0100
> From: [EMAIL PROTECTED]
> Subject: Re: Tuning a MySQL desktop database
> To: [EMAIL PROTECTED]
> CC: mysql@lists.mysql.com
>
> Rohit,
Rhoit,
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
http://books.google.ca/books?id=iaCCQ13_zMIC&pg=PA103&dq=mysql+performance+tuning#PPP1,M1
Mike
"
>
>
> 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
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
> 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, [EMAIL PROTECTED]
> 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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
