Print checksum in hexa

[jymoulin]

Hi,

percona toolkit usually prints query ID (alias checksum) in hexadecimal in every output (pt-query-digest report, pt-index-usage...etc).

It would be nice to have the checkum printed and searchable in hexa. This will change the checksum field to a fixed size. And this will permit to search in Anemomter with an ID from other percona report.

Thank you !

regards,
jym

[gtowey]

This is a good idea; I'll try to work on this soon.

[gtowey]

This is done.

To add this behavior, you will need to make a modification to your conf/config.inc.php file. See the conf/sample.config.inc.php for reference. At line 410, there's a new part of the report:

'callbacks'     => array(
        'table' => array(
            'checksum' => function ($x) { return array(dec2hex($x), ''); }
        )
    )

dec2hex is a new helper function which will change the field before it is displayed; Callbacks here are a way of applying arbitrary functions to columns in the result set.