RSS Feed/News Searching for users by username timing out

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
24,718
Points
823

Reputation:

Hey,

I believe that a change made to XF\Admin\Controller\User at line 78 might be causing the username index hint to be ignored unintentionally. In our installation, this is causing all AdminCP searches for users by their username (with "Exact match" ticked) to time out. I'm assuming that our registered user count of 6,366,411 might have something to do with this as well, but that wasn't an issue with the index not ignored.

A look at this MySQL slow query log entry caused after...

Read more

Continue reading...
 
Status
Not open for further replies.
Top