Hi,
I have a strange problem with innodb tables. I have about 10 innodb
tables, a few of which can have tens of thousands of entries. These
huge tables are clean up regularly.
But the size of ibdata1 remained same even after the tables were
dropped. Funny thing is that as new entries are added into the newly
created tables, the size of ibdata1 increases. And eventually exhausts
the disk space.
I don't do any strange things with MySQL. Will indexing cause this
kind of problem?
Thanks for you help.
-Pyung
