MySQL: index for a very large table

Expand Post »

This is the first time I try to use MySQL for very large tables.

Experienced users warned me against possible problems with *index* definition for large tables:
they claim MySQL indices are stored completely in memory, which is problematic to me : I have a huge table and limited memory size (RAM). I did the math, and the entire index just won't fit into the RAM.
Unfortunatelly it will be a while before management approves hardware improvements.

Could anyone please advise whether MySQL really needs to store the entire index in memory ?
Or is there some way to configure this ?
Thanks very much !

Similar Threads

Query on a large table too slow in MySQL
MyISAM vs InnoDB in MySQL
insert csv file into mysql through php in PHP
table and the index size(individually). in MS SQL
table and the index size(individually). in MS SQL

solmyr72

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Aug 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: INSERT INTO on a Condition...

Next Thread in MySQL Forum Timeline: Migrating a Oracle 8i to MySQL

DaniWeb Message

Cancel Changes

User Name
Password