From: Andrés Tello
Date: July 10 2010 4:09am
Subject: Slow disk access: 1.4m to do a select count over 23GB table.
List-Archive: http://lists.mysql.com/mysql/222136
Message-Id: <AANLkTimpgj6WeRtzJJlIHsNxy0XJULu9f0HP9bPz09wq@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=00c09f88d2036a8b38048b00b13e

--00c09f88d2036a8b38048b00b13e
Content-Type: text/plain; charset=ISO-8859-1

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.

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....


Thanks.

--00c09f88d2036a8b38048b00b13e--