Re: MySQL threads taking time in "statistics" state

2010-04-28 Thread Dheeraj Kumar
Hi Baron, I am too new to mysql internal jargon to understand "Handler:info()". Can you tell me specific variables you want to get the real issue? *Regarding OS:* It ubuntu disto. of linux. dhee...@:~$ uname -a Linux host0125 2.6.24-16-generic #1 SMP Thu Apr 10 12:47:45 UTC 2008 x86_64 GNU/Li

Re: MySQL threads taking time in "statistics" state

2010-04-26 Thread Baron Schwartz
Hi, You probably aren't doing anything wrong, per se, but I suspect Handler::info() is slow and is being called once per partition. You should probably start looking at your system overall to check where the time is spent. Is it in reading from disk? If so, can you make it read from memory inst

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