innodbCMP

[Michal Pirgl]

Hi,

Attached script can be used for monitoring INNODB_CMP in MySQL INFORMATION_SCHEMA using WebX.mySQL5.

STAT-name                               STAT-value

db-server-online                         1

1024_COMPRESS_OPS                        0

1024_COMPRESS_OPS/delta                  0

1024_COMPRESS_OPS/sec                    0.000000

1024_COMPRESS_OPS_OK                     0

1024_COMPRESS_OPS_OK/delta               0

1024_COMPRESS_OPS_OK/sec                 0.000000

1024_COMPRESS_TIME                       0

1024_UNCOMPRESS                          0

1024_UNCOMPRESS/delta                    0

1024_UNCOMPRESS/sec                      0.000000

1024_UNCOMPRESS_TIME                     0

2048_COMPRESS_OPS                        0

2048_COMPRESS_OPS/delta                  0

2048_COMPRESS_OPS/sec                    0.000000

2048_COMPRESS_OPS_OK                     0

2048_COMPRESS_OPS_OK/delta               0

2048_COMPRESS_OPS_OK/sec                 0.000000

2048_COMPRESS_TIME                       0

2048_UNCOMPRESS                          0

2048_UNCOMPRESS/delta                    0

2048_UNCOMPRESS/sec                      0.000000

2048_UNCOMPRESS_TIME                     0

4096_COMPRESS_OPS                        0

4096_COMPRESS_OPS/delta                  0

4096_COMPRESS_OPS/sec                    0.000000

4096_COMPRESS_OPS_OK                     0

4096_COMPRESS_OPS_OK/delta               0

4096_COMPRESS_OPS_OK/sec                 0.000000

4096_COMPRESS_TIME                       0

4096_UNCOMPRESS                          0

4096_UNCOMPRESS/delta                    0

4096_UNCOMPRESS/sec                      0.000000

4096_UNCOMPRESS_TIME                     0

8192_COMPRESS_OPS                        10848

8192_COMPRESS_OPS/delta                  383

8192_COMPRESS_OPS/sec                    127.666664

8192_COMPRESS_OPS_OK                     9060

8192_COMPRESS_OPS_OK/delta               319

8192_COMPRESS_OPS_OK/sec                 106.333336

8192_COMPRESS_TIME                       5

8192_UNCOMPRESS                          16770

8192_UNCOMPRESS/delta                    569

8192_UNCOMPRESS/sec                      189.666672

8192_UNCOMPRESS_TIME                     27

16384_COMPRESS_OPS                       0

16384_COMPRESS_OPS/delta                 0

16384_COMPRESS_OPS/sec                   0.000000

16384_COMPRESS_OPS_OK                    0

16384_COMPRESS_OPS_OK/delta              0

16384_COMPRESS_OPS_OK/sec                0.000000

16384_COMPRESS_TIME                      0

16384_UNCOMPRESS                         0

16384_UNCOMPRESS/delta                   0

16384_UNCOMPRESS/sec                     0.000000

16384_UNCOMPRESS_TIME                    0

Regards,

Michal

[Dimitri]

Hi Michal,

MANY THANKS for sharing!!!
looks like hacking and writing WebX scripts was pretty easy for you,
so I'm yet more happy ;-))

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 http://groups.google.com/group/dimstat.
> For more options, visit https://groups.google.com/d/optout.
>