MySql ibdata1 compact space

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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?


Re: MySql ibdata1 compact space wrote:
Quoted text here. Click to load it

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.


Bill K.

Re: MySql ibdata1 compact space

Thanks for the answer

Site Timeline