someone say:
seconds_behinds_master = time in I/O thread - time in SQL thread
time in I/O thread is current timestamp,
time in SQL thread is the timestamp record in binlog, this binlog is
originates from
master, so it is the timestamp when binlog is generated in master.
Is this correct?
2011/10/
On 28 Oct 2011, at 10:03, 王科选 wrote:
> According to ,
>
> seconds_behinds_master is inaccurate, so I just skipped how it works...
> If you want to measure slave lag, follow that book's suggestion:
> One good solution is a heartbeat record,which is a timestamp that you update
> once persecond on t
On 10/28/2011 3:38 PM, jiangwen jiang wrote:
Hi, all:
I am confusing with seconds_behind_master, in mysql manual, it says:
In essence, this field measures the time difference in seconds between the
slave SQL thread and the slave I/O thread.
how to understand this description:
1. seconds_behinds
Hi, all:
I am confusing with seconds_behind_master, in mysql manual, it says:
In essence, this field measures the time difference in seconds between the
slave SQL thread and the slave I/O thread.
how to understand this description:
1. seconds_behinds_master = ts in SQL thread - ts in I/O thread,
Hey,
Having recovered from the trip and gone through my backlog, I would like to
take a moment to thank the nice people at Percona and all the speakers they
gathered for organizing a truly excellent MySQL conference last weekend.
I had fun, I gained new insights and I got my eye on a couple o
- Original Message -
> From: "a bv"
>
> I have a phpsyslog-ng box with different tables and disk usage is
I assume that means you have a syslog service that logs to a MySQL database?
> growing so fast nearly no space left. How must i move the old
> files? Is it ok to move just like a
