Hello.
> Is there a specific innodb list? There is an InnoDB forum: http://forums.mysql.com/list.php?22 > disablign the keys. I think I tried that, but with a table with 7 mil >rows, that takes longer than the load data :-\ Have you increased the myisam_sort_buffer_size variable to speed up the rebuilding of the keys? I'm unable to give an answer on your question about "preallocating" the ibdata files, but this link should be useful if you want to optimize InnoDB performance: http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html George Law wrote: > Hi All, > > I am running mysql 5.0.18 with a innodb table of 9 GB (plus several others) > on suse linux 9.3 with 4 GB ram. > > when doing a show table status command, this table shows Data_Free:0 > > I assume this is because it is the "file per table" setting, where the > tables fall outside of the main ibdata files. > > The ibdata files are all preallocated when mysql starts up, is there anyway > to preallocate the "file per table" files as well? > > Is there a specific innodb list? > > Thanks to Gleb's answer and the hint on the bulk load setting in my.cnf - > that seems to have helped some what. > I notice in the load data command there is a "CONCURRENT" option - but as > far as I can tell, that only does MyISAM tables? You also suggested > disablign the keys. I think I tried that, but with a table with 7 mil rows, > that takes longer than the load data :-\ > > TIA. > > George Law > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
