Re: allocate space for innodb innodb_file_per_table

2006-01-09 Thread Gleb Paharenko
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

Re: allocate space for innodb innodb_file_per_table

2006-01-09 Thread Heikki Tuuri
George, - Original Message - From: ""George Law"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, January 08, 2006 10:10 PM Subject: allocate space for innodb innodb_file_per_table Hi All, I am running mysql 5.0.18 with a innodb t

allocate space for innodb innodb_file_per_table

2006-01-08 Thread George Law
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 ibd