Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- database file size
February 20, 2006, 3:35 pm
rate this thread
C:\wamp\mysql\data\mike - This is where the tables for the database
mike are stored
C:\wamp\mysql\data - This is where I think the database data is stored.
Basically the file in the data dir. (ibdata1) is 10,240kb in size.
When I update a table in the mike database the file size of ibdata1
doesn't increase and I don't know why?
Anyone got any ideas??
Re: database file size
MySQL come with at least two storage implementations, MyISAM and InnoDB.
InnoDB tables reside in the <datadir>/ibdata1 file. MyISAM tables reside as
individual files under <datadir>/<databasename>.
If you add volume to a table in the mike database, it may be added to either
<datadir>/mike/<tablename>.MYD, or else <datadir>/ibdata1. Which one
depends on the table storage type, which was determined when you created the
table. For example, if the table uses the MyISAM storage type, then the
ibdata1 file won't be touched at all.
And as Gordon says, sometimes a change to the table won't necessarily result
in an immediate change in the file size. For efficiency, the RDBMS may
sometimes increase file size with some room to spare.
- » Inserting a list of names in a table using stored procedure
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum