Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P8198
auto_increment monitoring 2019-03-14
Active
Public
Actions
Authored by
jcrespo
on Mar 14 2019, 10:10 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F28386267: raw.txt
Mar 14 2019, 10:10 AM
2019-03-14 10:10:34 (UTC+0)
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)
Event Timeline
jcrespo
created this paste.
Mar 14 2019, 10:10 AM
2019-03-14 10:10:34 (UTC+0)
jcrespo
mentioned this in
T62962: The primary key of recentchanges (rc_id) table should be unsigned
.
Apr 8 2019, 1:33 PM
2019-04-08 13:33:39 (UTC+0)
jcrespo
mentioned this in
T63111: Convert primary key integers and references thereto from int to bigint (unsigned)
.
Sep 11 2019, 10:50 AM
2019-09-11 10:50:45 (UTC+0)
Log In to Comment