On Thu, Sep 18, 2003 at 01:57:17PM +0300, Mikko Noromaa wrote: > Hi, > > Is it possible to configure MySQL so that it would allocate a large amount > of extra space for the MYD/MYI files, and then use this space as necessary?
I don't know of any. > This way the files would need to be grown only very rarely. It would be > ideal if I could configure the increment in which MySQL increases the file > sizes (for example, 100 MB, or a percentage of current file size). Right. > If this is not possible, I'd suggest to add such a feature to MySQL. I > believe it would give a tremendous performance-boost for application where > the databases keep growing. If seek times become an issue, yes, reducing fragmentation may help. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 188,921,457 queries (445/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
