CODEWITHSUNDEEP
mysqlmysql-logic
carrier
carrier

Reputation: 33109

MySQL Query Logs Truncating Queries

I'm looking at the general log I've enabled in MySQl and it's working nicely. However, queries appear to be truncated a little over 1000 characters.

What's the deal with that?

Upvotes: 1

Views: 1036

Answers (1)

fduenas
fduenas

Reputation: 295

You should also change the field type, the 'argument' field is medium text, you should change it to 'longtext' with the following query.

ALTER TABLE `mysql`.`general_log` CHANGE `argument` `argument` LONGTEXT NOT NULL;

what kind of query is so great than 1000?

maybe logging a BLOB field?

Upvotes: 0

Related Questions