ApprovedRevs generates queries like the following:
SELECT /* 52.1.214.79 */ r.rev_user_text FROM `revision` `r`,`page` `p` WHERE p.page_title = 'Former_Assize_Court,_Devizes.jpg' ORDER BY r.rev_id ASC LIMIT 1;
102GB database on system with 128GB RAM and 48CPUs, this query took 17 seconds
Serving 100 page views per minute, with ~300 concurrent users, CPU went from 100% down to <10% after disabling ApprovedRevs
# Time: 190602 12:31:10 # User@Host: wiki_app_user[wiki_app_user] @ localhost [] # Thread_id: 34081 Schema: wiki_en QC_hit: No # Query_time: 17.937014 Lock_time: 0.000045 Rows_sent: 1 Rows_examined: 6754801 # Rows_affected: 0