Error：not found description for innodbSTAT statistic(s)

[coffeer...@gmail.com]

I run into a error when I run command BatchLOAD to replay innodbSTAT data to Analyze.

about all step of collect data and replay data following :

1、 I run scripts EasySTAT.sh with enable MySQL.

    ./EasySTAT.sh /data/dim_STAT 1 2 InnoDB MYSQL dim /apps/ADMIN/BatchLOAD /data/dim_STAT/x.log

2、 Replay innodbSTAT data to Analyze, I just only replay innodbSTAT data.

   /apps/ADMIN/BatchLOAD -cmd ADD -ID 0 -base dim -file "/data/dim_STAT/2016_04_20.MYSQL.74224/MYSQL_data.2016_04_20.09H59.innodbSTAT" \

-skip1 yes -title "innodbSTAT" -host MYSQL -isec 1 -start 20160420100615 -verbose on

### ERROR: not found description for innodbSTAT statistic(s)...

[Dimitri]

Hi,

All you need is just to go to Add-On page via web interface and check the innodbSTAT is well installed in your database..

General Note: 

  - collecting such stats every 2 sec is not a good idea..

  - any reason you are not collecting stats directly and going via EasySTAT way ?..

Rgds,

-Dimitri 

--
You received this message because you are subscribed to the Google Groups "dim_STAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+u...@googlegroups.com.
To post to this group, send email to dim...@googlegroups.com.
Visit this group at https://groups.google.com/group/dimstat.
For more options, visit https://groups.google.com/d/optout.

[coffeer...@gmail.com]

Hi !

    I am so sorry !! I don't have innodbSTAT in Add-On page. Look attachment.

    I installed followed tools:

       1、dim_STAT-v90-linux-x86.tar.

       2、WebX_apps-v90-u15.tgz

       3、STATsrv-v5-Linux-x86-mysql.tgz

    But no innodbSTAT in Add-On page

在 2016年4月20日星期三 UTC+8下午11:20:08，(dim)写道：

Hi,

All you need is just to go to Add-On page via web interface and check the innodbSTAT is well installed in your database..

General Note: 

  - collecting such stats every 2 sec is not a good idea..

  - any reason you are not collecting stats directly and going via EasySTAT way ?..

Rgds,

-Dimitri 

On Wednesday, 20 April 2016, <coffeer...@gmail.com> wrote:

I run into a error when I run command BatchLOAD to replay innodbSTAT data to Analyze.

about all step of collect data and replay data following :

1、 I run scripts EasySTAT.sh with enable MySQL.

    ./EasySTAT.sh /data/dim_STAT 1 2 InnoDB MYSQL dim /apps/ADMIN/BatchLOAD /data/dim_STAT/x.log

2、 Replay innodbSTAT data to Analyze, I just only replay innodbSTAT data.

   /apps/ADMIN/BatchLOAD -cmd ADD -ID 0 -base dim -file "/data/dim_STAT/2016_04_20.MYSQL.74224/MYSQL_data.2016_04_20.09H59.innodbSTAT" \

-skip1 yes -title "innodbSTAT" -host MYSQL -isec 1 -start 20160420100615 -verbose on

### ERROR: not found description for innodbSTAT statistic(s)...

--
You received this message because you are subscribed to the Google Groups "dim_STAT" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+unsubscribe@googlegroups.com.

[coffeer...@gmail.com]

Hi !

   Maybe I solved this problem. I create table dim_ANY_innodbSTAT as same as dim_ANY_InnoDB. it is work!!

在 2016年4月21日星期四 UTC+8上午10:34:01，coffeer...@gmail.com写道：

[Dimitri]

Hi,

sorry for delay, was very busy with benchmarking stuff..

seems like it was my fault -- when I moved all the scripts to v5 code base of STAT-service, I automatically added "innodbSTAT" into EasySTAT collections, while historically it was the very first Add-On for InnoDB in the past, and for this same reason it was called "InnoDB" and not "innodbSTAT" ;-)) ==> indeed, over a time this became confusing, as people are expecting to find "innodbSTAT" name on the web interface as well.. -- so I'm looking on a simple solution now for a way to fix it with a smallest pain and transparent for users..

while the direct fix for EasySTAT is just to rename innodbSTAT to InnoDB in .easystat-mysql file (but leave the innodbSTAT.sh name as it -- the name of the script is correct ;-))

Rgds,

-Dimitri

Hi !

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+u...@googlegroups.com.

To post to this group, send email to dim...@googlegroups.com.
Visit this group at https://groups.google.com/group/dimstat.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "dim_STAT" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+u...@googlegroups.com.

[coffeer...@gmail.com]

  Thanks for everything you doing and did and will do !!...:-)))

Hi !

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+unsubscribe@googlegroups.com.

To post to this group, send email to dim...@googlegroups.com.
Visit this group at https://groups.google.com/group/dimstat.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "dim_STAT" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+unsubscribe@googlegroups.com.

[Dimitri]

Hi,

I've analyzed little bit the code, and currently very curious how did
you get such an error, because in fact there was no fault in the
initial script, as from a long time I'm analyzing in the code: if the
STAT name is not matched, then check the STAT shell command; - and the
shell command for "InnoDB" is "innodbSTAT".. So, normally you should
see a warning on the screen saying "unknown innodbSTAT stat name" and
then "replacing innodbSTAT by InnoDB stat name" -- did you see any of
them ?..

also, may you send, please, the output of :
- mysql> select * from dim_anySTAT ;

then :
- mysql> select * from TabX_note ;

(and hope you did not try to hack the contents ;-))

Rgds,
-Dimitri

>>>>>> *### ERROR: not found description for innodbSTAT statistic(s)...*

>>>>>>
>>>>>> --
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "dim_STAT" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>>>

>>>>>> an email to dimstat+u...@googlegroups.com.

>>>>>> To post to this group, send email to dim...@googlegroups.com.
>>>>>> Visit this group at https://groups.google.com/group/dimstat.
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>> --
>>> You received this message because you are subscribed to the Google Groups
>>>
>>> "dim_STAT" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an
>>>

>>> email to dimstat+u...@googlegroups.com.

>>> To post to this group, send email to dim...@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/dimstat.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "dim_STAT" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to dimstat+u...@googlegroups.com.