maria-developers team mailing list archive

Thread
Date

Statistics tables show up in userstat - intentional?

To: Igor Babaev <igor@xxxxxxxxxxxx>
From: Sergei Petrunia <psergey@xxxxxxxxxxxx>
Date: Thu, 12 Jul 2012 18:59:02 +0400
Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
User-agent: Mutt/1.5.18 (2008-05-17)

Hello Igor,

I've noticed that engine-independent statistics show up in userstats:

+--------------+-------------+-----------+--------------+-------------------------+
| Table_schema | Table_name  | Rows_read | Rows_changed | Rows_changed_x_#indexes |
+--------------+-------------+-----------+--------------+-------------------------+
| bug929732    | c2          |       249 |            0 | 0 |
| mysql        | index_stat  |        84 |            0 | 0 |
| bug929732    | v           |       276 |            0 | 0 |
| mysql        | column_stat |        44 |            0 | 0 |
| bug929732    | c           |       249 |            0 | 0 |
| bug929732    | v3          |    837280 |            0 | 0 |
| mysql        | table_stat  |        12 |            0 | 0 |
| bug929732    | v4          |      3994 |            0 | 0 |
| bug929732    | v2          |     53506 |            0 | 0 |
+--------------+-------------+-----------+--------------+-------------------------+

Is this intentional?


I've also started collecting some minimal docs at
http://kb.askmonty.org/en/engine-independent-table-statistics/


BR
 Sergei
-- 
Sergei Petrunia, Software Developer
Monty Program AB, http://askmonty.org
Blog: http://s.petrunia.net/blog