Re: changing from 1 big file to file_per_table
Posted by:
Rick James
Date: November 18, 2011 08:50AM
Since you said
> to reclaim space from ibdata1 e.g.
http://forums.mysql.com/read.php?22,430513,431249#msg-431249 specify dumping the db - which I can't do because I've dropped it
I assumed you understood how to deal with ibdata1. There is no shortcut; you must create (or have) a dump of all the tables, stop mysqld, remove ibdata1, redeclare the size in my.cnf (my.ini), start mysqld, and reload all the tables.
ibdata1 is used for a lot of 'overhead' things (http://forums.mysql.com/read.php?22,499279,499279), so it cannot be zero length. And it may as well be auto-extend since once cannot predict how big it will need to become.
Subject
Views
Written By
Posted
2717
November 15, 2011 07:12AM
1183
November 16, 2011 09:54AM
1089
November 17, 2011 06:18AM
Re: changing from 1 big file to file_per_table
998
November 18, 2011 08:50AM
1012
November 21, 2011 03:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.