• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

The necessary MySQL monitoring parameter

what should be the parameter we should monitors for MySQL ? I want to monitor the most important MySQL parameter and then do something for it.

Please also explain what is that mean and what if the value is too large, what will happen and the threhold of it.

you all can simple show the currently running value of your case.

I will reference it .
0
marrowyung
Asked:
marrowyung
  • 3
  • 2
1 Solution
 
RRobinhoCommented:
Go through the link here is 10 main variable you should monitor in MySql

http://www.techrepublic.com/blog/opensource/10-mysql-variables-that-you-should-monitor/56

You can also find the answer of your second question in this link search it in the buffer size where the blog explain the mean of value is too large..

http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
Any tools can efficiently to monitor all of them ? the one you are using can be suggest !
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
I mean just one tools can monitor all of them .
0
 
RRobinhoCommented:
You can check either Quest spotlight or webyog mysql Monitor
may these tools fulfill your requirement

https://www.webyog.com/
http://www.quest.com/spotlight-on-mysql/
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
RRobinho,

can webyog monitor MSSQL also ? I just can't see it at all !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now