Search code examples
mysqlerror-logging

MYsql how to log erroneous queries

is it possible to log erroneous queries on MySQL 5.5?

At the moment i'm having a problem that i assume that some queries of my shop system run into a locking-timeout ~once a week.

But i cannot find any logs about it.

The error_log, and general_log do not log any error messages, when i run a erroneous query, for example:

"SELECT asdf"

i get an error

/* SQL Fehler (1054): Unknown column 'asdf' in 'field list' */

is it possible to log such error in any way?

Solution

  • You can pass it to a file and check it there:

    mysql -u user -p 2> errors.log

    After getting the comments, I dont think there is any way to detect the errors. You have to depend on the application layer of your code to log the errors.