Expose charset encoding & autoincrement value

[smalot]

Hi

I suggest to enrich the mysql_info_schema_table_version metric by adding both the character set and autoincrement value as new attributes :

mysql_info_schema_table_version{create_options="",engine="InnoDB",row_format="Compact",schema="drupal",table="shortcut_set",type="BASE TABLE"} 10

would become something like:

mysql_info_schema_table_version{create_options="",engine="InnoDB",row_format="Compact",schema="drupal",table="shortcut_set",type="BASE TABLE",charset="utf8_general_ci",autoincrement="11598789"} 10

Many thanks

[roman-vynar]

Auto-increment will polute time series as the labels should not be volatile.

We have auto-increment here:

mysql_info_schema_auto_increment_column_max
mysql_info_schema_auto_increment_column

Charset should be fine.

[smalot]

Your justification is perfect for me.
Many thanks for your feedback.

[SuperQ]

This information comes from information_schema.tables0. I don't see a column for charset.

There is TABLE_COLLATION and TABLE_COMMENT that we could include.