So that I can just check the logs to see which statements are wrong at a unified location.
这样我就可以检查日志以查看统一位置的哪些语句是错误的。
2 个解决方案
#2
If by "which statements are wrong" you mean "which queries", I don't think the error log helps: it logs mysql starting, stopping, crashing, checking or repairing tables... I think you need to use the general query log and post-process it yourself (with a script or something) to extract errant queries only.
如果“哪些语句错误”你的意思是“哪些查询”,我不认为错误日志有帮助:它记录mysql启动,停止,崩溃,检查或修复表...我认为你需要使用一般查询自己记录和后处理(使用脚本或其他内容)仅提取错误查询。
#1
Have you read the documentation for the MySQL error log?
您是否阅读过MySQL错误日志的文档?
#2
If by "which statements are wrong" you mean "which queries", I don't think the error log helps: it logs mysql starting, stopping, crashing, checking or repairing tables... I think you need to use the general query log and post-process it yourself (with a script or something) to extract errant queries only.
如果“哪些语句错误”你的意思是“哪些查询”,我不认为错误日志有帮助:它记录mysql启动,停止,崩溃,检查或修复表...我认为你需要使用一般查询自己记录和后处理(使用脚本或其他内容)仅提取错误查询。