mysql 主从老出错_求救： mysql 主从同步，配置好后，跑上一段时间，就出现如此错误了，求指点...

56 阅读 0 评论 37 点赞

我是靠谱客的博主无奈口红，最近开发中收集的这篇文章主要介绍mysql 主从老出错_求救： mysql 主从同步，配置好后，跑上一段时间，就出现如此错误了，求指点...，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

2015-08-21 09:59:51 +08:00

@coolwind

| mysql-bin.000060 | 4951916 | Update_rows | 1 | 4952598 | table_id: 2753 flags: STMT_END_F |

| mysql-bin.000060 | 4952598 | Query | 1 | 4952672 | COMMIT |

| mysql-bin.000060 | 4952672 | Query | 1 | 4952809 | use `kjrs_crm2`; DELETE FROM `kjrs_crm2`.`crm_sessions_data` WHERE expiry < 1439993091 |

| mysql-bin.000060 | 4952809 | Query | 1 | 4952941 | use `kjrs_crm2`; DELETE FROM `kjrs_crm2`.`crm_sessions` WHERE expiry < 1439993094 |

| mysql-bin.000060 | 4952941 | Query | 1 | 4953014 | BEGIN |

| mysql-bin.000060 | 4953014 | Table_map | 1 | 4953118 | table_id: 2765 (kjrs_crm2.crm_ordersyn_goods ) |

| mysql-bin.000060 | 4953118 | Delete_rows | 1 | 4953268 | table_id: 2765 flags: STMT_END_F |

| mysql-bin.000060 | 4953268 | Query | 1 | 4953342 | COMMIT |

| mysql-bin.000060 | 4953342 | Intvar | 1 | 4953370 | INSERT_ID=1709586 |

| mysql-bin.000060 | 4953370 | Query | 1 | 4953648 | use `kjrs_crm2`; INSERT INTO `kjrs_crm2`.`crm_ordersyn_record`(admin_id, sql_content, table_name, operate_time )VALUES (497, 'DELETE FROM `kjrs_crm2`.`crm_ordersyn_goods` WHERE rec_id=479315 LIMIT 1', 'ordersyn_info', 1440023697 ) |

+------------------+---------+-------------+-----------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

sql 没问题，但是事务那块就不怎么明白了，只有 table_id,flags,这些事什么意思呢？

table_id 是 mysql 中，这个 table 的 id ？