MySQL - How to remove Slow query log, Error log , General query log and InnoDB Log files

Platform: Linux/Unix

MySQL Server can create a number of different log files that make it easy to see what is going on. However, you must clean up these files regularly to ensure that the logs do not take up too much disk space.

To remove the 'error log', 'general query log' or 'slow query log', You can just remove the related files manually and then re-start the logs in MySQL by executing the following command at the command-line

shell>mysqladmin flush-logs

Normally no one removes InnoDB log files but sometimes if you need to re-size the log files then the approach is quite different then as shown above for other logs.