While working on T288398 I found these MyISAM flaggedrevs related tables on some sections like ruwiki (see full list below):
mysql:root@localhost [information_schema]> select table_name,create_time,update_time from tables where engine='MyISAM' and table_name like 'flagged%'; +--------------------+---------------------+---------------------+ | table_name | create_time | update_time | +--------------------+---------------------+---------------------+ | flaggedrevs_stats2 | 2013-10-07 11:26:02 | 2013-10-07 11:26:02 | | flaggedrevs_stats | 2013-10-07 11:26:02 | 2013-10-07 11:26:02 | +--------------------+---------------------+---------------------+ 2 rows in set (0.003 sec)
mysql:root@localhost [information_schema]> use ruwiki;show create table flaggedrevs_stats2\G show create table flaggedrevs_stats\G
Database changed
*************************** 1. row ***************************
Table: flaggedrevs_stats2
Create Table: CREATE TABLE `flaggedrevs_stats2` (
`stat_id` int(10) unsigned NOT NULL DEFAULT 1,
`ave_review_time` int(10) unsigned NOT NULL DEFAULT 0,
`med_review_time` int(10) unsigned NOT NULL DEFAULT 0,
`ave_pending_time` int(10) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`stat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=binary
1 row in set (0.000 sec)
*************************** 1. row ***************************
Table: flaggedrevs_stats
Create Table: CREATE TABLE `flaggedrevs_stats` (
`namespace` int(11) NOT NULL DEFAULT 0,
`total` int(11) NOT NULL DEFAULT 0,
`reviewed` int(11) NOT NULL DEFAULT 0,
`synced` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`namespace`)
) ENGINE=MyISAM DEFAULT CHARSET=binary
1 row in set (0.000 sec)I guess they are just ancient history and they are not updated, so can we drop them?
We should probably check all the otherwikis where we have flaggedrevs enabled.
This table is present on:
- s1: enwiki
- s2:
eowiki idwiki plwiki trwiki
- s3:
alswiki bewiki bnwiki bswiki de_labswikimedia dewikiquote dewiktionary en_labswikimedia enwikibooks enwikinews eswikinews fawikinews flaggedrevs_labswikimedia frwikinews hewikisource hiwiki iawiki iswiktionary kawiki mkwiki ptwikinews ptwikisource plwikisource plwiktionary ruwikiquote ruwikisource sqwiki tawikinews ukwiktionary zh_classicalwiki
- s5: dewiki
- s6: ruwiki
- s7:
arwiki huwiki