Re: Query/connection state getting locked
here is the Create Table Statement
'article', 'CREATE TABLE `article` (
`ArticleID` varchar(13) NOT NULL default '0',
`md5id` varchar(34) NOT NULL default '',
`PubID` int(11) NOT NULL default '0',
`pubdate` date NOT NULL default '0000-00-00',
`Volume` varchar(20) NOT NULL default '',
`Date_Time_Acqured` datetime NOT NULL default '0000-00-00 00:00:00',
`Num_pages` int(11) NOT NULL default '0',
`Title` varchar(100) NOT NULL default '',
`Sub_Title` varchar(100) NOT NULL default '',
`TypePid` int(11) NOT NULL default '0',
`SectorPid` int(11) NOT NULL default '0',
`Subsector` int(11) NOT NULL default '0',
`Page_NameID` varchar(45) NOT NULL default '',
`IsPremium` char(1) NOT NULL default '',
`IsColor` char(1) NOT NULL default '',
`IsPhoto` char(1) NOT NULL default '',
`UserID` varchar(10) NOT NULL default '',
`working` char(1) NOT NULL default '0',
`parsed` tinyint(1) NOT NULL default '0',
`d1` tinyint(1) NOT NULL default '0',
`rejected` tinyint(1) default '0',
`d3` tinyint(1) default '0',
`d6` tinyint(1) default '0',
`d24` tinyint(1) default '0',
`id` bigint(20) NOT NULL auto_increment,
`ave` double NOT NULL default '0',
`iattach` tinyint(1) unsigned NOT NULL default '0',
`alertsent` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `articlearticleid` (`ArticleID`),
KEY `article_iscolor` (`IsColor`),
KEY `Index_11sector` (`SectorPid`),
KEY `Index_2` (`working`),
KEY `Index_3` (`parsed`),
KEY `Index_4` (`d1`),
KEY `Index_5` (`d3`),
KEY `Index_6` (`d6`),
KEY `Index_13DateTimeAcqured` (`Date_Time_Acqured`),
KEY `Index_7` (`d24`),
KEY `Index_10` (`PubID`),
KEY `Index_8` (`pubdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1'
whenever i do any select query for reports that takes time near about 3 to 5 min.
meanwhile table like this get locked
how can i overcome this problem
Cheers .... :)
Neeraj Black Bits