 |  |  |  |  |  |  |  |
MySQL: index for a very large table
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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 !
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
- insert csv file into mysql through php (PHP)
- MyISAM vs InnoDB (MySQL)
- Query on a large table too slow (MySQL)
- table and the index size(individually). (MS SQL)
- table and the index size(individually). (MS SQL)
- Interface page for my new database... (MySQL)
- MySQL Maestro (Computer Science)
- Complete List of Mysql Commands for PHP tokenization script. (PHP)
Other Threads in the MySQL Forum
- Previous Thread: Accessing Mysql with Servlet.....
- Next Thread: Migrating a Oracle 8i to MySQL
Views: 3733 | Replies: 0
| Thread Tools | Search this Thread |
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MySQL
1 agplv3 alfresco api artisticlicense aws bizspark breathalyzer camparingtocolumns cmg communityjournalism contentmanagement contractors copyright count court data database design developer development distinct drupal dui ec2 eliminate email enter enterprise error eudora facebook form foss gnu government gpl greenit hiring hyperic images innerjoins insert ip joebrockmeier join keyword keywords kickfire law legal license licensing maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange montywidenius multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle pdf penelope php query referencedesign reorderingcolumns resultset saas search select sharepoint simpledb sourcecode spotify sql statement sugarcrm syntax techsupport thunderbird transparency update virtualization
