Re: 16GB index file limit
The index files are smaller and thus faster. Every row in the data file has an entry in the index file for every index which points to the record in the data file. The smaller the pointers are, the more keys go into a key block. This means less I/O and hence faster operation.
Since 5.0.6 the default size is increased. See the description of AVG_ROW_LENGTH in
http://dev.mysql.com/doc/refman/5.0/en/create-table.html and the description of myisam_data_pointer_size in
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html.
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
3450
February 01, 2006 03:22AM
2132
February 02, 2006 04:14AM
2078
February 07, 2006 03:26AM
2245
February 07, 2006 03:46AM
2164
February 07, 2006 07:12AM
2008
February 08, 2006 01:43PM
Re: 16GB index file limit
2333
February 09, 2006 03:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.