On Mon, 2002-07-15 at 10:39, [EMAIL PROTECTED] wrote:
> 
> I am wanting to set up a database server using Red Hat Linux and MySQL.
> 
> I am wondering if anyone else out there has done this and if anyone has some
> tips or resources they could point me to.
> 
> I am interested in how best to setup the Linux system for database
> performance as well as what kind of hardware, in particular good, fast RAID
> controllers are available for use under Red Hat.

Performance tuning is very closely related to the task for which you
want to tune.  There's very little "generic" advice that will always
work.  We don't know how big your databases are, how complex the queries
will be, how many concurrent connections the server needs to support,
whether the connections are local or remote, ratio of reads to writes,
or any other information relevant to tuning your system for
performance.  Optimizing for a system with very complex queries on very
large databases would almost certainly not be what you'd want for a
smaller database with many writes and simple queries.

You'll probably just need to just set up the database on a default
system, and evaluate whether or not it *needs* tuning.  IF it needs
tuning, THEN you can figure out WHERE the bottlenecks are.  Optimizing
blindly won't help :)

If you want some simple advice:  compare the performance of PostgreSQL
and MySQL on your specific application.  In many cases PostgreSQL
performs better, and provides better SQL 92 compliance and data
integrity features.  If your results aren't very good, start by adding
RAM.  RAM is used for disk caching, and will bring a huge performance
benefit if there's any disk reads during normal operation.





_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list

Reply via email to