469,903 Members | 2,145 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

innodb file won't shrink

I'm using INNODB with mysql 4.0.12 and a single data file:

innodb_data_file_path = ibdata1:10M:autoextend

My database has grown out of hand though and I am almost out of disk
space:

df:
/dev/sdb1 35859376 34878228 981148 98% /

ls -l:
-rw-rw---- 1 mysql mysql 35406217216 Jul 8 21:00 ibdata1

I have deleted a large portion of the database but the file size has
not shrunk. I understand that it has autoextended to this size but am
hoping that there is some command/utility that can shrink it down or
take off extents since I really need some disk space back. Am I off
base? Does anything like this exist?

thanks,

-Steve
Jul 19 '05 #1
2 11508
I found the following thread:

http://groups.google.com/groups?thre...ie.NCTU.edu.tw

That was from 2001 and talks about the potential for INNODB tools...
does anyone know if any work has been made on those? I just can't
believe that there's no real way for me to make this file smaller when
the space is no longer needed/used... the suggested -> dump the
database and then recreate it just won't since I have a 34+GB db and
no more space on my drive?

Anyone? Please!

-Steve
Jul 19 '05 #2
sjpapa
1
In order to shrink a MySQL database look at:
http://dev.mysql.com/doc/mysql/en/ad...-removing.html

buy another disk to add space and go back to the url above.
Oct 9 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Marc Slemko | last post: by
3 posts views Thread by Andy Tran | last post: by
2 posts views Thread by Jan | last post: by
1 post views Thread by fuzzybr80 | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.