Log & monitor mysql databases on servers

Posted by user3215 on Ask Ubuntu See other posts from Ask Ubuntu or by user3215
Published on 2011-03-04T08:53:19Z Indexed on 2011/03/04 23:33 UTC
Read the original article Hit count: 546

Filed under:

9.10

|

monitor

|

mysql

|

log

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?

© Ask Ubuntu or respective owner

Related posts about 9.10

can't install psycopg2 in my env on mac os x lion

as seen on Server Fault - Search for 'Server Fault'
I tried install psycopg2 via pip in my virtual env, but got this error: ld: library not found for -lpq (full log here: http://pastebin.com/XdmGyJ4u ) I tried install postgres 9.1 from .dmg and via port, (gksks)iMac-Alexander:~ lorddaedra$ locate libpq /Developer/SDKs/MacOSX10.7.sdk/usr/include/libpq /Developer/SDKs/MacOSX10… >>> More
Taking Ubuntu 9.10 Netbook Remix out for a Spin

as seen on Internet.com - Search for 'Internet.com'
<B>IT News Today:</B> "I’ve actually been using UNR for a couple of months now. When I first started playing with it, I didn’t even own a Netbook, so instead I tried it out on a Dell Latitude E6400 laptop. About a month later, I was gifted a Dell Mini 10 netbook… >>> More
PC-BSD 8.0 vs. Kubuntu 9.10 Benchmarks

as seen on Internet.com - Search for 'Internet.com'
<b>Phoronix:</b> "...we took this opportunity to deliver a fresh set of *BSD benchmarks. In this article we have benchmarks of PC-BSD 8.0 x64 against Kubuntu 9.10 x86_64." >>> More
How to install opencv?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Hello All, I am trying to learn image processing and obviously opencv is one of the best options. Usually synaptic does all my installing work for me so I just checked the repos. But in the repos there is only on libcv1 and it is listed as 1.0.0-6.2ubuntu1. Does that mean it is version 1.0 of opencv… >>> More
Randomly displayed flashing lines, no response to all shortcuts, just power off. [syslog included]

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Hello! I have an old machine, and I want to use for that to learn employees how to use Ubuntu, and to be easyer to switch from Windows. I've been installed 10.04, and updated, but this strange stuff is happend. Graphical installion failed, same strange thing. With alternate workd. Sometimes, when… >>> More

Related posts about monitor

Monitor Flickering Issue[Not Monitor's problem]

as seen on Super User - Search for 'Super User'
My monitor had a flickering issue.I couldnt rectify it through refresh rate changing.So i purchased a new LCD monitor.Still the issue persist.What is the issue.Is it the problem of motherboard.How can i solve it. >>> More
How to target SCOM 2007 R2 monitor to monitor only one server

as seen on Server Fault - Search for 'Server Fault'
Hi, This might be basic, but hopefully someone can help me: We have a well-working SCOM 2007 R2 implementation monitoring our Microsoft infrastructure. Now, on one of these servers there's an event (logged to the eventlog) that I need to be alerted on. I have created a group and put this one windows… >>> More
Ubuntu dual monitor set up - taskbars appear on other monitor

as seen on Super User - Search for 'Super User'
I'm trying to get my TV (connected via HDMI cable) to act as a second monitor to watch video etc. The TV is to my left, so in Display Preferences I unticked "Mirror Screens" and put the monitors like this: -------- ---------- | PC | | TV | | | ---------- -------- When… >>> More
kvm-switch, dual monitor, only share one monitor

as seen on Super User - Search for 'Super User'
Hi, Setup: 2 physical machines, and 3 LCD monitors, each machine has its own LCD monitor, and I would like to share the 3rd LCD monitor using KVM-switch. Is this possible? (I have already shared the keyboard and mouse using Synergy.) >>> More
Monitor files similar to System Internal's/Microsoft's FileMon/Process Monitor

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to generate an event when a file is closed by another app. Unfortunately, ReadDirectoryChangesW doesn't report the close event. It would be possible for me to poll (with a TTimer) any file that reported by ReadDirectoryChangesW as modified, waiting for it to be closed (using CreateFile to… >>> More