cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Knowledge Base

Database Agent: Viewing MySQL Error Logs

To see the error log file of a MySQL server monitored by database agent (under Databases -> Object Browser -> Error Log) , the following conditions must be met:

  • secure_file_priv is either empty or the name of folder containing the error log file. You must restart MySQL for changes in the secure_file_priv variable to take effect.
  • The error log file is readable to all users
  • max_allowed_packet is larger than the error log file size
  • The user has FILE privileges
Version history
Last update:
‎02-04-2019 01:56 PM
Updated by:
Labels (1)
Tags (1)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
0 Kudos
Comments
Based on this information, I found that I needed to add these items to make these updates in the my.cnf file:

 

Both settings referenced in the documentation (4.3+) but finding a specific place to set it required a little more digging:

 

/etc/my.cnf.d/mariadb-server.cnf

 

[mysqld]
secure_file_priv=''
max_allowed_packet=1073741824