Monitor disc space on RT/SQL database

I need to know how to monitor available space for my RT database. I am very much a novice regarding SQL db administration. Are there any other areas I should keep my eye on to avoid any future RT db problems?

I am running RT on a FC4 box and my installation is in /opt/rt3. Thanks for any help.

Shannon

Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. Home | Yahoo Mobile

I believe that Webmin can do this.

http://www.webmin.com-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Shannon Adams
Sent: Monday, February 18, 2008 2:51 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Monitor disc space on RT/SQL database

I need to know how to monitor available space for my RT database. I am very
much a novice regarding SQL db administration. Are there any other areas I
should keep my eye on to avoid any future RT db problems?

I am running RT on a FC4 box and my installation is in /opt/rt3. Thanks for
any help.

Shannon

Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.7/1285 - Release Date: 2/18/2008
5:50 AM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.7/1285 - Release Date: 2/18/2008
5:50 AM

Try nagios, there are several plugins for mysql, this could help.

Torsten

Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Alfred Manke, Thorsten Meincke, Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: ‘Shannon Adams’ shannon_adams68@yahoo.com
CC: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Mon Feb 18 22:05:22 2008
Subject: Re: [rt-users] Monitor disc space on RT/SQL database

I believe that Webmin can do this.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Shannon Adams
Sent: Monday, February 18, 2008 2:51 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Monitor disc space on RT/SQL database

I need to know how to monitor available space for my RT database. I am very
much a novice regarding SQL db administration. Are there any other areas I
should keep my eye on to avoid any future RT db problems?

I am running RT on a FC4 box and my installation is in /opt/rt3. Thanks for
any help.

Shannon

Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.7/1285 - Release Date: 2/18/2008
5:50 AM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.7/1285 - Release Date: 2/18/2008
5:50 AM

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

You can do something like:

If this is mysql, you can do something like this in mysql client:

use rt3; (or whatever your rt3 database is)
show table status;

Shannon Adams wrote:

I need to know how to monitor available space for my RT database. I
am very much a novice regarding SQL db administration. Are there any
other areas I should keep my eye on to avoid any future RT db problems?

If this is mysql, you can do something like this in mysql client:

use rt3; (or whatever your rt3 database is)
show table status;

Providing you’ve got $HOME/.my.cnf setup correctly to give to direct
access to the RT mysql database:

$ echo “show table status;” | mysql |
awk ‘{tot+=$7}END{print "DB using " tot / (1024 * 1024) “Mb”}’;
df -h /var/lib/mysql

Cheers
Toby

LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform postmaster@ccdc.cam.ac.uk and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.