> -----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]
