472,331 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,331 software developers and data experts.

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

/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?


Jul 19 '05 #1
2 11581
I found the following thread:


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!

Jul 19 '05 #2
In order to shrink a MySQL database look at:

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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Mark Depenbrock | last post by:
--Apple-Mail-2--68472726 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Can not make mysql...
by: Marc Slemko | last post by:
Suppose I have an innodb table in 4.0.14 and do: LOCK TABLE maggie INSERT INTO maggie values(123, 'simpson'); UNLOCK TABLES As soon as I...
by: Vanchau Nguyen | last post by:
Hi all, Hoping someone can help us with this strange Innodb problem. At about 5:15 AM 2/2/04 (this morning), our slave server stopped accepting...
by: Andy Tran | last post by:
I built a system using mysql innodb to archive SMS messages but the innodb databases are not keeping up with the number of SMS messages coming in. ...
by: Jan | last post by:
I am using Apache2triad 1.2 as local development environment. It is working fine, but I cannot create InnoDB tables with the phpMyAdmin 2.5.6...
by: niku | last post by:
Hello all. I'm trying to get mysql installed on OpenBSD 3.4. Unfortunately, it appeares that the port only installes the mysql-client, and one...
by: Beyonder | last post by:
I'm using InnoDB with Mysql and I've used delete to delete over 10 million records, but the InnoDB database is still the same size on the disk...
by: Gh! | last post by:
How can I see how much disk space is being occupied by an InnoDB table? Looking into /var/lib/mysql doesn't seem to work anymore for InnoDB...
by: fuzzybr80 | last post by:
Hi, I am using MySQL version 5.0 on Linux Fedora Core 4. I recently got this error message: 060609 11:06:29 InnoDB: ERROR: the age of the...
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.