Tagged Questions
1
vote
1answer
116 views
What are some best monitoring tools available for mysql? [duplicate]
I have a setup a linux mysql server and would like to monitor it. I found percona plugins for nagios and cacti. Are there any other tools available?
0
votes
0answers
64 views
how to install zabbix agent in agent host which we are adding from server to monitor
following this site i have intsalled zabbix server and agent in centos 6.0
zabbix version :1.8.5
http://www.youtube.com/watch?v=sKfYm-3thRM
but i am unable to add agent that is how to add other ...
0
votes
2answers
285 views
How can you monitor if MySQL binlog files get corrupted?
I was wondering if there was any nice way to continuously monitor mysql master binlog files and detect if get corrupted.
1
vote
5answers
531 views
MySQL Replication monitoring [closed]
Im looking for a tool that could help me and my team monitor our MySQL Replication.
I would love for a tool that could alert me if
Seconds_Behind_Master passes a threshold
Slave_SQL_running is ...
2
votes
1answer
321 views
Create a custom log table in MySQL
Is it possible to create a custom log table. For example I have 10 schema and I would like to log if somebody is using the "areva" schema. I want to know the last executed command time and the user. ...
8
votes
3answers
1k views
Monitor MySQL activity per database?
What is the best way to monitor activity on each database of my server ?
I tried mtop/mytop which display activity in real time but aren't very practical to see all the queries executed on it.
I ...
3
votes
1answer
1k views
How do you read MySQL InnoDB Monitor output?
I am new to DB Administration. I am trying to figure out the cause of deadlock exceptions, but I am unable to make sense of the logs.
The log says that "transaction 1 is rolled back". Why is this the ...
3
votes
5answers
1k views
MySQL Performance Monitoring
I already have system availability monitoring for all my MySQL instances in Nagios. I'm looking to get some trending monitoring going for activity. It'd be nice to see how all the information_schema ...
1
vote
1answer
433 views
How can I get the maxium number of concurrent connections to MySQL over a specific time interval?
I have a monitoring app that checks MySQL's Threads_connected and Max_used_connections variables every X seconds.
Neither of these variables tells me what I want to know: The highest number of ...
2
votes
3answers
2k views
Script to Monitor MySQL Replication
G'Day,
I am looking for a bash script (using Perl - As that is already installed on the machine and I don't want to have to install Ruby, Python etc. just for this requirement) that will perform some ...
6
votes
1answer
766 views
What are some important MySQL status variables to keep an eye on? [closed]
I'm a fairly new DBA with a programming background. As such, I like to build tools to manage tasks to help me familiarize myself with the intricacies of a technology.
In this case, I am managing ...
