My application is facing performance hit. Its a MySQL-5.1.55 version. I am using Windows 2008 dedicated server with 8 GB for the database. There is only one database in this whole system. Till now, I have only enabled slow query log. Now, to find the clue of this issue, I want to enable general log. Writing a log file is an extra burden on the system.
- Will it also affect the performance during peak hour?
- How it will help us to find the cause or should enable error_log also?
- Which one is preferable to write the log - ( table or file )?