mysql中eximstats这个数据库
defers |
| failures |
| sends |
| smtp |
里面有四个表：
老是有警告日志出现;
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))