Hi!
----- Original Message -----
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, February 14, 2006 5:50 PM
Subject: MySql InnoDB
Hi,
I'v installed MySql on my machine and created a new tables.
when i open some table to alter it,i see in the COMMENT textbox: InnoDB
free: 3072 kB
what doe's it mean?
it's mean that i only have 3072kb free for a given table or what?
If you are not using innodb_file_per_table, then the value 3072 kB means
that in ibdata files you have that amount of space free for adding more data
to your tables. To be precise, there are three 1 MB 'extents' available for
extending your tables. In addition, there may be individual 16 kB 'fragment
pages' available, but they are not listed in the printout, for simplicity.
If you are using innodb_file_per_table, then the value 3072 kB means that
you have that much free space in the .ibd file of that table, for extending
the table with those 1 MB extents.
Thank's a lot.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]