List:General Discussion« Previous MessageNext Message »
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.
View as plain text  
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: ¬¬ -> 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

Thread
Slow disk access: 1.4m to do a select count over 23GB table.Andrés Tello10 Jul
  • Re: Slow disk access: 1.4m to do a select count over 23GB table.Rob Wultsch10 Jul
    • Re: Slow disk access: 1.4m to do a select count over 23GB table.Andrés Tello10 Jul