- 工信部备案号 滇ICP备05000110号-1
- 滇公安备案 滇53010302000111
- 增值电信业务经营许可证 B1.B2-20181647、滇B1.B2-20190004
- 云南互联网协会理事单位
- 安全联盟认证网站身份V标记
- 域名注册服务机构许可：滇D3-20230001
- 代理域名注册服务机构：新网数码
相关文章
国信办再关闭31家违规网站 云南省2019年国家网络安全周在丽江启动，蓝队云获颁“最佳技术支持奖” 云南公布第二批免费向社会提供信息技术服务企业名单 英特尔计划在中国打造物联网国际品牌 中国互联网企业赴美上市规模预计今年或减半
解决mysql 1864 主从错误
2016-08-25 08:29:26
7479
1 2 3 | mysql>stop slave;mysql>set global slave_pending_jobs_size_max=20000000;mysql> start slave; |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | 从库设置mysql> set global slave_parallel_workers=4;mysql> show variables like 'slave_parallel_workers';+------------------------+-------+| Variable_name | Value |+------------------------+-------+|slave_parallel_workers | 4 |+------------------------+-------+1 row in set (0.00sec) mysql>set global slave_pending_jobs_size_max=1024;mysql> show variables like 'slave_pend%';+-----------------------------+-------+| Variable_name | Value |+-----------------------------+-------+|slave_pending_jobs_size_max | 1024 |+-----------------------------+-------+
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | 主库操作：mysql> update erp_mkpf set usnam='测试1864错误';ERROR 1197 (HY000):Multi-statement transaction required more than 'max_binlog_cache_size' bytes ofstorage; increase this mysqld variable and try againmysql> set global max_binlog_cache_size=8388608000000;Query OK, 0 rowsaffected (0.00 sec)mysql> begin;Query OK, 0 rowsaffected (0.00 sec) mysql> update erp_mkpf set usnam='测试1864错误';Query OK, 70466 rowsaffected (0.38 sec)Rows matched:70466 Changed: 70466 Warnings: 0 mysql> commit;Query OK, 0 rowsaffected (0.08 sec) |
1 2 3 4 5 6 | 从库查看状态：mysql> show slavestatusG Last_SQL_Errno: 1864 Last_SQL_Error: Cannot scheduleevent Update_rows, relay-log name ./HE1-relay-bin.000005, position 494 toWorker thread because its size 8200 exceeds 1024 ofslave_pending_jobs_size_max. |
