On Fri, Oct 24, 2003 at 04:00:07AM +0200, Benjamin KRIEF wrote:
Is your bottleneck CPU, I/O, or lock contention?
Is your slave running on worse hardware than your master?
my bottleneck is CPU , definitely. the load can go up to 35 in peak hours.
no swapping occurs , my key efficiency
hi Jeremy , thanks (again, tell me if it's to much=) for helping me.
i've got to admit here that i'm reaching the maximum of my linux skills.
i've used top,free,iostat and sar , without finding the answers i need.
for instance , on the master (dual P3 1Ghz , 1G ram, running only mysql,
with
On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote:
hi guys,
i've just finished implementing replication on 2 production servers.
[snip]
the problem is that it's quite impossible to fine tune the load between
the servers , and my slave is a bit too busy , so the replication
hi , and thanks for your answer,
On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote:
the problem is that it's quite impossible to fine tune the load between
the servers , and my slave is a bit too busy , so the replication thread
is becoming very slow , and sometimes , i can see
hi guys,
i've just finished implementing replication on 2 production servers.
i'm using round robin dns to balance the load between the slave the master.
as you would presume , the master handle all the updates, and 1/2 of the
selects , the slave handle the other 1/2 of the selects.
the