Improve "MySQL Threads" graph

Bug #1157911 reported by Roman Vynar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Monitoring Plugins
Fix Released
Wishlist
Unassigned

Bug Description

Currently, "MySQL Threads" graph shows:
- Thread Cache Size
- Threads Created

Usually, if thread_cache_size is 0, only threads_created line is shown on the graph. And vice-versa, when thread_cache_size is non-zero (pink area on the graph), usually no new threads are created as the cached ones are used.

Also Threads Cached, Threads Running are not graphed anywhere.

I suggest to amend the existing "MySQL Threads" graph to show the following:
- Thread Cache Size
- Threads Created
- Threads Connected
- Threads Running
- Threads Cached

On the example attached we can observe that once thread_cache_size was set to 10, MySQL stopped creating new threads and started using the cached ones.

Tags: cacti
Revision history for this message
Roman Vynar (roman-vynar) wrote :
Changed in percona-monitoring-plugins:
importance: Undecided → Wishlist
tags: added: cacti
summary: - Amend "MySQL Threads" graph
+ Improve "MySQL Threads" graph
Changed in percona-monitoring-plugins:
milestone: none → 1.0.3
Changed in percona-monitoring-plugins:
status: New → In Progress
Changed in percona-monitoring-plugins:
status: In Progress → Fix Committed
Changed in percona-monitoring-plugins:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.