I highly recommend Jeremy Zawodny's "High Performance MySQL" from O'Reilly.
Dan On 9/12/06, Gregory T Pelle <[EMAIL PROTECTED]> wrote:
Hello, I am looking for some advice regarding the tuning of a dedicated MySQL database server. The machine in questions is a Dell 2850 with dual Xeon procs and 4GB of memory running FreeBSD 6.1. Its sole purpose in life is to run the MySQL 5.0.x database engine serving out databases to multiple Apache servers. I started with the my-large.cnf file distributed with the MySQL port on FreeBSD 6.1. I made the following changes: set max_allowed_packet = 2M set-variable=max_connections=500 Now the questions: 1. What would be the recommended max_user_connections for the Dell 2850? 2. What is the practical maximum value that max_user_connections could be set to? I have been looking around for documentation regarding a max value for max_user connections and found the following: http://www-css.fnal.gov/dsg/external/freeware/mysqlTuning.html What documentation do others use for tuning MySQL? My goal is to convert our PHP and Perl applications we run on the Apache web servers to use persistent database connections to the dedicated MySQL server. -- Greg Pelle System Administrator Domain-it! Inc. -- 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]
