proxysql

How to customize error log format in ProxySQL?

I've notice some syntax error in my proxysql error log (/var/lib/proxysql/proxysql.log):

Error during query on (0,1.2.3.4,3306): 1064, syntax error, unexpected '-'

But they're report only the error and not the query that cause it.

Is it possible to include in the proxysql.log also the query?

Eventually log only the queries that go in error?

Solution

  • Execute Set mysql-verbose_query_error = true when you begin the database connection in your applications.

    FYI:

    How to change variables

    Functionality regarding the variable: mysql-verbose_query_error