data files preallocation
Hi All,
I was wondering if there is a way to configure MyIsam tables to preallocate disk space on reallocation (in order to keep disk fragmentation under control).
I believe that this is a major performance killer for INSERTs intensive applications.
I noted other posts regarding similar topics: should MySQL lack such support, my (poor) workaround would be to format the data volume with a large disk-cluster size (64K with NTFS).
Again, it would be much better to have MySQL controlling MyISAM data files sizes.
Thanks for your comments and suggestions.
David Lombardi
Subject
Views
Written By
Posted
data files preallocation
3663
February 01, 2006 08:14AM
2651
February 02, 2006 04:27AM
2202
February 02, 2006 05:11AM
1933
February 03, 2006 03:11AM
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.