AlliedModders - View Single Post - [Bug Report] Banlist slow loading query on recent MYSQL versions

TheWho · *Last edited by TheWho; 11-06-2016 at 17:39.*

I exported sb_bans, DROP sb_bans, changed following and imported the table again:

Code:

PRIMARY KEY (`bid`),
  KEY `sid` (`sid`),
  KEY `authid` (`authid`),
  KEY `aid` (`aid`),
  KEY `type` (`type`),
  KEY `reason` (`reason`(255))