By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

database file size

P: n/a
I running MySQL locally and have the following dir setup

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

Thanks

Mike

Feb 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
>I running MySQL locally and have the following dir setup

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?


ibdata1 is preallocated and probably (unless you've really used
it to capacity) has free space within it (from the point of view
of MySQL, but not as far as the OS is concerned).

Gordon L. Burditt
Feb 20 '06 #2

P: n/a
"Mike" <mi**@mjfcadsolutions.co.uk> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I running MySQL locally and have the following dir setup

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?


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.

Regards,
Bill K.
Feb 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.