MySQL Database Administration HELP!

[gamma_one]

I have an INNODB installation that has caused me some problems recently
with the data files growing beyond the UNIX file size limits. I have
everything back to normal but,

My question: is there a mysql systems table or variable that I can get
the:

-Current space allocated?
-Current space used?

OR does anyone already have an SQL statement that will get this
information?

Please help!

[Bill Karwin]

gamma_one wrote:

I have an INNODB installation that has caused me some problems recently
with the data files growing beyond the UNIX file size limits.

You should specify multiple innodb tablespace files, with size limits
for each file.

See:
http://dev.mysql.com/doc/mysql/en/in...iguration.html
http://dev.mysql.com/doc/mysql/en/ad...-removing.html

Regards,
Bill K.

[Thomas Bartkus]

"gamma_one" <ga********@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I have an INNODB installation that has caused me some problems recently
with the data files growing beyond the UNIX file size limits. I have
everything back to normal but,

My question: is there a mysql systems table or variable that I can get
the:

-Current space allocated?
-Current space used?

For UNIX/Linux systems try
df -h to display each disk partition with it's Size, Used, Avail, and
%Use
and
du {directory} to show a breakdown of disk space usage by the directory
structure.

For dedicated mysql servers - happiness is having the mysql data on a disk
partition of it's own. Happier still if this partition is on it's own fast
drive.
Thomas Bartkus

[Gordon Burditt]

>> I have an INNODB installation that has caused me some problems recently

with the data files growing beyond the UNIX file size limits. I have
everything back to normal but,

My question: is there a mysql systems table or variable that I can get
the:

-Current space allocated?
-Current space used?

For UNIX/Linux systems try
df -h to display each disk partition with it's Size, Used, Avail, and
%Use
and
du {directory} to show a breakdown of disk space usage by the directory
structure.

Innodb tables are kept in large files that are preallocated (at
least there is some preallocation. And if you drop tables, the
files don't shrink, but the space may get re-used). df and du are
useless for telling how much free space there is within the file.
For dedicated mysql servers - happiness is having the mysql data on a disk
partition of it's own. Happier still if this partition is on it's own fast
drive.

Which still won't help in finding out how full your Innodb files
are.

Gordon L. Burditt

[Thomas Bartkus]

"Gordon Burditt" <go***********@burditt.org> wrote in message
news:11*************@corp.supernews.com...

I have an INNODB installation that has caused me some problems recently
with the data files growing beyond the UNIX file size limits. I have
everything back to normal but,

My question: is there a mysql systems table or variable that I can get
the:

-Current space allocated?
-Current space used?

For UNIX/Linux systems try
df -h to display each disk partition with it's Size, Used, Avail, and
%Use
and
du {directory} to show a breakdown of disk space usage by the directory
structure.

Innodb tables are kept in large files that are preallocated (at
least there is some preallocation. And if you drop tables, the
files don't shrink, but the space may get re-used). df and du are
useless for telling how much free space there is within the file.

For dedicated mysql servers - happiness is having the mysql data on a diskpartition of it's own. Happier still if this partition is on it's own fastdrive.

Which still won't help in finding out how full your Innodb files
are.

Gordon L. Burditt

Sometimes I volunteer answers to these posts as a check to see if I really
know what I'm talking about :-) I haven't played with nor had I considered
that Innodb tables would work so differently.

Thank You for setting me straight.
Thomas Bartkus