Documentation Home
MySQL Enterprise Monitor 3.1 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 3.2Mb
PDF (A4) - 3.2Mb
EPUB - 2.2Mb
HTML Download (TGZ) - 2.0Mb
HTML Download (Zip) - 2.1Mb

5.5.4 sql_mode

On startup, the agent sets sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER on the monitored MySQL instance. If sql_mode=ONLY_FULL_GROUP_BY, agent queries can fail. The local agent of the MySQL Enterprise Service Manager also sets sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION on the repository.

User Comments
Sign Up Login You must be logged in to post a comment.