日期:2014-05-16  浏览次数:20976 次

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        damasaki@witdeals.com','2','virtual_userdelivery','0','localhost','127.0.0.1','aidamasaki@witdeals.com','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        unei1206@i.softbank.jp','0','dkim_remote_smtp','1','mx.mailsv.softbank.jp','202.179.204.168','syunei1206@i.softb        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        damasaki@witdeals.com','2','virtual_userdelivery','0','localhost','127.0.0.1','aidamasaki@witdeals.com','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        damasaki@witdeals.com','2','virtual_userdelivery','0','localhost','127.0.0.1','aidamasaki@witdeals.com','virtual        _user','witdeals','witdeals.com',NULL,FROM_UNIXTIME(NULL),FROM_UNIXTIME(NULL))


什么原因呢?
这数据库是干嘛的呢? 发邮件?

------解决方案--------------------
把binlog的格式由statment改成row模式或者mixed模式