469,902 Members | 1,813 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

MySQL Database Administration HELP!

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!

Sep 14 '05 #1
4 1340
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.
Sep 14 '05 #2
"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
Sep 15 '05 #3
>> 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
Sep 15 '05 #4
"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
Sep 15 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Xizor | last post: by
reply views Thread by Rob Young | last post: by
51 posts views Thread by w_curtis | last post: by
reply views Thread by Bob M | last post: by
reply views Thread by Enrique Ariz?n Benito | last post: by
175 posts views Thread by Sai Hertz And Control Systems | last post: by
2 posts views Thread by areejan2000 | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.