2

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?

Ivan Buttinoni
  • 4,110
  • 1
  • 24
  • 44

1 Answers1

1

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

HardcoreGamer
  • 1,151
  • 1
  • 16
  • 24