Re: MySQL threads taking time in "statistics" state

2010-04-28 Thread Dheeraj Kumar
7;s not possible, are your disks > slower than they should be...? and so on. What OS are you running? > > On Mon, Apr 26, 2010 at 5:59 AM, Dheeraj Kumar wrote: > > We have installed mysql-5.1.39 and having a database with following > table. > > > > CREATE TABLE `EntMs

MySQL threads taking time in "statistics" state

2010-04-26 Thread Dheeraj Kumar
We have installed mysql-5.1.39 and having a database with following table. CREATE TABLE `EntMsgLog` ( `msgId` bigint(20) NOT NULL, `causeId` bigint(20) NOT NULL, `entityId` int(11) NOT NULL, `msgReceiver` bigint(20) NOT NULL, `msgTextId` int(11) NOT NULL, `flags` bit(8) NOT NULL, `t