From: Andrés Tello Date: July 10 2010 11:21am Subject: Re: Slow disk access: 1.4m to do a select count over 23GB table. List-Archive: http://lists.mysql.com/mysql/222138 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016361e829e886e52048b06b920 --0016361e829e886e52048b06b920 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable As usual, after you send a mail, you check for other things.... From the 32GB of ram, I only was allocating 2G, not by the process, but by all the S.O... free -G reported barely 1 gig of ram... XD -> happy face that I have lots of ram... now my face is like: =AC=AC -> why I didn't verfy the amount of ram earlier= ? I'll verify this ram issue, cus if this is the issue then 1.4M isn't a bad time... TIA unallocated innodb buffer pool. This is nothing more than a guess > > What is ram XD? > -- > Rob Wultsch > wultsch@stripped > My guess is that you have a innodb table and that you have --0016361e829e886e52048b06b920--