Thanks for your suggestion. I tried binary install
but the problem doesn't disappear. Though mysql no
longer consume 99% CPU, the load still go up till
the server hangs. Wonder why.
I seem to have a workaround now. My application
does lots of INSERTs, and after I change them to
INSERT DELAYED, the
At first, I thought it was a low memory problem. I
reduced my buffers in my.cnf and run the test
again. The master still hung and this is a
screenshot of "top" command just before it died:
http://choonkeng.hopto.org/temp/replication-hang.gif
There are still plenty of memory and no disk
swapping w
if you dont want to add an auto-increment column,
you can probably specify ALL columns and their
values in WHERE clause and end with LIMIT 1.
eg:
DELETE FROM Table WHERE Column1=Value1 AND
Column2=Value2 ... LIMIT 1
--- Manisha Sathe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Here i am again. I can
maybe u can try:
mysql -u [EMAIL PROTECTED] -p -h dnsbasedhostname
--- Jonas Ladenfors <[EMAIL PROTECTED]>
wrote:
> Hello, Is there someway to specify which domain
> one would like to connect
> from in the mysql console. When connecting on my
> server I always get
> connected through localhost.
Hello everyone,
The master is moderately busy with load average of
2-3. This has worked very well for a long time
before I started replication (few months). When
replication is started, both master and slave
appear to work fine with no significant increase of
load on either side.
But, after a fe
> What about using binlog-do-db=database_name
option? In this case only updates will be logged if
the current database is database_name
What if I only wish to replicate a few tables of a
database? Using binlog-do-db=database_name does
limit to this particular database but there is no
binlog-ignore
Dear all,
I am new to mysql replication. I know how to use
the --replicate* options but I would like to know
whether the options act as filter on the master or
on the slave...
>From the documentation, it says:
"The --replicate-* rules are evaluated as follows
to determine whether a statement wil