Re: Data file size
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.
Subject
Views
Written By
Posted
6144
June 02, 2010 07:24AM
Re: Data file size
1959
June 03, 2010 09:54AM
1636
June 04, 2010 05:37AM
1724
June 07, 2010 04:10AM
3076
June 09, 2010 01:31AM
2060
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.