select table_schema "Database",
sum( data_length + index_length ) / 1024 / 1024 "Size (MB)",
sum( data_free )/ 1024 / 1024 "Free (MB)"
from information_schema.tables
group by table_schema ;
This will work in mySQL 5.0.2 and newer. Use SHOW TABLE STATUS command for other versions.
Sybase:
before 12.5: buildmaster (bldmatr for NT)
buildmaster -d master_device -s size_in_2k_pages
12.5 and later: dataserver with some options (sqlsvr for NT)
dataserver -d master_device -b size -forcebuild -z page_size -Z size_of_master_db
MS SQL:
before MS 2005:
rebuildm utility (GUI)
MS SQL 2005:
#!/usr/bin/ksh
echo "Started..."
print -u2 -n "Enter password:"
stty -echo
read PASS
stty echo
print
rm -f databases.lst
isql -U sa -S $DSQUERY -w 999<
$PASS
select 'DBLABEL' "XXX", name from master..sysdatabases
go
exit
EOF
for DB in $(cat databases.lst) ; do
print -u2 "Processing $DB ..."
isql -U sa -S $DSQUERY -w 999 -D $DB <