Redis Metric Extraction

Resolved

(@taimourhadi)

I am trying to extract redis query execution time using wp cli.
Currently i am using
wp redis metrics
and it returns output like

float(1619642237)
  ["O:26:"Rhubarb\RedisCache\Metrics":8:{s:2:"id";s:7:"7eb65b0";s:4:"hits";i:897;s:6:"misses";i:3;s:5:"ratio";d:99.7;s:5:"bytes";i:468576;s:4:"time";d:0.00466;s:5:"calls";i:19;s:9:"timestamp";i:1619642238;}"]=>
  float(1619642238)
  ["O:26:"Rhubarb\RedisCache\Metrics":8:{s:2:"id";s:7:"7fc6566";s:4:"hits";i:571;s:6:"misses";i:2;s:5:"ratio";d:99.7;s:5:"bytes";i:466558;s:4:"time";d:0.00343;s:5:"calls";i:14;s:9:"timestamp";i:1619642239;}"]=>
  float(1619642239)
  ["O:26:"Rhubarb\RedisCache\Metrics":8:{s:2:"id";s:7:"815d03e";s:4:"hits";i:571;s:6:"misses";i:2;s:5:"ratio";d:99.7;s:5:"bytes";i:466558;s:4:"time";d:0.00374;s:5:"calls";i:14;s:9:"timestamp";i:1619642241;}"]=>

Can you please provide details on how can this be achieved, like we are able to see from wp-admin?

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Author Till Krüss
(@tillkruess)

4 years, 11 months ago

You’ll have to unserialize the data returned using https://www.php.net/manual/en/function.unserialize.php
Thread Starter taimourhadi
(@taimourhadi)

4 years, 11 months ago
I was able to unseriallize the data online.
```
__PHP_Incomplete_Class Object
(
    [__PHP_Incomplete_Class_Name] => Rhubarb\RedisCache\Metrics
    [id] => 7518102
    [hits] => 5131
    [misses] => 106
    [ratio] => 98
    [bytes] => 1531931
    [time] => 0.04296
    [calls] => 366
    [timestamp] => 1619684725
)
```
But as you can see from this command
wp redis metrics –allow-root | head -n 5
array(161) {
It returns array of different length on each execution.
What is the best way to interpret this as we want to monitor query execution time.
Plugin Author Till Krüss
(@tillkruess)

4 years, 11 months ago

TBH, I’d use New Relic to monitor your real execution time.

You’ll should to load the Rhubarb\RedisCache\Metrics class before unserializing the data, however the time key is what you’re looking for. You can probably grep that.

If you want to submit a PR on GitHub that adds a CLI command to print the metrics, please feel free: https://github.com/rhubarbgroup/redis-cache

Thread Starter taimourhadi
(@taimourhadi)

4 years, 11 months ago

I just wanted to know the interpretation of graph to cli status.
In graph we have like minute points showing value in ms where as in the cli, i am getting multiple values in the span of 30 minutes.
What is the best interpretation for conversion?

Plugin Author Till Krüss
(@tillkruess)

4 years, 11 months ago

You can study how the metrics work here:

https://github.com/rhubarbgroup/redis-cache/blob/develop/includes/class-metrics.php

Thread Starter taimourhadi
(@taimourhadi)

4 years, 11 months ago

I guess you didn’t get the request correctly.
I wanted to ask that on wp-admin, I see minute wise graph showing a particular time value in ms.
But from command line, I am getting multiple values with in a time. How to estimate the time (in ms) from these multiple values.

Plugin Author Till Krüss
(@tillkruess)

4 years, 11 months ago

You need to calculate the value, just like it’s done here: https://github.com/rhubarbgroup/redis-cache/blob/develop/assets/js/admin.js

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Redis Metric Extraction’ is closed to new replies.

Tags