MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: /var/lib/mysql/ibdata1 growing out of control
Posted by: justin ux
Date: August 19, 2009 08:55PM

you can try to use store InnoDB tables in a separate file per table.
" To enable multiple tablespaces, start the server with the --innodb_file_per_table option. For example, add a line to the [mysqld] section of my.cnf:

[mysqld]
innodb_file_per_table
"

http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html

If you do that, you should be able to use OPTIMIZE TABLE or Alter table <table name> engine=InnoDB" on the InnoDB table to shrink the size of table files.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
/var/lib/mysql/ibdata1 growing out of control
John Oliver
July 08, 2009 12:00PM
Re: /var/lib/mysql/ibdata1 growing out of control
John Oliver
July 09, 2009 01:31PM
Re: /var/lib/mysql/ibdata1 growing out of control
Jaime Crespo
July 10, 2009 04:08AM
Re: /var/lib/mysql/ibdata1 growing out of control
Rick James
July 11, 2009 04:16PM
Re: /var/lib/mysql/ibdata1 growing out of control
John Oliver
July 20, 2009 03:00PM
Re: /var/lib/mysql/ibdata1 growing out of control
justin ux
August 19, 2009 08:55PM


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.