I've got mysql logging log_slow_queries or whatever, and had turned on all query logging for a moment before I found it to just be spammy and thus useless.
How can I log only mysql queries that result in syntax errors?
Asked
Active
Viewed 1,699 times
1
Kzqai
- 1,278
- 4
- 17
- 32
-
You should look at the general log: http://dev.mysql.com/doc/refman/5.5/en/query-log.html – Raisen Apr 11 '11 at 22:48
-
Right, I should have been more clear that I already checked that log out, I was hoping that there was a way to view queries with improper syntax and ignore queries that have the proper syntax. Because viewing everything in the log is so spammy that it's useless. – Kzqai Apr 11 '11 at 22:54
-
All I can suggest to better filter the queries is to store them in a table instead of a file. I am not sure about a specific error log option in MySQL. – Raisen Apr 11 '11 at 23:00