[buddypress-trac] [BuddyPress Trac] #7500: Harmful bp_activity indexes

[buddypress-trac]

#7500: Harmful bp_activity indexes
--------------------------+------------------------------
 Reporter:  brandonliles  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Core          |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  2nd-opinion   |
--------------------------+------------------------------

Comment (by johnjamesjacoby):

 Howdy @brandonliles!

 Thanks for opening this ticket and detailing your findings.

 It's generally true that indexes on columns with low cardinality is
 ineffective, however, benchmarks to confirm that full table scans are
 currently a problem would be useful. That way we can also confirm removing
 those indexes will improve performance as anticipated.

 Once we've done that, an upgrade routine will need to be introduced that
 comfortable locks those tables while the indexes are adjusted. Since the
 Activity table is highly likely to have many, many rows, even index
 removal is not a simple or painless process.

 TL;DR - We need:

 * Benchmarks
 * Confirmation
 * Safe & friendly upgrade routine

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/7500#comment:3>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac