Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 )?

Many Thanks...

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.