Hi everybody
As we know that replication process uses 3 threads-
1. Master thread (Binlog Dump)
2. I/O thread
3. Sql Thread

Now I have some confusion regarding these thing --

- In peek hours what will be the cpu and memory utilization of these
threads
and if there is high load on master thread then what will be the
effects of this in mysql performance.

- if sql thread executing query on slave server and that time if we
fire a select query on same table then what will happen.Select query
will wait or not

We are using innodb tables in both master and slave

??????????
Pawan.Ghildiyal [at] gmail.com wrote:
> Hi everybody
> As we know that replication process uses 3 threads-
> 1. Master thread (Binlog Dump)
> 2. I/O thread
> 3. Sql Thread
>
> Now I have some confusion regarding these thing --
>
> - In peek hours what will be the cpu and memory utilization of these
> threads
> and if there is high load on master thread then what will be the
> effects of this in mysql performance.
>
> - if sql thread executing query on slave server and that time if we
> fire a select query on same table then what will happen.Select query
> will wait or not
>
> We are using innodb tables in both master and slave