Skip to main content
added 132 characters in body
Source Link
dr_
  • 32.4k
  • 22
  • 102
  • 148

/var/lib/mysql/mysql/general_log.csv is the MySQL general log. It contains general server activity e.g. client connections.

You can truncate it via the command:

cat /dev/null > /var/lib/mysql/mysql/general_log.CSV 

It is safe to run this command with the server running, but if that doesn't free up the space, it means that the server is holding the file open and you would have to restart the mysqld daemon, which would reset the connections of the clients to the database.

To disable itthe general log definitely, comment out the general_log line in the MySQL configconfiguration file (usually /etc/mysql/my.cnf) and haveforce the MySQL server to reload its configconfiguration.

/var/lib/mysql/mysql/general_log.csv is the MySQL general log. It contains general server activity e.g. client connections.

You can truncate it via the command:

cat /dev/null > /var/lib/mysql/mysql/general_log.CSV 

It is safe to run this command with the server running, but if that doesn't free up the space, it means that the server is holding the file open and you would have to restart the mysqld daemon.

To disable it definitely, comment out the general_log line in the MySQL config and have the MySQL server reload its config.

/var/lib/mysql/mysql/general_log.csv is the MySQL general log. It contains general server activity e.g. client connections.

You can truncate it via the command:

cat /dev/null > /var/lib/mysql/mysql/general_log.CSV 

It is safe to run this command with the server running, but if that doesn't free up the space, it means that the server is holding the file open and you would have to restart the mysqld daemon, which would reset the connections of the clients to the database.

To disable the general log definitely, comment out the general_log line in the MySQL configuration file (usually /etc/mysql/my.cnf) and force the MySQL server to reload its configuration.

Source Link
dr_
  • 32.4k
  • 22
  • 102
  • 148

/var/lib/mysql/mysql/general_log.csv is the MySQL general log. It contains general server activity e.g. client connections.

You can truncate it via the command:

cat /dev/null > /var/lib/mysql/mysql/general_log.CSV 

It is safe to run this command with the server running, but if that doesn't free up the space, it means that the server is holding the file open and you would have to restart the mysqld daemon.

To disable it definitely, comment out the general_log line in the MySQL config and have the MySQL server reload its config.