NullWarehouse - Nulled Community Forum, WordPress, PHP Scripts, Games, Minecraft, XF, IPS, SEO THIS IS A TEST - LET ME KNOW BY MESSING ME IF YOU SEE IT...
×
J

Duplicate Index Issue - xf_poll_response Table

  • Thread starter Thread starter jeetkune
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.

Got something to Advertise? Do it here for just $15.00/mo
J

jeetkune

Guest

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...

Read more

Continue reading...
 
A
Access log [Paid]
B
Change sub-forum icon
You must log in or register to reply here.
Similar content Most view View more

Got something to Advertise? Do it here for just $15.00/mo
Back
Top Bottom