Page MenuHomePhabricator
Paste P8198

auto_increment monitoring 2019-03-14
ActivePublic

Authored by jcrespo on Mar 14 2019, 10:10 AM.
Tags
None
Referenced Files
F28386267: raw.txt
Mar 14 2019, 10:10 AM
Subscribers
None
enwiki:
root@db1114[sys]> select * FROM schema_auto_increment_columns LIMIT 4 \G
*************************** 1. row ***************************
table_schema: enwiki
table_name: recentchanges
column_name: rc_id
data_type: int
column_type: int(8)
is_signed: 1
is_unsigned: 0
max_value: 2147483647
auto_increment: 1137690279
auto_increment_ratio: 0.5298
*************************** 2. row ***************************
table_schema: enwiki
table_name: cu_changes
column_name: cuc_id
data_type: int
column_type: int(11)
is_signed: 1
is_unsigned: 0
max_value: 2147483647
auto_increment: 854445063
auto_increment_ratio: 0.3979
*************************** 3. row ***************************
table_schema: enwiki
table_name: text
column_name: old_id
data_type: int
column_type: int(8) unsigned
is_signed: 0
is_unsigned: 1
max_value: 4294967295
auto_increment: 898750098
auto_increment_ratio: 0.2093
*************************** 4. row ***************************
table_schema: enwiki
table_name: revision
column_name: rev_id
data_type: int
column_type: int(8) unsigned
is_signed: 0
is_unsigned: 1
max_value: 4294967295
auto_increment: 887709732
auto_increment_ratio: 0.2067
4 rows in set, 36 warnings (0.04 sec)
wikidatawiki:
root@db1071.eqiad.wmnet[sys]> select * FROM schema_auto_increment_columns LIMIT 4 \G
*************************** 1. row ***************************
table_schema: wikidatawiki
table_name: recentchanges
column_name: rc_id
data_type: int
column_type: int(11)
is_signed: 1
is_unsigned: 0
max_value: 2147483647
auto_increment: 919219099
auto_increment_ratio: 0.4280
*************************** 2. row ***************************
table_schema: wikidatawiki
table_name: cu_changes
column_name: cuc_id
data_type: int
column_type: int(11)
is_signed: 1
is_unsigned: 0
max_value: 2147483647
auto_increment: 899023427
auto_increment_ratio: 0.4186
*************************** 3. row ***************************
table_schema: wikidatawiki
table_name: text
column_name: old_id
data_type: int
column_type: int(10) unsigned
is_signed: 0
is_unsigned: 1
max_value: 4294967295
auto_increment: 889703558
auto_increment_ratio: 0.2072
*************************** 4. row ***************************
table_schema: wikidatawiki
table_name: revision
column_name: rev_id
data_type: int
column_type: int(10) unsigned
is_signed: 0
is_unsigned: 1
max_value: 4294967295
auto_increment: 882728203
auto_increment_ratio: 0.2055
4 rows in set, 52 warnings (0.37 sec)