mysql中eximstats这个数据库
defers |
| failures |
| sends |
| smtp |
里面有四个表：
老是有警告日志出现;
- SQL code
27711 121016 15:42:54 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO s mtp (mailtime,msgid,email,processed,transport_method,transport_is_remote,host,ip,deliveredto,router,deliveryuser ,deliverydomain,counteddomain,countedtime,countedhour) VALUES(FROM_UNIXTIME('1350373374'),'1TO1nh-0005ZV-44','ai [email protected]','2','virtual_userdelivery','0','localhost','127.0.0.1','[email protected]','virtual _user','witdeals','witdeals.com',NULL,FROM_UNIXTIME(NULL),FROM_UNIXTIME(NULL)) 27712 121016 15:43:13 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO s mtp (mailtime,msgid,email,processed,transport_method,transport_is_remote,host,ip,deliveredto,router,deliveryuser ,deliverydomain,counteddomain,countedtime,countedhour) VALUES(FROM_UNIXTIME('1350373393'),'1TO1ny-0005Zl-MU','sy [email protected]','0','dkim_remote_smtp','1','mx.mailsv.softbank.jp','202.179.204.168','[email protected] ank.jp','dkim_lookuphost','-remote-','','witdeals.com',FROM_UNIXTIME('1350373391'),FROM_UNIXTIME('1350370800')) 27713 121016 15:47:25 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO s mtp (mailtime,msgid,email,processed,transport_method,transport_is_remote,host,ip,deliveredto,router,deliveryuser ,deliverydomain,counteddomain,countedtime,countedhour) VALUES(FROM_UNIXTIME('1350373645'),'1TO1s5-0005cK-Fj','ai [email protected]','2','virtual_userdelivery','0','localhost','127.0.0.1','[email protected]','virtual _user','witdeals','witdeals.com',NULL,FROM_UNIXTIME(NULL),FROM_UNIXTIME(NULL)) 27714 121016 15:47:57 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO s mtp (mailtime,msgid,email,processed,transport_method,transport_is_remote,host,ip,deliveredto,router,deliveryuser ,deliverydomain,counteddomain,countedtime,countedhour) VALUES(FROM_UNIXTIME('1350373677'),'1TO1sb-0005cw-AO','ai [email protected]','2','virtual_userdelivery','0','localhost','127.0.0.1','[email protected]','virtual _user','witdeals','witdeals.com',NULL,FROM_UNIXTIME(NULL),FROM_UNIXTIME(NULL))
欢迎大家阅读《mysql中eximstats这个数据库解决办法》,跪求各位点评，by 搞代码
什么原因呢？
这数据库是干嘛的呢？ 发邮件？
——解决方案——————–
把binlog的格式由statment改成row模式或者mixed模式
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql中eximstats这个数据库解决办法
转载请注明原文链接：mysql中eximstats这个数据库解决办法
