List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:July 10 2010 8:56am
Subject:Re: Slow disk access: 1.4m to do a select count over 23GB table.
View as plain text  
On Fri, Jul 9, 2010 at 9:09 PM, Andrés Tello <mr.criptos@stripped> wrote:
> Hi, I'm using mysql 4.1.21, a legacy system. Next step to migrate it, but
> for now, I need the community help.
>
> I have a 23GB table, if I do a select count(over_an_index) from table it
> uses 1.4minutes to read. The main issue is that this table is the main table
> of a system and each query is taking too long to complete.

A table definition would be heplful here.

> How can I optimize the access of the database?
>
> any mysql variable I could use?
> or how can I load the index into memory? I have 32GB of ram XD plenty to
> useit into something more useful....

A configuration file would be helpful here.
>
> Thanks.
>


My  guess is that you have a innodb table and that you have
unallocated innodb buffer pool. This is nothing more than a guess

What is ram XD?
-- 
Rob Wultsch
wultsch@stripped
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