How to customize error log format in ProxySQL?

Question

1.2k views Asked by Ivan Buttinoni At 14 April 2021 at 10:59

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?

There are 1 answers

**HardcoreGamer** · Accepted Answer · 2021-04-26 08:14:27

HardcoreGamer On 26 April 2021 at 08:14 BEST ANSWER

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

FYI: