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]
