-Original Message-
From: joe collins [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 1:26 AM
To: MySQL
Subject: ibdata1 size
HI,
the ibdata1file in mysql\data has reached a size of 10Mb in just over a
week, the database I have set up is quite limited, only 7 tables with no
more than 12 records in any one table (only evaluating database models on
MySQL at the moment). I have done 4 MySQL dumps and some inserts / updates
etc but all low volume.
Is there some setting I need to have to keep the size of this file down,
or
is there a maintenance task to clear it out?
You can turn autoextend off. Add another disk and extend another data file
onto it as autoextend. Remember INNODB is a virtual file system, it also
stores the index file (3.X - 4.0.X) in a single file. It also uses a page
system (16KB by default), this page system does not map to the block disk
device per say. Additionally as it rebalances the Btree it will expand and
contract from time to time. In most cases it will expand unless you delete
rows.
Blobs are particularly affected from innodb. Use myISAM tables for blobs.
What is the significance of this file?
Any pointers would be greatly appreciated, as my database will be vastly
increased in size and disk space may become an issue.
Many thanks for your patience
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
