MySql ibdata1 compact space

bemodica

Hello I have a problem with mysql.

Using the tables of type INNODB, mysql it has created the archives
(ibdata1) whose dimensions exceed the 3G.

I have cancelled all the database but the occupied space is remained
the same one. How I can make in order to compattare this space?

Thanks

May 26 '06 #1

Subscribe Post Reply

13013

Bill Karwin

be******@esact.it wrote:

Hello I have a problem with mysql.

Using the tables of type INNODB, mysql it has created the archives
(ibdata1) whose dimensions exceed the 3G.

I have cancelled all the database but the occupied space is remained
the same one. How I can make in order to compattare this space?

If you've dropped all the InnoDB tables, you can stop the MySQL Server,
manually delete ibdata1 and the InnoDB log files, and then restart MySQL
Server. MySQL Server will recreate a smaller ibdata1 file when it restarts.

If you have any InnoDB tables you want to keep, you must back them up
first with mysqldump, drop them, and restore them afterward.

See http://bugs.mysql.com/bug.php?id=1287

Regards,
Bill K.

May 26 '06 #2

bemodica

Thanks for the answer

May 29 '06 #3

by: Eduardo Pérez Ureta | last post by:

I'm looking for an easy way to use mysql from user (no root, no mysql system account) space. I don't want the user of my application to have to use a password to connect to the database. I want to...

MySQL Database

ibdata1 is close to disk size

by: Asif Iqbal | last post by:

Hi I am running MySQL 4.0.13 with my-medium.cnf (attached) on a Solaris 8, 4x450 Mhz, 4gb RAM. All my tables are InnoDB. Currently my ibdata1 is 1.8 gb. I have about 1 gig space left on the same...

MySQL Database

Size of ibdata1 file keep increasing and never decrease

by: Pyung Yoon | last post by:

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...

MySQL Database

DB2 v MySql

by: Mairhtin O'Feannag | last post by:

Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort...

DB2 Database

mysql in a startup/shutdown loop at 30 sec intervals

by: jlee | last post by:

I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer...

MySQL Database

Moving the ibdata1 file

by: fuzzybr80 | last post by:

I am using MySQL 5.0 with a number of innodb tables whose ibdata files are growing quite quickly and filling up the /var partition (file is /var/mysql/ibdata1). Earlier on I followed instructions...

MySQL Database

Filtered Import From MySQL to MySQL

by: Randy | last post by:

Folks: We have a web-based app that's _really_ slowing down because multiple clients are writing their own private data into a single, central database. I guess the previous programmer did...

MySQL Database

uninstall the mysql but forgot to export the database table

by: lyealain | last post by:

waht should i do to recover the database after i reinstall the mysql .. i did not export the previous database table out... GOD... i still have the ibdata1 which is more than 800MB in my Mysql...

MySQL Database

Reduce IBData1 Size

by: support1 | last post by:

Hi, I have 10GB of harddisk space and now the harddisk space remaining 2GB because of the IBData1 size too big. As I'm check in the administrator tool. There is no any option to reduce or delete...

MySQL Database

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

MySql ibdata1 compact space

Similar topics