Need performance statistics

[Mark Callaghan]

This is a feature request:
SHOW STATUS reports nothing for PBXT.

SHOW ENGINE PBXT STATUS has a few details. I want information on the number and average handling time for disk read and disk write operations.

[Paul McCullagh (paul-mccullagh)]

Hi Mark,

I think xsstat will give you a lot of what you need.

The tool is automatically build and installed with PBXT.

Assume you build mysql as follows:

cd [mysql-build-dir]
./configure --prefix=[mysql-install-dir]
make install

Then you build PBXT like this:

./configure --with-mysql=[mysql-build-dir]
make install

After you started the mysql server and installed the plugin:

mysql> INSTALL PLUGIN PBXT SONAME 'libpbxt.so';

You can now enter:

[mysql-install-dir]/bin/xtstat

It should connect to the server and dump statistics every second about all the PBXT internals.

Enter:

[mysql-install-dir]/bin/xtstat --help

for help.

[Mark Callaghan (mdcallag)]

I will try xstat. That is a substitute for putting details in SHOW ENGINGE PBXT STATUS. But it is not a substitute for SHOW STATUS. Many of us use automation that puts the output from SHOW STATUS into a monitoring tool and the tool expects the SHOW STATUS style output. Also, when there are many servers running remotely in production then expecting the tool to login via ssh and run xstat is too much work.

[Paul McCullagh (paul-mccullagh)]

The information SHOW STATUS will be improved in a future version. In the meantime we recommend using xtstat.

[shinguz (oli-sennhauser)]

Wanted to report the same like Mark...
pbxt.statistics is an alternative but needs some additional logic in monitoring solutions (I have to fetch data from show global variables, from show global status and from pbxt.statistics now instead of only 2 sources...)