MySQL Query Logs Truncating Queries
I'm looking at the general log I've enabled i开发者_开发知识库n MySQl and it's working nicely. However, queries appear to be truncated a little over 1000 characters.
What's the deal with that?
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?
精彩评论