For best performance, you would want to have all your indexes stored in RAM, certainly. Generally true of databases.
However, you do not have to have enough RAM to keep the indexes loaded. You can configure MySQL to use as much RAM as is appropriate for your machine. The online manual has some good configuration guidelines, and the sample my.cnf files included with your installation may be a good starting point as well. Dan On 8/27/06, solmyr72 <[EMAIL PROTECTED]> wrote:
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 ! -- View this message in context: http://www.nabble.com/MySQL%3A-index-for-a-very-large-table-tf2172085.html#a6005797 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]