MySQL Forums
Forum List  »  InnoDB

Re: ibdata growing too fast
Posted by: Rick James
Date: May 08, 2013 08:56PM

I suspect you don't really have innodb_file_per_table...

SHOW VARIABLES LIKE 'innodb_file_per_table';
(I don't trust my.cnf / my.ini; the value could have been changed manually.)

Look on disk; see if there are .ibd files for each table.

> innodb_buffer_pool_size = 512M
That is rather small for a current-day machine.

> However, since innodb_file_per_table is already present, is there a simpler way?

No. However, if you find that file_per_table was not in effect when some of the tables were made, then this will migrate a table to its own .ibd:
ALTER TABLE foo ENGINE=InnoDB;
However, it will not release any space (of ibdata1) back to the OS.

Options: ReplyQuote


Subject
Views
Written By
Posted
2494
May 07, 2013 06:09AM
Re: ibdata growing too fast
1168
May 08, 2013 08:56PM


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.