Joeffrey Betita wrote:
hello
i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz,
httpd-2.0.54.tar.gz, php-5.0.4.tar.gz etc. on a Intel(R) Pentium(R) 4 CPU
2.40GHz with 1GB RAM this is just a temporary until we buy a new high end
server. my-large.cnf is the configuration in the /etc/my.cnf CentOS release
4.0 (Final) is the linux distribution. what is the ideal configuration so
that 20,000 user does not encounter the "too many connections error" when
they browse our website. thank you very much.
Do you work for Intel? Or do you just like putting (R) after every
Registered Trademark(R)? Anyway, on to your problem...
Do you expect 20,000 users to all hit your website within a second or so
of each other? Somehow I doubt that. The "too many connections error"
refers to how many connections can be open *to the MySQL server* at once.
When someone is just viewing one of your pages, they don't have a
connection open to Apache, and therefore your PHP scripts aren't holding
a MySQL connection open (unless you use persistent connections to MySQL,
which isn't the default for PHP).
You will only experience a problem if the number of connections at once
is greater than the number set up in my.cnf. For example, if MySQL is
set up to handle 1000 connections, then it can handle 1000 people all
hitting refresh or entering the URL of your website, all at once. There
might be 100,000 people looking at your website, but as long as 1000 of
them don't all click a link at once, you're sweet.
Jasper
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
