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

buddypress-trac noreply at wordpress.org
Wed Apr 12 20:30:14 UTC 2017

#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

More information about the buddypress-trac mailing list