RE: 4.0.20 replication

Hello Sinisa

> Seems like we shall need to take a deeper look at this.
OK.

> Can you send us your master my.cnf

# The following options will be passed to all MySQL clients
[client]
port            = 3306
socket          = /tmp/mysql.3306.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.3306.sock
datadir         = /db01/offline/data
skip-locking
set-variable    = key_buffer=256M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=1024
set-variable    = max_connections=512
set-variable    = sort_buffer=1M
set-variable    = record_buffer=1M
set-variable    = myisam_sort_buffer_size=64M
set-variable    = thread_cache=8
set-variable    = thread_concurrency=8  # Try number of CPU's*2
log-bin
server-id       = 880673316

[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash


>tell us what to do exactly to get 110 or more connections for 10 slaves ??
  BTW. It will increase to 512 if I let it (see max-connections above)

The machine its running on:
uname -a Linux robinson.star.bnl.gov 2.4.20-30.7.legacysmp #1 SMP Fri Feb 20
10:12:55 PST 2004 i686 unknown

The slaves are on similar machines running your binaries of versions ranging
from 4.0.16 to 4.0.20.

I've been running this type of replication for years, and with no problems.
I've done nothing different or special in setting this up.  It is pretty
much done right our of Paul's book.  

One point you will be interested in...
I've recently upgraded the master from 3.23.58 to 4.0.20, this is when the
problem began. All my slaves where 4.0.xx for over a year now. (yes I ran
mysql_fix_privilege_tables).

Replication is being done. Show master status corresponds to show slave
status etc.  The connections, however, keep growing.

I gladly supply any information I can and help in any way possible.  Also I
was going to drop back a version on the master, but I'll keep this one
running as long as I know your working on the problem.

Thanks
Michael


> -----Original Message-----
> From: Sinisa Milivojevic [mailto:[email protected]]
> Sent: Wednesday, June 16, 2004 5:36 AM
> To: DePhillips, Michael P
> Cc: [email protected]
> Subject: RE: 4.0.20 replication
> 
> DePhillips, Michael P writes:
> > > And how many binlog dumping connections are there ???
> >
> > As of now there are ~110 and this number is increasing over time.  Last
> > night when I restarted the (master) server @~2:00 am EST there were ~10
> as
> > expected then slowly the binlog connections began to increase.  This
> will
> > continue until I run out of connections again - (which, of course will
> be at
> > 2:00 am) or until I restart the server.
> >
> > > And are you using our binary ??
> >  yes - mysql-standard-4.0.20-pc-linux-i686.tar.gz
> >
> >
> >
> 
> Seems like we shall need to take a deeper look at this.
> 
> Can you send us your master my.cnf and tell us what to do exactly to
> get 110 or more connections for 10 slaves ??
> 
> --
> 
> Sincerely,
> 
> --
> For technical support contracts, go to https://order.mysql.com/?ref=msmi
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB
> /_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
>        <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]