Tell me more ×
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.
up vote 6 down vote favorite

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 multiple MySQL servers and would like to build a UI to view the health of the servers.

What are the important status variables to watch out for that throw a red flag that something isn't right on a long-running server (>48 hours)?

An example of what I'm looking for is qcache_lowmem_prunes becoming larger could indicate a misconfigured query_cache

share|improve this question
So the title is a bad title, should include MySQL in the title. Additionally, I think you could maybe flesh the question out a little more. – jcolebrand♦ Jan 6 '11 at 2:57
make the title a question, please. Keep an eye on for what objective? Is there a better phrase? Monitor? – Brian Ballsun-Stanton Jan 6 '11 at 13:08
I wonder if this isn't better suited to ServerFault (monitoring server processes via an automated tool)? – jcolebrand♦ Jan 7 '11 at 0:40
I'm not asking for tools to monitor the variables, as I want to write them myself. What I'm asking for is what MySQL DBAs consider 'red-flag' status variables. – Derek Downey Jan 7 '11 at 0:53

closed as not a real question by jcolebrand♦ Sep 15 '11 at 17:59

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 4 down vote

Here's a link to a bunch of links on "tuning best practices."

The short form is: It depends. What are you tuning for? Tuning read performance is different than write performance and everything changes when you move to a cluster. There is no one set of "magic variables" that can be quietly optimized for every situation.

From these, you can look at monitoring variables, as the variables that need to be tuned are strongly related to the variables that require monitoring.

share|improve this answer
yeah, i'm looking for the monitoring variables. – Derek Downey Jan 7 '11 at 15:52

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