On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote:
>
> 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.
Nice. :-)
> They average around 500 connections/second at any given time, two
> have a master/slave setup.
Connections/sec or Queries/sec? That's a lot of connections per
second? Can you use persistent connections? It would save a lot of
overhead.
> 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.
Care to share the config file? With that much RAM, there are probably
some things you can tweak to make optimal use of the 2GB RAM. But if
you've done a lot of that, I won't bother pointing them out
(obviously).
> 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?
How are things looking in SHOW STATUS? Any red flags that you've
noticed? Any slow queries?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 4 days, processed 103,895,494 queries (249/sec. avg)
---------------------------------------------------------------------
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
