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
