Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

How MySQL databases logged and monitored on ubuntu servers in real time?. I checked /var/log/mysql.log and found it empty.

EDIT 1:

The log was not enabled in the mysql configuration file. Now it logs and I could see the logs in the file /var/log/mysql/mysql.log

But this could not be sufficient to gather additional information about the database logs. Is there any other way or any popular open source tool?

share|improve this question

closed as too localized by Luis Mar 14 '13 at 15:12

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Is there a better way to monitor mysql databases? –  user3215 Apr 4 '11 at 1:16
    
OP are you still looking for an answer? If so, you may need to repost your question as this is marked for closure. Regards, –  Ringtail Apr 10 '12 at 6:44

2 Answers 2

If you need more verbose logging, you should log at the application level which is accessing your mysql database.

share|improve this answer

What are you looking to monitor, exactly? If you're looking to monitor mysql process activity, a monitoring tool such as Monit may be a good place to start. It can also keep an eye on log files for certain keywords.

http://mmonit.com/monit/

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.