470,819 Members | 1,654 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,819 developers. It's quick & easy.

Size of ibdata1 file keep increasing and never decrease

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
Jul 19 '05 #1
0 2211

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Asif Iqbal | last post: by
4 posts views Thread by Kenny | last post: by
2 posts views Thread by Mike | last post: by
2 posts views Thread by bemodica | last post: by
2 posts views Thread by fuzzybr80 | last post: by
reply views Thread by support1 | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.