Duplicate Index Issue - xf_poll_response Table

jeetkune · Apr 4, 2025

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.

Issue Identified

The table has:

A PRIMARY KEY on poll_response_id (auto-increment)
A secondary index poll_id_response_id on...

P	Duplicate a Poll for a new round/new title, same options PatMa Dec 31, 2024 Xenforo RSS Feed
B	Issue with noindex meta tags being inconsistent with sitemap inclusion/exclusion options bzcomputers Dec 8, 2024 Xenforo RSS Feed
H	Page count duplicated for ignored content hkymre Oct 14, 2024 Xenforo RSS Feed
H	XF\Db\DuplicateKeyException: MySQL query error [1062] hovik Apr 26, 2025 Xenforo RSS Feed
P	How to duplicate a live site to use as a test site Paul B Sep 6, 2024 Xenforo RSS Feed

Duplicate Index Issue - xf_poll_response Table

Issue Identified​

Issue Identified