search

shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
0 stars 2 forks source link

Dashboard: MySQL -> InnoDB Metrics: 0 requests / 0 hits = 0% cache hit rate, should be 100% hit rate #220

Closed gordan-bobic closed 7 months ago

gordan-bobic commented 7 months ago

On the MySQL -> InnoDB Metrics -> InnoDB Buffer Pool Requests graph, 0 requests is show as 0 buffer pool hit rate, it should be shown as 100%.

Also, please remove the Y-Min for the Right Y axis (% hit rate).

oblitorum commented 7 months ago

By removing the Y-Min for the Right Y axis, you mean removing the 0 on the bottom right from the graph?

image

Or remove it from the legend on the bottom?

image

gordan-bobic commented 7 months ago

No, I mean in the Axes setup. zero-to-remove

oblitorum commented 7 months ago

Unfortunately, I didn't find a easy way to remove/disable the Y-min in the Axes setup, I don't think Grafana offer a configuration to do that. Although we can always do it the hard way -> create a new dashboard plugin that's similiar to this timeseries dashboard, it needs some js/css/html work to achieve that. But it feels too much for just removing/disabling the Y-min config.

gordan-bobic commented 7 months ago

I mean literally delete the "0" from the Y-Min box in the dashboards template and leave the field empty. In the same way that Left Y has no Y-Max, the Right Y should have an empty Y-Min.

oblitorum commented 7 months ago

Oh, got it