is read block write?
Posted by:
h ch
Date: October 10, 2011 01:02AM
i have a slave ,and sql thread is behind master a lot
Seconds_Behind_Master: 22210
and the slave is read only ,i often observe like the following info use show processllist,and slave use myisam table,is it possiable the write is blocked by read?
+-------+-------------+---------------------+------------+---------+-------+----------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-------------+---------------------+------------+---------+-------+----------------------------------+------------------------------------------------------------------------------------------------------+
| 1 | system user | | NULL | Connect | 4048 | Waiting for master to send event | NULL |
| 2 | system user | | trade_lead | Connect | 26717 | Locked | insert into trade(id, sid, product, product_en, cas_no, spec, channel, title, webSite, type, categor |
| 14852 | root | localhost | trade_lead | Query | 0 | NULL | show processlist |
| 33073 | content | 10.103.33.127:53760 | trade_lead | Query | 1 | Sorting result | select t.id,t.pubDate,t.status,t.type,t.product,t.price,t.company,t.pic_name1 from trade as t where |
| 33091 | content | 10.103.33.227:36587 | trade_lead | Query | 0 | Locked | select pc.* from trade_lead.trade as pc where pc.type = '12' and poster = 'yangyang2790' order by p |
| 33094 | content | 10.103.33.177:34112 | trade_lead | Query | 0 | Locked | select pc.* from trade_lead.trade as pc where pc.type = '12' and poster = 'zpwhm1' order by pc.pubD |
| 33099 | content | 10.103.33.177:34148 | trade_lead | Query | 0 | Locked | select * from trade_lead.trade as pc where pc.type = 12 and pc.poster='gzadb' |
| 33101 | content | 10.103.33.227:36632 | trade_lead | Sleep | 1 | NULL | NULL