MySQL执行sys.diagnostics存储过程如下报错
root@localhost [(none)]>call sys.diagnostics(null,null,'current'); +-------------------+ | summary | +-------------------+ | Disabled 1 thread | +-------------------+ 1 row in set (0.02 sec) ERROR 1694 (HY000): Cannot modify @@session.sql_log_bin inside a transaction
经分析数据库autocommit参数设置为off。重新设置成on后执行正常无报错
标签:bin,transaction,log,+-------------------+,HY000,1694,session,ERROR From: https://www.cnblogs.com/hanglinux/p/16833093.html