Re: ibdata1 file in mysql/data directory

Dr. Virginia R. Hetrick wrote:

Hi,

> Hi, folks -
>
> I'm trying to build a new configuration in a student lab. I'm limited
> to 20MB of data, per the University's restrictions on the amount of
> storage any student may have allocated.
> I keep running out of space and have found a file called ibdata1 in the
> mysql\data directory which seems to usually be around 10.5MB in size. It
> seems to be something that's described by the three files in each of the
> database directories (*.frm, *.MYD, *.MYI) and might possibly be the
> actual data. I have several questions:
>
> 1. Does this file do what I think it does?
> 2. Is there anything that can be done to reduce its size?
>

These files are the tablespace and log files for InnoDB storage engine.
If you don't need the InnoDB storage engine and work only with MyISAM
storage engine, just delete these files and start the server with
skip-innodb from the command line or edit the my.ini file.

Regards,
miguel


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

ibdata1 file in mysql/data directory

Hi, folks -

I'm trying to build a new configuration in a student lab. I'm limited
to 20MB of data, per the University's restrictions on the amount of
storage any student may have allocated.

I keep running out of space and have found a file called ibdata1 in the
mysql\data directory which seems to usually be around 10.5MB in size. It
seems to be something that's described by the three files in each of the
database directories (*.frm, *.MYD, *.MYI) and might possibly be the
actual data. I have several questions:

1. Does this file do what I think it does?
2. Is there anything that can be done to reduce its size?

I've tried to reduce the size by reducing the number of databases, the
number of tables in particular databases, and the number of fields in
particular tables. None of these seem to work.

The databases that the students will be using are all quite small:
less than 15 fields in any table, 10 or less records in any table, not
more than three tables in any database, not more four databases for the
whole term.

BTW - The files defining things generally total something less than 30KB
per database.

Can anybody shed any light on this for me, please?

Thanks.

virginia

--
\ / Virginia R. Hetrick, here in sunny California
0 Voicemail: 310.471.1766 Email: drjuice@gte.net
Oo "There is always hope."
My health site: http://www.yana.org/hetrick
Site of the month: http://www.washington.edu/cambots/camera1_l.gif



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: ibdata1 file in mysql/data directory

At 8:18 -0700 10/19/04, Dr. Virginia R. Hetrick wrote:
>Hi, folks -
>
>I'm trying to build a new configuration in a student lab. I'm
>limited to 20MB of data, per the University's restrictions on the
>amount of storage any student may have allocated.
>I keep running out of space and have found a file called ibdata1 in
>the mysql\data directory which seems to usually be around 10.5MB in
>size. It seems to be something that's described by the three files
>in each of the database directories (*.frm, *.MYD, *.MYI) and might
>possibly be the actual data. I have several questions:
>
>1. Does this file do what I think it does?
>2. Is there anything that can be done to reduce its size?
>
>I've tried to reduce the size by reducing the number of databases,
>the number of tables in particular databases, and the number of
>fields in particular tables. None of these seem to work.
>The databases that the students will be using are all quite small:
>less than 15 fields in any table, 10 or less records in any table,
>not more than three tables in any database, not more four databases
>for the whole term.
>
>BTW - The files defining things generally total something less than
>30KB per database.
>
>Can anybody shed any light on this for me, please?

It's the default InnoDB tablespace file. InnoDB will create this unless
you disable InnoDB by running the server with the --skip-innodb option.
If you do that, you can throw away the existing ibdata file and the ib_log*
files.

The minimum size for the InnoDB tablespace is 10MB.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: ibdata1 file in mysql/data directory

Thanks to both of you.

I was using a v.3 actual printed manual (sorry) and when I got the v.4 manual I found what I was looking for.

In sum, for people searching the archives,

I can set the amount of tablespace for the INNODB files to a relatively small number, say, 5MB, which should give the students enough space for their small tables and a little room for their other courses as well.

Thanks again for the help.

virginia

\ / Virginia R. Hetrick, here in sunny California
0 Voicemail: 310.471.1766 Email: drjuice@gte.net
Oo "There is always hope."
My health site: http://www.yana.org/hetrick
Site of the month: http://www.washington.edu


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org