>> 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 [EMAIL PROTECTED] 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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
