utely last question (only
just occurred to me): will the space in the file used
by the deleted data be reused?
Thx
Lawrence Smith
=
http://www.explanation-guide.info
BT Yahoo! Broadband - Free modem offe
Heikki,
thanks for the reply, will note.
Just to confirm if I understand the situation
correctly: innodb datafiles cannot be reduced in size
to reclaim spaced freed by deleted data? (That'd
probably explain why I had a hard time finding ISPs
offering innodb-enabled MySQL).
Lawrence
--- Jeff Mathis <[EMAIL PROTECTED]> wrote: >
someone will no doubt echo what I'm about to say.
> InnoDB files are created at startup. the files use
> all the disk you
> allocate to them in your my.cnf startup file.
>
> If you want smaller InnoDB files, specify a smaller
> file size in your
> my
I have recently dropped a database with a big innodb
table in it - but the data file (ibdata1) failed to
get smaller. It's pretty big (nearly 2GB) and I'd like
to
reduce it if possible. Is there any way to do this?
Thx
BT
