How to enable THREAD_STATISTICS?

64 views
Skip to first unread message

MarkW

unread,
May 14, 2012, 3:51:12 PM5/14/12
to Percona Discussion
Percona,

How do you enable THREAD_STATISTICS ?

I am running 5.1.62rel13.3-log Percona Server with XtraDB

and I have userstat enabled

+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| userstat_running | ON |
+------------------+-------+

The following stats do work:
SHOW CLIENT_STATISTICS
SHOW INDEX_STATISTICS
SHOW TABLE_STATISTICS
SHOW USER_STATISTICS

But SHOW THREAD_STATISTICS does not work.

Thanks,

-Mark

Laurynas Biveinis

unread,
May 15, 2012, 11:13:19 PM5/15/12
to percona-d...@googlegroups.com
Mark -

> I am running 5.1.62rel13.3-log Percona Server with XtraDB
> ...
> But SHOW THREAD_STATISTICS does not work.

I believe you are experiencing
https://bugs.launchpad.net/percona-server/+bug/728080
Please subscribe to that bug (and optionally select "it affects me")
to be notified when we fix it.

Thanks,
--
Laurynas
www.percona.com

Alexey Kopytov

unread,
May 16, 2012, 3:40:12 AM5/16/12
to percona-d...@googlegroups.com
Hi MarkW,
THREAD_STATISTICS can be enabled by setting both the thread_statistics
and userstat_running variables to ON. I have updated bug
https://bugs.launchpad.net/percona-server/+bug/728080

Best regards,
Alexey.

MarkW

unread,
May 16, 2012, 10:24:48 AM5/16/12
to Percona Discussion
Thank you both that worked.

-MarkW

On May 16, 12:40 am, Alexey Kopytov <alexey.kopy...@percona.com>
wrote:
Reply all
Reply to author
Forward
0 new messages