MySQL Forums
Forum List  »  InnoDB

Re: Data file size
Posted by: Rick James
Date: June 03, 2010 09:54AM

SHOW TABLE STATUS; -- This will give you Data_length and Index_length.

Autoextend makes it so you don't have to worry about data growth. Except that you could fill up disk.

If you have a max or if you fill up disk, you will be in trouble.

Too late now, but innodb_file_per_table is generally recommended. That way, dropping a table will free up space to the OS. Without that setting, ibdata1 grows, but never shrinks.

How big is the disk? If it is only, say, 80GB, and ibdata1 continues to grow, and you have one big table (plus smaller ones), then it is past time to figure out what to do when you run out of disk space.

Options: ReplyQuote


Subject
Views
Written By
Posted
5929
June 02, 2010 07:24AM
Re: Data file size
1835
June 03, 2010 09:54AM
1468
June 04, 2010 05:37AM
1874
June 07, 2010 04:59AM


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.