percona-discussion team mailing list archive

[MARK CALLAGHAN <mdcallag@xxxxxxxxx>]

On Mon, May 18, 2009 at 9:46 AM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
> Mark,
>
> In these releases we touch only InnoDB, I can't imagine how it could screw
> up Com_ statistics, but I will double check.

The problem is on my side. My monitoring code uses SHOW STATUS, not
SHOW GLOBAL STATUS. Our 5.X builds match 4.0 behavior -- SHOW STATUS
== SHOW GLOBAL STATUS. I can't believe MySQL switched this from 4.0 to
5.0.

>
>
>
> MARK CALLAGHAN wrote:
>>
>> I am using XtraDB built from mysql-5.1.34-xtradb5.tar.gz. The db *.err
>> log has this --
>> 090518  7:29:37 InnoDB Plugin 1.0.3-5a started; log sequence number
>> 30077472780
>>
>> When running tpcc-mysql, all of the Com_ variables from SHOW STATUS
>> are 0 except for two (Com_select and Com_show_status == 1). Is this a
>> problem with 5.1.34 or Percona patches or something else?
>>
>
>
> --
> Vadim Tkachenko, CTO
> Percona Inc.
> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
> MySQL Performance Blog - http://www.mysqlperformanceblog.com
> MySQL Consulting http://www.percona.com/
>



-- 
Mark Callaghan
mdcallag@xxxxxxxxx