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 table of 9 GB (plus several others

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

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