hello everybody,
Mysql version:4.1.8
OS:windows XP
data_file_path:ibdata1:10M in my.ini file /* which is default value*/
As every one knew the data and index files of all innodb tables are stored in
ibdata1(in this case).
We created some user defined tables(innodb type).The number of user defined
tables does not exceed 10.The size of each table also does not exceed 10 rows.
We executed 'show table status' command and it gave innodb freespace:4092 KB.
What does that mean?How come system tables and user defined tables(which are
not more than 10) occupy 6MB?Does mysql does 10MB ibdata1 into partitions of
6MB and 4MB?If any one knew anything regarding this issue please answer
immediately.
Thanking you,
your's
sincerely,
sirisha.
Yahoo! India Matrimony: Find your life partneronline.
