View Single Post
Old 09-29-2017, 02:40 PM  
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
Looking through the tables I found a lot of duplicate indexes that I did not create...

Code:
CREATE TABLE IF NOT EXISTS `xxxhashtag_search` (
  `id_search` int(11) NOT NULL AUTO_INCREMENT,
  `query` varchar(255) NOT NULL,
  `views` int(11) NOT NULL DEFAULT '1',
  `insitemap` int(1) NOT NULL DEFAULT '0',
  `insitemap_link` int(1) NOT NULL DEFAULT '0',
  `insitemap_link2` int(1) NOT NULL DEFAULT '0',
  `data_ins` varchar(255) NOT NULL DEFAULT '1388796621',
  `last_mod` varchar(255) DEFAULT '1415144202',
  `engine` varchar(255) NOT NULL,
  PRIMARY KEY (`id_search`),
  KEY `query` (`query`),
  KEY `query_2` (`query`),
  KEY `query_3` (`query`),
  KEY `query_4` (`query`),
  FULLTEXT KEY `query_5` (`query`),
  FULLTEXT KEY `query_6` (`query`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=925373 ;
By removing the indexes in addition the script from 8000 seconds now takes 0.2 seconds...

Now I check all the other tables looking for duplicate indexes...
(I will take about 3 days, as I am happy... )
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote