Basic (maybe?) question on some optimal variables for MySQLd's my.cnf
configuration ..
Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU P3 1ghz.
They average around 500 connections/second at any given time, two have a
master/slave setup.
MySQL is prettty much the only thing running, nice'd at -20 on a Patched
Linux 2.4.9 along w/patched glibc 2.2.4 (LinuxThreads patches).
Its run smoothly when I tested it w/~4000 connections and didn't skip a
beat. The question basically goes with, I'm expecting to get
around 1-2,000 connections/second on average on the systems, using a
modified 'my-huge.cnf' from the distribution.
No InnoDB, BDB, or overly huge blobs being used.
On average each query joins w/about 4 tables on primary/unique indexes where
possible.
Any changes for this many connections/ram that would be suggested?
Thanks,
Weslee
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
