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
- 27,130
- Points
- 823
XenForo 2.3.6 was installed cleanly without any updates. However, during my MariaDB performance analysis, I encountered an issue. Below is the problem:
I’ve analyzed the database schema using pt-duplicate-key-checker and identified a suboptimal index in the xf_poll_response table that could be optimized for better performance.
Read more
Continue reading...
I’ve analyzed the database schema using pt-duplicate-key-checker and identified a suboptimal index in the xf_poll_response table that could be optimized for better performance.
Issue Identified
The table has:- A PRIMARY KEY on poll_response_id (auto-increment)
- A secondary index poll_id_response_id on...
Read more
Continue reading...